Exam 23: Getting Started With Access Essentials

A(n) database is a collection of related information. ____________________

To remove a field from a table along with its content, you must delete its _____.

The ____________________ key prevents duplicate entries.

A datasheet is the primary object in a database.

To move the insertion point to the previous field in Datasheet view, press ____.

A ____ organizes data in a specific layout.

A ____ makes it easy for you to view, enter, and edit data.

Pilar is creating a new database for her business. Pilar wants to store information about customers' orders, as well as product details of her inventory. She should create separate ____ for each.

The report object simplifies the process of viewing, entering, and editing table data.

Both Datasheet view and Design view let you add new fields.

A relational database organizes information into separate subject-based tables.

The _____ property in Access specifies how numbers, dates, times, and text are displayed.

By default, a table opens in _____ view.

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

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 ____.

A field property is a label that helps identify the field.

Design view shows details about the structure of the object, including the data type and field properties. ____________________

The default name for a new table is ______.

By default, a table opens in Datasheet view. ____________________