Question 1

A primary key field uniquely identifies each record.

Accepted Answer

A) True 
 B)False

Question 2

If the Navigation Pane is not open, click the _____ to open it and view the database objects.​

Accepted Answer

A)  ​View Button 
B)  ​Open/Close Navigation Button 
C)  ​View Database Objects Button 
D)  ​Shutter Bar Open/Close Button

Question 3

"Focus" refers to which data you would edit if you started typing.

Accepted Answer

A) True 
 B)False

Question 4

The [F2] key switches between Edit and Navigation modes.

Accepted Answer

A) True 
 B)False

Question 5

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator.

Accepted Answer

A) True 
 B)False

Question 6

Each object in an Access database application displays at the left side of the Access window in the ____.

Accepted Answer

A)  Pinned space 
B)  Navigation Pane 
C)  Objects Bar 
D)  Objects Tab

Question 7

Which data type is used for sequential integers controlled by Access?

Accepted Answer

A)  Hyperlink 
B)  Web 
C)  Lookup Wizard 
D)  AutoNumber

Question 8

Match between columns
                        Premises: Current field of the previous record

Accepted Answer

The Answer of [Home] and [Left Arrow] and [Up Arrow] is...

Question 9

Case 1-1 
Hannah wants to create a record keeping system to track the inventory needed to efficiently run her lawn and landscape business, such as spare parts, gas cans, string trimmers, etc. Her crew manager will also be using the system. Hannah is considering whether to use Excel or Access. 
-Which one of the following is NOT a benefit of using Access?

Accepted Answer

A)  More data storage 
B)  Multiuser capability 
C)  Easier setup 
D)  Additional reporting features

Question 10

Match between columns
                        Premises: Previous field of the current record

Accepted Answer

The Answer of [Ctrl][Home] and [End] and [Tab] and [Up is...

Question 11

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

Accepted Answer

The answer of The Database window displays the tables, queries,...

Question 12

A(n) ____________________ key field contains unique data for each record.

Accepted Answer

The answer of A(n) ____________________ key field contains unique data...

Question 13

The ____________________ refers to which data you would edit if you started typing.

Accepted Answer

The answer of The ____________________ refers to which data you...

Question 14

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

Accepted Answer

A) True 
 B)False

Question 15

A(n) ____________________ object provides an easy-to-use data entry screen.

Accepted Answer

The answer of A(n) ____________________ object provides an easy-to-use data...

Exam 5: Module 1 Getting Started With Access

A primary key field uniquely identifies each record.

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

"Focus" refers to which data you would edit if you started typing.

The [F2] key switches between Edit and Navigation modes.

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator.

Each object in an Access database application displays at the left side of the Access window in the ____.

Which data type is used for sequential integers controlled by Access?

Match the shortcut keystrokes to the correct action.

Match the shortcut keystrokes to the correct action.

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

A(n) ____________________ key field contains unique data for each record.

The ____________________ refers to which data you would edit if you started typing.

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

A(n) ____________________ object provides an easy-to-use data entry screen.

Exam 5: Module 1 Getting Started With Access

A primary key field uniquely identifies each record.

If the Navigation Pane is not open, click the _____ to open it and view the database objects.​

"Focus" refers to which data you would edit if you started typing.

The [F2] key switches between Edit and Navigation modes.

To adjust the column width in a datasheet to accommodate the widest entry in a field, right-click the column separator.

Each object in an Access database application displays at the left side of the Access window in the ____.

Which data type is used for sequential integers controlled by Access?

Match the shortcut keystrokes to the correct action.

Match the shortcut keystrokes to the correct action.

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

A(n) ____________________ key field contains unique data for each record.

The ____________________ refers to which data you would edit if you started typing.

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

A(n) ____________________ object provides an easy-to-use data entry screen.

If the Navigation Pane is not open, click the _____ to open it and view the database objects.