Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.
Always let Access create a primary key when you import data to a new table.
Rerunning an import appends data to a table.
Before you import data, you should use Excel to do the following:
Make sure your images render properly in your source data.
Remove any unwanted data, such as blank rows or columns, and fix any obvious errors such as #NUM.
Make sure your formulas are all on the same worksheet.
The import process has the following limits:
No more than 65,000 rows.
No more than 255 columns.
No more than 256,000 text characters.
No more than 1,024 images.
If you leave a column in your source data, you're stuck with it in your Access table.