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

External Data: Primary Key The original data in the Excel spreadsheet did not have a unique number for each record. It is not indexed, yet. This step creates a Primary Key.   7. Try it: Create a Primary Key The Import Wizard is on step 5. There is a new First Column, ID. What Do You See? The Import Wizard offers three choices for the Primary Key: Let Access add primary key Choose my own primary key No primary key.   Select an option: Let Access add primary key   Click Next. Keep going... External Data ->Import & Link->Excel