Exam 2: Access Lesson 2: Creating a Database

To set a table's primary key, click the Primary Key button in the Tools group on the Home tab.

In a table, the first key is the field that contains a unique field value for each record in the table.

You can create a new table in a database by clicking the ____________________ tab on the Ribbon, and then clicking the Table button in the Tables group.

You can only skip saving a table when you make changes to its layout.

Case AC 2-1 Ron is an IT Manager at a local grocery store and is cleaning up one of his databases. By the end of the day, Ron made hundreds of changes to the database, while in Design view. He wants the changes to appear in Datasheet view, too, so he ____ and Datasheet view is automatically updated

If a row selector for an ID field has a(n) ____ symbol in it, it indicates that the field is the table's primary key.