Exam 1: Create Database Tables

A(n) ________ key is a field used to relate records in a second table.

A(n) ________ is a collection of related information that displays in a single row of a database table.

Once an AutoNumber value has been assigned, it CANNOT be changed.

A(n) ________ displays related records from a table on the one side of the relationship.

Use the ________ button to adjust the entire datasheet's column widths at once.

While importing an Excel spreadsheet into Access, if the user chooses Append a copy of the records to the table but the table does not exist, Access will ________.

The name ________ is temporarily assigned to the new table that opens automatically when a blank database is created.

Match each definition with the appropriate term. A) Expand row B) Append row C) Junction key D) Subdatasheet E) Worksheet F) Foreign key G) Primary key H) Datasheet I) Composite key J) Subordinate 96) Displays data in rows and columns similar to an Excel spreadsheet 97) Where a new record is added to a table 98) Field that uniquely identifies each record in a table 99) Field used to relate records in another table 100) Displays related records from the table on the many side of the relationship

While importing an Excel spreadsheet into Access, if the user chooses Append a copy of the records to the table and the table exists, Access will add the records to the table.

Datasheets can be sorted and ________ to make the information useful.

________ can be used to view a report before it is sent to the printer.

Table Design view is a view that features table fields and their properties.

You can assign a name and location for the database file any time after entering data.

The Date Picker feature allows the user to enter dates by clicking on a calendar.

The database object that stores the data is a(n) ________.

With a cascading update, the user can edit the primary key value in a table, and all the related records in the other table will update.

In a ________, the user can edit the primary key value in a table and all the related records in the other table will update accordingly.

Portrait is the default view that is applied each time a table is opened.

In Design view, the Field Name, Data Type, and Description data are entered in rows.

Landscape is a layout that is wider than it is tall.