Access 2016 Advanced

Access 2016

Lesson 2 – Exploring Access

If necessary, display All Access Objects in the Navigation Pane.

Steps

Practice Data

1. On the Database Tools tab, click the Analyze Table button. The Table Analyzer Wizard opens.

Click

2. Select Next > .

Click

The next page of the Table Analyzer Wizard appears.

3. Select Next > .

Click

The next page of the Table Analyzer Wizard appears.

4. Select the table you want to analyze. The table name is selected.

Click Order Items

5. Select Next > .

Click

The next page of the Table Analyzer Wizard appears.

6. Select whether or not you want to allow the Table Analyzer Wizard to decide which fields are put in each table. The option is selected.

Click

Yes, let the

wizard decide. , if necessary

7. Select Next > .

Click

The next page of the Table Analyzer Wizard appears.

8. Double-click the title bar of the first table. A Table Analyzer Wizard dialog box opens with the text in the Table Name box selected.

Double-click the Table1 title bar

9. Type the desired table name.

Type Line Items

The name appears in the Table Name box.

10. Select OK .

Click

The Table Analyzer Wizard dialog box closes, and the new name appears in the table title bar.

OFFICEPRO, Inc.

Page 19