Exam 5: Module 1 Getting Started With Access

Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. -Lauren has written a paragraph describing the use for each inventory item. Which data type should she use to define the field that will store this information?

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode.

A(n) ____________________ field automatically assigns a new number each time you add a record.

Which Access object contains all of the raw data within the database?

Characteristics, such as Field Name and Data Type, are ____________________  that define a field.​

No two records can have the same value in the primary key field.

Which of the following is NOT a data type?

Relational ____________________ software is used to manage data that can be organized into lists, such as information about customers, products, vendors, employees, projects, or sales.

A(n) foreign key field is always on the "one" side of a one-to-many relationship between two tables.

Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. -A Purchase Price field should be which data type?

The navigation buttons on a datasheet display the total number of fields in the datasheet.

Which shortcut key moves focus to the first field of the current record?

Press [Esc] once to undo a change to the current field.

Which of the following keys will help you delete unwanted data in Edit mode?

In Access, data entry screens are called forms .

Which data type stores only one of two values?

You can use the Calendar Box to enter dates in a Date/Time field.

In Navigation mode, press [Tab] or ____ to move to the next field within the same record.