Why is it so important to prepare the Excel data before it is added to Access? What other types of guidelines should be used? What other tools are available for cleansing the data?
What will be an ideal response?
Blank rows, misspellings, duplicate data, and mismatched fields are just a few problems that will prevent the Excel data from being added correctly to an Access table. Data should be consistent in Excel before it is added to Access. For example, a field for a state name should be either spelled out or abbreviated, but not a combination of both. There are many functions you can use in Excel to cleanse the data. CONCATENATE, TEXT, DATE, LOWER, UPPER, and TRIM are just a few of the functions that will help make your data ready to add to Access.
You might also like to view...
Symmetric encryption uses two keys
Indicate whether the statement is true or false.
Answer the following statements true (T) or false (F)
1. A class declaration creates an object. 2. A private member function may only be called from a function that is a member of the same class. 3. A constructor is a public class function that gets called whenever you want to re-initialize an object's member data. 4. A class can have a member variable that is an instance of another class. This is called object nesting.