Question 1

Duplicate values in a table can prevent you from:

Accepted Answer

A)  enforcing referential integrity. 
B)  adding additional records. 
C)  having an accurate database. 
D)  running an append query. 
A)  enforcing referential integrity. 
B)  adding additional records. 
C)  having an accurate database. 
D)  running an append query.

Question 2

Why should you backup your database before running an action query?

Accepted Answer

A)  Action queries are irreversible. 
B)  Action queries are reversible. 
C)  Action queries are temporary. 
D)  Action queries add extra tables to the database. 
A)  Action queries are irreversible. 
B)  Action queries are reversible. 
C)  Action queries are temporary. 
D)  Action queries add extra tables to the database.

Question 3

It is recommended to preview results before running a delete query.

Accepted Answer

A) True 
 B)False

Question 4

How is a crosstab query different from other queries?

Accepted Answer

A)  You can only reference one object (table or query) as the data source 
B)  You can use records from several objects in a crosstab query 
C)  You can preview the data before finalizing the query 
D)  You can select a data source with several grouping fields 
A)  You can only reference one object (table or query) as the data source 
B)  You can use records from several objects in a crosstab query 
C)  You can preview the data before finalizing the query 
D)  You can select a data source with several grouping fields

Question 5

You should NOT rerun an action query.

Accepted Answer

A) True 
 B)False

Question 6

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 7

Action queries display different icons than select queries in the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 8

One reason an append query can fail is because of duplicate primary keys in the source and destination tables.

Accepted Answer

A) True 
 B)False

Question 9

Moving records from one table to another can be accomplished with the combination of what two types of queries?

Accepted Answer

A)  Append and delete 
B)  Append and make table 
C)  Append and select 
D)  Append and update 
A)  Append and delete 
B)  Append and make table 
C)  Append and select 
D)  Append and update

Question 10

An append query is used to update or change data automatically based on criteria that you specify.

Accepted Answer

A) True 
 B)False

Question 11

What is the best way to check an update query before running it?

Accepted Answer

Switch to datasheet

Question 12

Moving records from one table to another can be accomplished with the combination of an append query and a delete query.

Accepted Answer

A) True 
 B)False

Question 13

What is the difference between an update query and an append query?

Accepted Answer

An append query adds records t

Question 14

Where do the row headings display in a crosstab query?

Accepted Answer

A)  Along the left side of a crosstab query 
B)  Along the top of a crosstab query 
C)  Along the right side of a crosstab query 
D)  Along the bottom of a crosstab query 
A)  Along the left side of a crosstab query 
B)  Along the top of a crosstab query 
C)  Along the right side of a crosstab query 
D)  Along the bottom of a crosstab query

Question 15

The grouping in a crosstab query comes from the definitions of row and column headings.

Accepted Answer

A) True 
 B)False

Question 16

To test an update query before running it,you can:

Accepted Answer

A)  switch to Datasheet view. 
B)  run an append query first. 
C)  backup the database. 
D)  move the records to a different table. 
A)  switch to Datasheet view. 
B)  run an append query first. 
C)  backup the database. 
D)  move the records to a different table.

Question 17

Action queries include update,append,make table,and delete.

Accepted Answer

A) True 
 B)False

Question 18

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 19

What are the four types of action queries?

Accepted Answer

update query,append

Question 20

What summarizes a data source into a grid of rows and columns?

Accepted Answer

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

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

Duplicate values in a table can prevent you from:

Why should you backup your database before running an action query?

It is recommended to preview results before running a delete query.

How is a crosstab query different from other queries?

You should NOT rerun 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.

Action queries display different icons than select queries in the Navigation Pane.

One reason an append query can fail is because of duplicate primary keys in the source and destination tables.

Moving records from one table to another can be accomplished with the combination of what two types of queries?

An append query is used to update or change data automatically based on criteria that you specify.

What is the best way to check an update query before running it?

Moving records from one table to another can be accomplished with the combination of an append query and a delete query.

What is the difference between an update query and an append query?

Where do the row headings display in a crosstab query?

The grouping in a crosstab query comes from the definitions of row and column headings.

To test an update query before running it,you can:

Action queries include update,append,make table,and delete.

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

What are the four types of action queries?

What summarizes a data source into a grid of rows and columns?

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters