Question 1

Duplicate values should always be deleted from a database table.

Accepted Answer

A) True 
 B)False

Question 2

Once records with missing data are found,what type of query can you use to add the needed information?

Accepted Answer

A) Update 
B) Delete 
C) Make table 
D) Find duplicates 
A) Update 
B) Delete 
C) Make table 
D) Find duplicates

Question 3

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 4

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

Question 5

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 6

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 7

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 8

What is the best precaution to take prior to running an update query?

Accepted Answer

Back up th

Question 9

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 10

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 11

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 12

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 13

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 14

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

Accepted Answer

A) Action queries change data in your database that cannot be reversed. 
B) Action queries change data in your database but the changes are temporary. 
C) Action queries do not make any changes to your database. 
D) Action queries duplicate data in your database. 
A) Action queries change data in your database that cannot be reversed. 
B) Action queries change data in your database but the changes are temporary. 
C) Action queries do not make any changes to your database. 
D) Action queries duplicate data in your database.

Question 15

What should be the first step taken before creating an update query?

Accepted Answer

A) Back up the database 
B) Switch to Datasheet view 
C) Move the records to a different table 
D) Run the query 
A) Back up the database 
B) Switch to Datasheet view 
C) Move the records to a different table 
D) Run the query

Question 16

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 17

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 18

When running an append query,what happens if a record violates the primary key rule for the destination table?

Accepted Answer

A) The record is rejected. 
B) The original record is selected. 
C) The record is added without the primary key field. 
D) The append query is rejected. 
A) The record is rejected. 
B) The original record is selected. 
C) The record is added without the primary key field. 
D) The append query is rejected.

Question 19

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 20

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...

Exam 35: Access : Action and Specialized Queries: Moving Beyond the Select Query

Duplicate values should always be deleted from a database table.

Once records with missing data are found,what type of query can you use to add the needed information?

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

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

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

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

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

What is the best precaution to take prior to running an update query?

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

Before running a delete query,what should you do?

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

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

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

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

What should be the first step taken before creating an update query?

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

What is the first step in creating an append query?

When running an append query,what happens if a record violates the primary key rule for the destination table?

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

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

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

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

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

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

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

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

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

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

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

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

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

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters