graphic1

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

External Data: Column Headings

This sample spreadsheet has a Header Row. The Header Row contains all of the data field names. This step lets you identify the Column Headings.

 

5. Try it: Use Column Headings for Field Names

The database is still open.

The Import Wizard is on step 3.

Select: First Row Contains Column Headings.

 

What Do You See? The first Row is now selected for the Field Names.

 

Click Next.

Keep going...

External Data ->Import & Link->Excel

graphic2