Access 2016 Intermediate

Access 2016

Lesson 7 – Using Advanced Database Features

E XERCISE

U SING A DVANCED D ATABASE F EATURES



Task

Use advanced database features.

1. Open ADVDATX.ACCDB . 2. Print a relationship document. Then, close the print preview, Report , and the

Relationships windows, as needed; do not save the changes. 3. Import the Sales by Rep 2 query from QWIZARD1X.ACCDB . 4. Add a link to the Sales table in QWIZARD1X.ACCDB .

5. Open the Linked Table Manager and update the link to the Types table. Correct its path to QWIZARD1X.ACCDB in the student data folder. Then, select OK as necessary and close the Linked Table Manager . 6. Make sure that the Name AutoCorrect option is enabled. Then, change the name of the LAST_NAME field in the Reps table to LastN and close the Reps table, saving the changes. 7. Open the Reps form in Design view. Notice that, although the label in the Form Header area has not changed, the control source in the Detail area has been corrected to LastN . Close the Reps form. 8. Compact ADVDATX.ACCDB . Then, close ADVDATX.ACCDB . 9. Open DATA2003.MDB . Convert DATA2003.MDB , saving it as Data 2007.ACCDB . 10. Export the Customer Addresses query to ADVDATX.ACCDB ; accept the default name. 11. Close the database file.

OFFICEPRO, Inc.

Page 139