Exam 23: Getting Started With Access Essentials

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

A ____ finds and shows data that meets specified criteria.

In a datasheet, fields are displayed as rows . ____________________

In Access, multiple databases can be opened at the same time.

Field ____________________ define the characteristics and behavior of a field.

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.

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.

In Access, data can be imported or linked from Outlook.

The primary key is useful in sorting records.

Access is the Microsoft Office ____________________ application.

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

All data in a database is stored in a ____.

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

A ____ is a single piece of database information.

Access is a(n) ____________________ database management system.

The default data type for a field is ____.

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?

Which of the following is NOT true about databases?

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

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