Access 2016 Intermediate

Access 2016

Lesson 7 – Using Advanced Database Features

Steps

Practice Data

7. Select OK .

Click

Access prints the desired document.

Close print preview.

C OMPACTING A D ATABASE



Discussion

When you delete tables and other objects in a database, the database size on the disk does not necessarily decrease. Access provides a utility that compacts (defragments) the database, thereby releasing storage space.

You can create a copy of the original database by saving the compacted database with a different name or to a different location. Although you can compact the current database while it is open, the database must be closed in order to make a copy.



Procedures

1. Open the database you want to compact.

2. Select the File tab

.

3. Select the Compact and Repair Database button

.



Step-by-Step

Compact a database.

Steps

Practice Data

1. Select the File tab.

Click

The Backstage view opens.

OFFICEPRO, Inc.

Page 133