Question 1

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?

Accepted Answer

A)  Paragraph 
B)  Comment 
C)  Long Text 
D)  System

Question 2

Match between columns
                        Premises: First field of the current record

Accepted Answer

The Answer of [Ctrl][Home] and [End] and [Down Arrow] and is...

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of A(n) ____________________ field automatically assigns a new...

Question 5

Match between columns
                        Premises: Current field of the next record

Accepted Answer

The Answer of [End] and [Ctrl][Home] and [Home] and [Left is...

Question 6

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

Accepted Answer

A)  query 
B)  form 
C)  table 
D)  module

Question 7

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

Accepted Answer

The answer of Characteristics, such as Field Name and Data...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is NOT a data type?

Accepted Answer

A)  Number 
B)  Formula 
C)  Date/Time 
D)  Short Text

Question 10

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

Accepted Answer

The answer of Relational ____________________ software is used to manage...

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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?

Accepted Answer

A)  Text 
B)  Number 
C)  Monetary 
D)  Currency

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A)  [Home] 
B)  [End] 
C)  [F4] 
D)  [F5]

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A)  [Insert] 
B)  [Home] 
C)  [Ctrl] 
D)  [Backspace]

Question 17

In Access, data entry screens are called forms .

Accepted Answer

A) True 
 B)False

Question 18

Which data type stores only one of two values?

Accepted Answer

A)  Attachment 
B)  Hyperlink 
C)  Yes/No 
D)  Null

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A)  [End] 
B)  [Page Down] 
C)  [Down Arrow] 
D)  [Enter]

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?

Match the shortcut keystrokes to the correct action.

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.

Match the shortcut keystrokes to the correct action.

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.

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?

Match the shortcut keystrokes to the correct action.

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.

Match the shortcut keystrokes to the correct action.

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.

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