Exam 11: Access_Module_1

The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255.

Changing the column width in a datasheet changes the structure of a table.

Access is a ____.

To delete a record, tap or click the record selector for the record, and then press the ____ key(s).

Designing to omit ____________________ will help to produce good and valid database designs.

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

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

The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject. ____________________

To open the Navigation Pane, tap or click the ____ Button.

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

A field with the ____ 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.

In Datasheet view, a table is represented as a collection of rows and columns called a list.

Landscape orientation means the printout is across the length (height) of the page.

The rows in the tables are called ____________________.