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...
Which of the following statements is false?
a. Path method isAbsolute returns a boolean indicating whether a Path represents an absolute path to a file or directory. b. Files static method getLastModifiedTime receives a Path and returns a FileTime (package java.nio.file.attribute) indicating when the file was last modified. c. Files static method size receives a Path and returns a long representing the number of bytes in the file or directory. For directories, the value returned is platform specific. d. All of the above are true.
The StringBuilder methods _____________ not only change the contents of a string buffer, but also returns a reference to the string buffer.
a. delete b. append c. insert d. reverse e. replace
What is a phishing scam? Provide an example.
What will be an ideal response?
The background color does not correspond to the CSS background-color property.
Answer the following statement true (T) or false (F)