Access 2016 Quick Start

Manage a database

Manage a database

Add a primary key to a table

Create a primary key to associate data between multiple tables.

  1. In the Navigation Pane, right click a table, and select Design View.

  2. Select the field or fields you want to use as the primary key.

  3. Select Design > Primary Key.

For more info, see Add or change a primary key.

Primary key and foreign key shown between two Access datasheets

Tools group on the Design tab

Backup your database

  1. Select File > Save As.

  2. Under Database File Types, select Save Database As.

  3. Under Advanced, select Back Up Database and then select Save As.

    The default file name includes the source database and when the backup occurred.

  4. Select Save.

Backing up an Access database
Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.