Access 2016 Intermediate

Access 2016

Lesson 7 – Using Advanced Database Features

Steps

Practice Data

13. Select the First Row Contains Field Names option, if applicable. The First Row Contains Field Names option is selected .

Click First Row Contains Field Names

14. Select Next .

Click

The next page of the Import Text Wizard appears.

15. Modify field options as desired and select Next . The options are modified accordingly, and the next page of the Import Text Wizard appears. 16. Select the desired primary key option. The primary key option is selected . The next page of the Import Text Wizard appears with the insertion point in the Import to Table box. 18. Enter the desired table name. The text appears in the Import to Table box. 17. Select Next .

Click

Click

No primary key.

Click

Type Store Name by Rep

19. Select Finish .

Click

The Import Text Wizard message box notifies you when it has completed importing the file.

20. Select Close .

Click

The Import Text Wizard and the Import Text Wizard message box close.

Open the Store Name by Rep table in Datasheet view. Then, close the table.

OFFICEPRO, Inc.

Page 121