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
Made with FlippingBook - Online magazine maker