Exam 23: Getting Started With Access Essentials

Which of the following is information that would be stored in a field?

The primary key is useful in sorting records.

When you work in Design view, the changes are saved as they are made.

In Design view, the table data looks much like a spreadsheet.

Access is the Microsoft Office ____________________ program.

Which of the following is NOT true about databases?

By default, a table opens in Datasheet view.

At least one table must be created before any additional objects can be created.

C.J. wants to modify a table in his database. C.J. wants to change the default Field Size property for a field with the Text data type from ____ characters to 50.

In a datasheet, fields are displayed as rows .

A database is a collection of related information.

Each of the objects and everything that you do in a database relies on the data stored in a form.

Pilar is creating a new database for her business. Pilar uses a unique product number for each product in her inventory. She makes the product number ____.

The ____________________ key prevents duplicate entries.

What is a database? Name a sample use for a database and two tables that database might contain. Name one similarity and one difference between Access and Excel. What is a relational database and how is it used?

To allow more space to show the table contents, you can close the Navigation Pane.