Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

To remove the duplicate records found in a table,you would run a(n)________ query.

Accepted Answer

The answer of To remove the duplicate records found in...

Question 3

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 4

Once you run an action query,you are committing yourself to an irreversible change.

Accepted Answer

A) True 
 B)False

Question 5

Before running a make table query,what should you do?

Accepted Answer

A) Preview the datasheet to verify that the records are those that you intend to insert into the table. 
B) View the results in Design view. 
C) Create the table,you can always delete it if the information is wrong. 
D) Create a delete query at the same time. 
A) Preview the datasheet to verify that the records are those that you intend to insert into the table. 
B) View the results in Design view. 
C) Create the table,you can always delete it if the information is wrong. 
D) Create a delete query at the same time.

Question 6

Where do the column headings display in a crosstab query?

Accepted Answer

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

Question 7

Match between columns
                        Premises: crosstab query
action query
find duplicate query
find unmatched query

Accepted Answer

The Answer of adds,edits,or deletes data in a database and is...

Question 8

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 9

An append query selects records from one or more tables and uses then to create a new table.

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

Match between columns
                        Premises: make table query
update query
append query
delete query

Accepted Answer

The Answer of adds records to an existing table and is...

Question 12

A find duplicates query compares records in two related tables and displays the values found in one table but not the other.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

What is the purpose of a crosstab query?

Accepted Answer

A crosstab query is

Question 15

Duplicate values should always be deleted from a database table.

Accepted Answer

A) True 
 B)False

Question 16

To test an update query before running the query,what should you do first?

Accepted Answer

A) From Design view,click View in the Results group and click Datasheet view. 
B) From Design view,click the Run button. 
C) From Design view,verify that all fields are listed. 
D) From Design view,click Update in the Query type group. 
A) From Design view,click View in the Results group and click Datasheet view. 
B) From Design view,click the Run button. 
C) From Design view,verify that all fields are listed. 
D) From Design view,click Update in the Query type group.

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Find unmatched queries provide a subset of the data that answers most questions that users ask about the data in their databases.

Accepted Answer

A) True 
 B)False

Question 19

When running an append query,the data types of the source fields do not have to match the data types of the destination fields.

Accepted Answer

A) True 
 B)False

Question 20

A(n)________ query provides the easiest way to move records from one table to another.

Accepted Answer

The answer of A(n)________ query provides the easiest way to...

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

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

To remove the duplicate records found in a table,you would run a(n)________ query.

How is a crosstab query different from other queries?

Once you run an action query,you are committing yourself to an irreversible change.

Before running a make table query,what should you do?

Where do the column headings display in a crosstab query?

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

An append query selects records from one or more tables and uses then to create a new table.

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

A find duplicates query compares records in two related tables and displays the values found in one table but not the other.

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

What is the purpose of a crosstab query?

Duplicate values should always be deleted from a database table.

To test an update query before running the query,what should you do first?

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

Find unmatched queries provide a subset of the data that answers most questions that users ask about the data in their databases.

When running an append query,the data types of the source fields do not have to match the data types of the destination fields.

A(n)________ query provides the easiest way to move records from one table to another.

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