Question 1

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 2

What are the advantages of using Access for database management?

Accepted Answer

1.  Duplicate data is minimized. 
2.  In

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 primary key field uniquely identifies each record.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Accepted Answer

A)  record 
B)  table 
C)  database 
D)  object 
A)  record 
B)  table 
C)  database 
D)  object

Question 7

Which of the following is NOT available to you as you start Access?

Accepted Answer

A)  opening an existing database 
B)  recalibrating an existing database 
C)  creating a new database from a template 
D)  creating a new blank database 
A)  opening an existing database 
B)  recalibrating an existing database 
C)  creating a new database from a template 
D)  creating a new blank database

Question 8

In the accompanying figure, Customers is a ____ tab.

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

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

Tables, queries, and forms are examples of Access ____.

Accepted Answer

A)  entities 
B)  objects 
C)  values 
D)  controls 
A)  entities 
B)  objects 
C)  values 
D)  controls

Question 12

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

Accepted Answer

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

Question 13

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 14

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

Question 15

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 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] 
A)  [Insert] 
B)  [Home] 
C)  [Ctrl] 
D)  [Backspace]

Question 17

While editing a record, pressing [Esc] a second time ____.

Accepted Answer

A)  deletes the current field 
B)  deletes the current datasheet 
C)  removes all data from the current record 
D)  removes all changes made to the record you are currently editing 
A)  deletes the current field 
B)  deletes the current datasheet 
C)  removes all data from the current record 
D)  removes all changes made to the record you are currently editing

Question 18

____ 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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

What are the advantages of using Access for database management?

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

A primary key field uniquely identifies each record.

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

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Which of the following is NOT available to you as you start Access?

In the accompanying figure, Customers is a ____ tab.

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

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

Tables, queries, and forms are examples of Access ____.

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

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

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

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

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

While editing a record, pressing [Esc] a second time ____.

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

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

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

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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 1: Getting Started With Access 2013

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

What are the advantages of using Access for database management?

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

A primary key field uniquely identifies each record.

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

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Which of the following is NOT available to you as you start Access?

In the accompanying figure, Customers is a ____ tab.

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

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

Tables, queries, and forms are examples of Access ____.

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

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

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

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

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

While editing a record, pressing [Esc] a second time ____.

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

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

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

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 Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters