Question 1

A(n)________ calculates a sum,average,or other statistic and groups the results by sets of values.

Accepted Answer

The answer of A(n)________ calculates a sum,average,or other statistic and...

Question 2

What do you do if you make a mistake when running a Find Unmatched query?

Accepted Answer

A) Delete the query and start over,then reverse the order of the tables. 
B) Rerun the query using different fields. 
C) Delete associated records in the table. 
D) Modify the aggregate function. 
A) Delete the query and start over,then reverse the order of the tables. 
B) Rerun the query using different fields. 
C) Delete associated records in the table. 
D) Modify the aggregate function.

Question 3

A crosstab query works best when the data source has at least two grouping fields.

Accepted Answer

A) True 
 B)False

Question 4

The field names that display at the top of a crosstab query are called ________.

Accepted Answer

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

Question 5

Before running a delete query,what should you do?

Accepted Answer

A) Preview the datasheet to verify that the records are those that you intend to delete. 
B) View the results in Design view. 
C) Create the table,you can always delete it if the information is wrong. 
D) Manually go through the table and delete the information,then use the delete query to verify all information is removed. 
A) Preview the datasheet to verify that the records are those that you intend to delete. 
B) View the results in Design view. 
C) Create the table,you can always delete it if the information is wrong. 
D) Manually go through the table and delete the information,then use the delete query to verify all information is removed.

Question 6

You can use a make table query to copy some or all records from a source table to a destination table even if the destination table does not exist.

Accepted Answer

A) True 
 B)False

Question 7

What must be present for a find unmatched query to work?

Accepted Answer

A) Two tables share a common field. 
B) Two tables have no relationship. 
C) All fields in the tables should be the same. 
D) There is nothing necessary for the query to work properly. 
A) Two tables share a common field. 
B) Two tables have no relationship. 
C) All fields in the tables should be the same. 
D) There is nothing necessary for the query to work properly.

Question 8

It is important to ensure that when you delete duplicate records,you do not delete associated records in a related table.

Accepted Answer

A) True 
 B)False

Question 9

It is not recommended to preview the datasheet prior to running a make table query.

Accepted Answer

A) True 
 B)False

Question 10

When running an append query,an append query warning message appears specifying the number of rows to be appended.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

An append query adds records t

Question 12

The ________ is responsible for maintaining databases,including performing backups,security checks,and upgrades to keep data both safe and accessible.

Accepted Answer

database a

Question 13

It is usually better to enter the value of zero rather than have a null value in a field.

Accepted Answer

A) True 
 B)False

Question 14

A(n)________ would be used to replace null values with zeros?

Accepted Answer

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

Question 15

What is the first step in creating an append query?

Accepted Answer

A) Create a select query 
B) Create a make table query 
C) Create a delete query 
D) Create a find duplicates query 
A) Create a select query 
B) Create a make table query 
C) Create a delete query 
D) Create a find duplicates query

Question 16

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

Accepted Answer

Switch to datasheet

Question 17

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 18

The find unmatched query only works if two tables share a common field.

Accepted Answer

A) True 
 B)False

Question 19

A delete query automatically creates a new table from data that already exists in a database.

Accepted Answer

A) True 
 B)False

Question 20

You would use a(n)________ query to identify records of all customers who live in Tennessee in order to change their area code to a new number.

Accepted Answer

The answer of You would use a(n)________ query to identify...

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

A(n)________ calculates a sum,average,or other statistic and groups the results by sets of values.

What do you do if you make a mistake when running a Find Unmatched query?

A crosstab query works best when the data source has at least two grouping fields.

The field names that display at the top of a crosstab query are called ________.

Before running a delete query,what should you do?

You can use a make table query to copy some or all records from a source table to a destination table even if the destination table does not exist.

What must be present for a find unmatched query to work?

It is important to ensure that when you delete duplicate records,you do not delete associated records in a related table.

It is not recommended to preview the datasheet prior to running a make table query.

When running an append query,an append query warning message appears specifying the number of rows to be appended.

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

The ________ is responsible for maintaining databases,including performing backups,security checks,and upgrades to keep data both safe and accessible.

It is usually better to enter the value of zero rather than have a null value in a field.

A(n)________ would be used to replace null values with zeros?

What is the first step in creating an append query?

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

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

The find unmatched query only works if two tables share a common field.

A delete query automatically creates a new table from data that already exists in a database.

You would use a(n)________ query to identify records of all customers who live in Tennessee in order to change their area code to a new number.

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