Exam 23: Getting Started With Access Essentials

Which of the following is NOT true about deleting and copying records and fields in Datasheet view?

To insert a table in a database, click the ____ tab on the Ribbon.

The field properties available depend on the data type selected.

When you create a new field, you can choose a(n) ____, such as text or numbers.

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

A ____ finds and shows data that meet a specified criteria.

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.

Access is a(n) ____________________ database management system.

All data in a database is stored in a ____.

-The default data type for a field is ____.

In Datasheet view, when a record is being edited, a(n) ____ icon appears to the left edge of the row.

-The above figure shows a table in ____ view.

C.J. wants to modify a table in his database. C.J. wants to easily edit the field properties in his table. He should work in ____ view.

A(n) ____ would store all of the information about an individual.

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

Field ____________________ define the characteristics and behavior of a field.

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

A table is often referred to as a(n) ____________________.

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