Access 2016 Intermediate

Lesson 7 - Using Advanced Database Features

Access 2016

Steps

Practice Data

2. Select the Compact and Repair

Database button in the Tools group. Access compacts and repairs the database.

Click

U SING N AME A UTO C ORRECT



Discussion

The Name AutoCorrect feature automatically fixes inconsistencies that can occur when you rename tables, forms, reports, queries, fields, or other controls in an Access database.

The Name AutoCorrect options must be enabled, however. The Track name AutoCorrect info option saves information about changes, but does not automatically repair the inconsistencies. When the Perform name AutoCorrect option is enabled, Access automatically corrects any differences between related objects. Furthermore, if you enable both options, you can also enable the Log name AutoCorrect changes option, which creates a table named Name AutoCorrect Log that documents changes.

Name AutoCorrect is enabled by default for new Access databases. However, if you are working in a converted database, you must manually enable it.

Page 134

OFFICEPRO, Inc.