Exam 10: Creating a Database

Every table in a database must contain one field that is designated as the ID key field

The Caption property appears in a form or in Datasheet view in place of the field ____.

Text boxes, check boxes and list arrows are all ___________________ controls.

To insert a new field, click an existing field and then click the Insert ____ button in the Tools group.

A query extracts data from one or more database tables according to criteria that you set.

A database containing two or more tables of related information is called a ____ database.

Short Text is a(n) data type

Describe the difference between a simple and a relational database.

You work for a small pet shop and the store manager asks you to convert some of his paper records to an online system. A simple database exists and the owner wants to add to the existing database. Assuming that the existing database does not contain information related to sales in the table, how can you extend the database to track the purchases for each customer?

Split view is a(n) _____________________ that displays the data entry form above the underlying datasheet.

If the ____ for Manager Last Name is Last Name, that means that only Last Name will be displayed as the field name for this field in Datasheet view.

Records consist of  ____, which contain information about one aspect of a record.

To add a field to a table, you need to specify its data type.

You can edit text in fields by selecting it and typing new text or using the [____] key.

In the accompanying figure, item 1 points to the____.

The field description appears in the ____ bar and helps users understand what type of data should be entered for the field.

You work in the human resources department of a large company that uses Microsoft Access to track information before and after entering it into the company's administrative system. Your supervisor has asked you to add a field description to a field in the table. How can you do this?

In Design view, you use a grid to enter fields and specify field data types.

Each text box in a(n) form corresponds with a field in a table. 

As a ____ database management system, Access is particularly powerful because you can enter data once and then retrieve information from all or several tables as you need it.