Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 3

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

Accepted Answer

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

Question 4

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 5

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

Accepted Answer

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

Question 6

An Access database is limited to a size of 1 gigabyte.

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

Which data type links files created in other programs such as pictures or documents?

Accepted Answer

A)  Lookup 
B)  Attachment 
C)  Yes/No 
D)  Link Wizard 
A)  Lookup 
B)  Attachment 
C)  Yes/No 
D)  Link Wizard

Question 10

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

Accepted Answer

A)  FILE 
B)  VIEW 
C)  PREVIEW 
D)  REPORT 
A)  FILE 
B)  VIEW 
C)  PREVIEW 
D)  REPORT

Question 11

What are the advantages of using Access for database management?

Accepted Answer

1. Duplicate data is minimized.
2. Infor

Question 12

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 13

-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 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 subdatasheet shows the records on the "many" side of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 16

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

Accepted Answer

A)  Edit mode 
B)  Navigation mode 
C)  Update mode 
D)  Form mode 
A)  Edit mode 
B)  Navigation mode 
C)  Update mode 
D)  Form mode

Question 17

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 18

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

Accepted Answer

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

Question 19

Which is NOT a feature of Access reports?

Accepted Answer

A)  headers 
B)  footers 
C)  calculations on groups of records 
D)  easy-to-use data entry screen 
A)  headers 
B)  footers 
C)  calculations on groups of records 
D)  easy-to-use data entry screen

Question 20

____________________ View is a spreadsheet-like view of the data in a table.

Accepted Answer

The answer of ____________________ View is a spreadsheet-like view of...

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

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

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

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

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

An Access database is limited to a size of 1 gigabyte.

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

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

Which data type links files created in other programs such as pictures or documents?

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

What are the advantages of using Access for database management?

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

-In the accompanying figure, Customers is a ____ tab.

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

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

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

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

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

Which is NOT a feature of Access reports?

____________________ View is a spreadsheet-like view of the data in a table.

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

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

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

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

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

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

An Access database is limited to a size of 1 gigabyte.

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

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

Which data type links files created in other programs such as pictures or documents?

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

What are the advantages of using Access for database management?

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

-In the accompanying figure, Customers is a ____ tab.

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

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

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

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

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

Which is NOT a feature of Access reports?

____________________ View is a spreadsheet-like view of the data in a table.

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