graphic1

Exam 77-424: Microsoft Access 2013
2.0 Build Tables
2.1 Create a Table: Import External Data into Tables

External Data: Field Options

The Import Wizard will prompt you to review the Field Options for each Column in the spreadsheet.

 

6. Try it: Review the Field Options

The Import Wizard is on step 4.
The First Column, Movie, is selected.

What Do You See? The Field Options include:

File Name

Indexed: No (Duplicates are allowed)

Data Type: Short Text
 

Please accept the default answers for File Name, Indexed and Data Type.

 

Click Next.

Keep going...

External Data ->Import & Link->Excel

grpahic2