Rows
Columns
Fields
Records
Data
100

 This type database consists of a collection of tables, each of which contains information on a specific subject.

What is a relational database?
100

A field whose data type is this can contain any characters.

What is short text?
100

When you assign this to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.

What is a caption?
100

To add a record to a table, tap or click this record button.

What is new (blank) record button?

100
This refers to the process of determining the tables and fields that make up the database.
What is database design?
200
Another name for the Primary Key.
What is a unique identifier?
200

This data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

What is long text?
200

To define an additional field in Datasheet view, tap or click this column heading.

What is the "click to add" field.
200

You can place an insertion point by tapping or clicking in the field or by pressing this key.

What is F2?
200
In a table, the rows are called this.
What is a record?
300
Access is this type of system.
What is a database management system?
300

A field with this data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

What is auto-number?
300

To show the symbol for the Euro instead of the dollar sign, change this property for the field whose data type is Currency.

What is the format property?

300

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click this , and then tap or click Proofing in the dialog box that displays.

What is OPTIONS?
300
In designing a database, you want to omit this to help to produce good and valid database design.
What is redundancy?
400

This contains information about a given person, product, or event.

What is a record?
400

A field with this data type can contain an attached file, such as an image, document, chart, or spreadsheet.

What is an attachment field.
400

To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click this on the shortcut menu.

What is delete?
400

To save the changes to the layout of a table, tap or click the Save button located here.

What is the Quick Access Toolbar?
400
Data type recommended for Social Security Numbers is this.
What is short text?
500

These  words are words that have a special meaning to Access and cannot be used for the names of fields.

What are reserved words?
500

A field whose data type is this can store text that can be used as a hyperlink address.

What is a hyperlink field?
500

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click this on the shortcut menu.

What is insert field?
500

To view the results of a saved query, right-click the query in the Navigation Pane and tap or click this on the shortcut menu.

What is OPEN?
500
Database file names cannot contain these two characters.
What is the colon and the question mark?
M
e
n
u