Question 1

Records are characteristics that define the appearance and behavior of items in the database such as objects, fields, sections, and controls. ____________________

Accepted Answer

A) True 
 B)False

Question 2

Match each term with the best choice.
-Creates a new table from all or part of the data in one or more tables

Accepted Answer

A) Make Table query 
B) Append query 
C) Delete query 
D) Action query 
E) Update query 
A) Make Table query 
B) Append query 
C) Delete query 
D) Action query 
E) Update query

Question 3

Match each term with the best choice.
-Makes global changes to the values in a field

Accepted Answer

A) Make Table query 
B) Append query 
C) Delete query 
D) Action query 
E) Update query 
A) Make Table query 
B) Append query 
C) Delete query 
D) Action query 
E) Update query

Question 4

-In the figure above, item 1 refers to which feature?

Accepted Answer

A)  Group By 
B)  Totals 
C)  Top Values 
D)  Query Type 
A)  Group By 
B)  Totals 
C)  Top Values 
D)  Query Type

Question 5

When building an action query, data will not be changed until you click the ____ button.

Accepted Answer

A)  Datasheet 
B)  Query Type 
C)  Run 
D)  Update 
A)  Datasheet 
B)  Query Type 
C)  Run 
D)  Update

Records are characteristics that define the appearance and behavior of items in the database such as objects, fields, sections, and controls. ____________________

Match each term with the best choice. -Creates a new table from all or part of the data in one or more tables

Match each term with the best choice. -Makes global changes to the values in a field

-In the figure above, item 1 refers to which feature?

When building an action query, data will not be changed until you click the ____ button.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 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 Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 12: Creating Advanced Queries

Records are characteristics that define the appearance and behavior of items in the database such as objects, fields, sections, and controls. ____________________

Match each term with the best choice. -Creates a new table from all or part of the data in one or more tables

Match each term with the best choice. -Makes global changes to the values in a field

-In the figure above, item 1 refers to which feature?

When building an action query, data will not be changed until you click the ____ button.

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 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 Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters