Question 1

The field names that display on the left side of a crosstab query are called ________.

Accepted Answer

The answer of The field names that display on the...

Question 2

How do appended records appear in the destination table?

Accepted Answer

They appear in primary key ord

Question 3

An append query is used to add records to an existing table.

Accepted Answer

A) True 
 B)False

Question 4

Access does not have a way to identify duplicate values.

Accepted Answer

A) True 
 B)False

Question 5

A(n)________ query can be used for adding records to an existing table.

Accepted Answer

A) append 
B) update 
C) make table 
D) delete 
A) append 
B) update 
C) make table 
D) delete

Question 6

While reviewing a table,you find that the same customer was added to the customers table twice,you decide to run a(n)________ query to determine if there are any other records added multiple times.

Accepted Answer

The answer of While reviewing a table,you find that the...

Question 7

When running a delete query,you are prompted with a warning message.

Accepted Answer

A) True 
 B)False

Question 8

A(n)________ query is used to update or change data automatically based on criteria that you specify.

Accepted Answer

A) update 
B) append 
C) make table 
D) delete 
A) update 
B) append 
C) make table 
D) delete

Question 9

The type of data displayed in a crosstab query depends on which aggregate function you choose when creating the query.

Accepted Answer

A) True 
 B)False

Question 10

What are the four types of action queries?

Accepted Answer

update query,append

Question 11

A(n)________ query can be used to archive older records that need to be stored outside of the current table.

Accepted Answer

A) make table 
B) update 
C) delete 
D) append 
A) make table 
B) update 
C) delete 
D) append

Question 12

Which type of query calculates data using a sum,average,or other function and groups the results by two sets of values?

Accepted Answer

A) Crosstab query 
B) Append query 
C) Make table query 
D) Find duplicates query 
A) Crosstab query 
B) Append query 
C) Make table query 
D) Find duplicates query

Question 13

A ________ query makes it easy to correct errors or add values to blank fields.

Accepted Answer

The answer of A ________ query makes it easy to...

Question 14

What should you do before running a delete query?

Accepted Answer

Create a backup copy

Question 15

There is no way to verify that the correct records will be updated when using an update query.

Accepted Answer

A) True 
 B)False

Question 16

Delete,append,and update queries are all examples of a(n)________ query.

Accepted Answer

The answer of Delete,append,and update queries are all examples of...

Question 17

After becoming familiar with the data in a database,what should be the first step when creating an action query?

Accepted Answer

A) Backup the database 
B) Save the database in an earlier version 
C) Using design view,create the query 
D) Run the query 
A) Backup the database 
B) Save the database in an earlier version 
C) Using design view,create the query 
D) Run the query

Question 18

If you would like to add data from an Excel spreadsheet to an existing Access table,you might use a(n)________ query.

Accepted Answer

The answer of If you would like to add data...

Question 19

Why is it important to monitor how many times an update query is executed?

Accepted Answer

Because update queri

Question 20

What does the type of data displayed in a crosstab query depend on?

Accepted Answer

A) Which aggregate function used when the query was created 
B) The intersection of columns and rows 
C) What the query was based on 
D) The grouping of the data 
A) Which aggregate function used when the query was created 
B) The intersection of columns and rows 
C) What the query was based on 
D) The grouping of the data

Exam 14: Action and Specialized Queries: Moving Beyond the Select Query

The field names that display on the left side of a crosstab query are called ________.

How do appended records appear in the destination table?

An append query is used to add records to an existing table.

Access does not have a way to identify duplicate values.

A(n)________ query can be used for adding records to an existing table.

While reviewing a table,you find that the same customer was added to the customers table twice,you decide to run a(n)________ query to determine if there are any other records added multiple times.

When running a delete query,you are prompted with a warning message.

A(n)________ query is used to update or change data automatically based on criteria that you specify.

The type of data displayed in a crosstab query depends on which aggregate function you choose when creating the query.

What are the four types of action queries?

A(n)________ query can be used to archive older records that need to be stored outside of the current table.

Which type of query calculates data using a sum,average,or other function and groups the results by two sets of values?

A ________ query makes it easy to correct errors or add values to blank fields.

What should you do before running a delete query?

There is no way to verify that the correct records will be updated when using an update query.

Delete,append,and update queries are all examples of a(n)________ query.

After becoming familiar with the data in a database,what should be the first step when creating an action query?

If you would like to add data from an Excel spreadsheet to an existing Access table,you might use a(n)________ query.

Why is it important to monitor how many times an update query is executed?

What does the type of data displayed in a crosstab query depend on?

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters