SECTION 1
Lesson 1.2: Database Management

   

 

 Access gives you the ability to adjust the file properties of a particular database file. To see the properties of a database, first open a database, make sure the Database window is open and active, and click File à Database Properties:

 

There are five tabs across the top of the window:

General

The General tab gives a quick biography of the file, where it is saved, how big it is, when it was last modified, etc.

Summary

The Summary tab allows you to fill in details about the person/organization that owns or uses the file.

Statistics

Statistics are kept about when the file was created, last modified, last accessed, and last printed. It also records which user made the last modifications, what revision number the database is, and how long it has been worked on since creation.

Contents

The Contents tab summarizes the contents of the database file giving the name of each table, query, report, etc.

Custom

The Custom tab allows you to create a custom property to the database. For example, if you made a file and want to let others know how to reach you if they have a question, you can add your own phone number to the file properties.