12. Managing a Database

What You’ll Do

Back Up a Database

Compact and Repair a Database

Change Database Properties

Document a Database

Analyze a Database

Use Add-Ins

Create a Database Switchboard

Manage a Switchboard

Add a Database Title and Icon

Split a Database

Introduction

Access provides tools that help your database operate more efficiently. This includes the ability to compact your database file and to repair it if it is damaged, or split up your database to reduce its size. You can also use Access to analyze the design of your database and tables in order to improve performance and reliability. In addition, Access helps you keep tabs on all the elements in a database with the Documenter utility.

Add-ins are additional programs, designed ...

Get Microsoft® Office Access 2007 on Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.