Question 1

The navigation buttons are found at the top of the datasheet.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Tables contain all of the data in the database.

Accepted Answer

A) True 
 B)False

Question 4

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

Accepted Answer

A)  Hierarchical 
B)  Network 
C)  Schematic 
D)  Referential 
A)  Hierarchical 
B)  Network 
C)  Schematic 
D)  Referential

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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 11

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

Pressing [Ctrl][;] will insert the current date in a Date field.

Accepted Answer

A) True 
 B)False

Question 15

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 16

In the accompanying figure, CustomerRoster is a ____ tab.

Accepted Answer

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

Question 17

More than one person can be entering, updating, and using an Access database at the same time.

Accepted Answer

A) True 
 B)False

Question 18

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...

Question 19

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 20

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

Accepted Answer

1-to-many,

The navigation buttons are found at the top of the datasheet.

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

Tables contain all of the data in the database.

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

Which is NOT true about Access?

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

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

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

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

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

Critical Thinking Questions 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?

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

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.

Pressing [Ctrl][;] will insert the current date in a Date field.

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

In the accompanying figure, CustomerRoster is a ____ tab.

More than one person can be entering, updating, and using an Access database at the same time.

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

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

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

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters

Exam 1: Getting Started With Microsoft Office 2013

The navigation buttons are found at the top of the datasheet.

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

Tables contain all of the data in the database.

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

Which is NOT true about Access?

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

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

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

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

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

Critical Thinking Questions 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?

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

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.

Pressing [Ctrl][;] will insert the current date in a Date field.

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

In the accompanying figure, CustomerRoster is a ____ tab.

More than one person can be entering, updating, and using an Access database at the same time.

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

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

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

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters