Question 1

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

Accepted Answer

A) True 
 B)False

Question 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 
A)  Paragraph 
B)  Comment 
C)  Long Text 
D)  System

Question 3

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 4

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

Accepted Answer

The answer of A(n) ____________________ object allows a user to...

Question 5

A(n) ____________________ relationship describes when a record from one table is related to several records in another table.

Accepted Answer

one to man

Question 6

Match the shortcut keystrokes to the correct action.
-Last field of the last record

Accepted Answer

A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home] 
A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home]

Question 7

Field properties change depending on the data type of the field.

Accepted Answer

A) True 
 B)False

Question 8

Match the shortcut keystrokes to the correct action.
-Last field of the current record

Accepted Answer

A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home] 
A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home]

Question 9

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 
A)  More data storage 
B)  Multiuser capability 
C)  Easier setup 
D)  Additional reporting features

Question 10

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

Accepted Answer

A)  [Home] 
B)  [Shift][Tab] 
C)  [Up Arrow] 
D)  [F5] 
A)  [Home] 
B)  [Shift][Tab] 
C)  [Up Arrow] 
D)  [F5]

Question 11

Match the shortcut keystrokes to the correct action.
-First field of the first record

Accepted Answer

A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home] 
A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home]

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

A(n) ____________________ is a fundamental building block of a relational database because this object stores all of the data.

Accepted Answer

The answer of A(n) ____________________ is a fundamental building block...

Question 14

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

Accepted Answer

A) True 
 B)False

Question 15

Which is NOT true about Access?

Accepted Answer

A)  It can be used to create forms 
B)  It relates lists of information in a relational database. 
C)  Reporting is limited to 20 saved reports. 
D)  Multiple users can simultaneously enter and update data within Access. 
A)  It can be used to create forms 
B)  It relates lists of information in a relational database. 
C)  Reporting is limited to 20 saved reports. 
D)  Multiple users can simultaneously enter and update data within Access.

Question 16

Match the shortcut keystrokes to the correct action.
-Current field of the next record

Accepted Answer

A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home] 
A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home]

Question 17

Which data type stores only one of two values?

Accepted Answer

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

Question 18

The Forms and Reports at the left side of the Access window in the accompanying figure are contained in the ____.

Accepted Answer

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

Question 19

Match the shortcut keystrokes to the correct action.
-First field of the current record

Accepted Answer

A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home] 
A) [Left Arrow] 
B) [Tab] 
C) [Up Arrow] 
D) [Ctrl][End] 
E) [Home]
F)[End]
G)[Down Arrow]
H)[Ctrl][Home]

Question 20

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Accepted Answer

The answer of If you use ____________________ View to design...

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

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?

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

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

A(n) ____________________ relationship describes when a record from one table is related to several records in another table.

Match the shortcut keystrokes to the correct action. -Last field of the last record

Field properties change depending on the data type of the field.

Match the shortcut keystrokes to the correct action. -Last field of the current record

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

Match the shortcut keystrokes to the correct action. -First field of the first record

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

A(n) ____________________ is a fundamental building block of a relational database because this object stores all of the data.

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

Which is NOT true about Access?

Match the shortcut keystrokes to the correct action. -Current field of the next record

Which data type stores only one of two values?

The Forms and Reports at the left side of the Access window in the accompanying figure are contained in the ____.

Match the shortcut keystrokes to the correct action. -First field of the current record

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Getting Started With Microsoft Office 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 2: Getting Started With Exam Access 2013

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

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?

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

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

A(n) ____________________ relationship describes when a record from one table is related to several records in another table.

Match the shortcut keystrokes to the correct action. -Last field of the last record

Field properties change depending on the data type of the field.

Match the shortcut keystrokes to the correct action. -Last field of the current record

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

Match the shortcut keystrokes to the correct action. -First field of the first record

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

A(n) ____________________ is a fundamental building block of a relational database because this object stores all of the data.

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

Which is NOT true about Access?

Match the shortcut keystrokes to the correct action. -Current field of the next record

Which data type stores only one of two values?

The Forms and Reports at the left side of the Access window in the accompanying figure are contained in the ____.

Match the shortcut keystrokes to the correct action. -First field of the current record

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Getting Started With Microsoft Office 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters