Question 1

When creating a crosstab query,you need a minimum of four fields.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is an example of a field which should not have duplicate data?

Accepted Answer

A) City 
B) State 
C) Lastname 
D) Primary key 
A) City 
B) State 
C) Lastname 
D) Primary key

Question 3

Which of the following is not considered an action query?

Accepted Answer

A) Update 
B) Append 
C) Create Table 
D) Make Table 
A) Update 
B) Append 
C) Create Table 
D) Make Table

Question 4

It is always a good practice to backup your entire database before running an action query.

Accepted Answer

A) True 
 B)False

Question 5

A(n)________ query automatically removes records based on certain criteria.

Accepted Answer

The answer of A(n)________ query automatically removes records based on...

Question 6

To guard against data loss,it is good practice to have the same record in more than one table.

Accepted Answer

A) True 
 B)False

Question 7

Which is the first table chosen when creating a find duplicates query?

Accepted Answer

A) The table where the duplicate data might be found 
B) The table with the foreign key 
C) The data source for the query 
D) The table which has no Primary key 
A) The table where the duplicate data might be found 
B) The table with the foreign key 
C) The data source for the query 
D) The table which has no Primary key

Question 8

What query or queries would you use to move every item that has never been sold to a new database,then reduce the price of each item by 10%?

Accepted Answer

A) Find unmatched,then make table,then delete,then update 
B) Find unmatched,then make table,then append,then delete,then update 
C) Append,then delete,then update 
D) Make table,then delete,then update 
A) Find unmatched,then make table,then delete,then update 
B) Find unmatched,then make table,then append,then delete,then update 
C) Append,then delete,then update 
D) Make table,then delete,then update

Question 9

The summarizing or aggregating data in a crosstab query are displayed at the intersection of the rows and columns.

Accepted Answer

A) True 
 B)False

Question 10

Action queries can be tested before being run.

Accepted Answer

A) True 
 B)False

Question 11

The ________ query is a good alternative to the Find and Replace tool.

Accepted Answer

The answer of The ________ query is a good alternative...

Question 12

Before running an action query,it is good idea to backup your database.

Accepted Answer

A) True 
 B)False

Question 13

As with other actions in Access,you can undo the changes made by running actions queries.

Accepted Answer

A) True 
 B)False

Question 14

In an Append query,what happens to any records that violate the Primary key (or any other)rule?

Accepted Answer

A) The query pauses at each violating record and allows you to fix the error(s). 
B) A message box appears telling you that you must fix the problematic records before the query can be run. 
C) New Primary key values are added to the records 
D) The records are rejected. 
A) The query pauses at each violating record and allows you to fix the error(s). 
B) A message box appears telling you that you must fix the problematic records before the query can be run. 
C) New Primary key values are added to the records 
D) The records are rejected.

Question 15

When you update data in a query,you are actually updating the data in the underlying table.

Accepted Answer

A) True 
 B)False

Question 16

Unlike other queries,you can only reference one object as the data source in a Crosstab query.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is not true about running action queries?

Accepted Answer

A) They can be undone. 
B) They can be cancelled before completion. 
C) You will receive a warning when you attempt to run them. 
D) They change data. 
A) They can be undone. 
B) They can be cancelled before completion. 
C) You will receive a warning when you attempt to run them. 
D) They change data.

Question 18

Which of the following is not true about action queries?

Accepted Answer

A) They can be run more than once,but with full awareness of the action(s)they perform. 
B) They should never be run more than once. 
C) You should backup your data before running them. 
D) They have special symbol icons to distinguish them from other queries. 
A) They can be run more than once,but with full awareness of the action(s)they perform. 
B) They should never be run more than once. 
C) You should backup your data before running them. 
D) They have special symbol icons to distinguish them from other queries.

When creating a crosstab query,you need a minimum of four fields.

Which of the following is an example of a field which should not have duplicate data?

Which of the following is not considered an action query?

It is always a good practice to backup your entire database before running an action query.

A(n)________ query automatically removes records based on certain criteria.

To guard against data loss,it is good practice to have the same record in more than one table.

Which is the first table chosen when creating a find duplicates query?

What query or queries would you use to move every item that has never been sold to a new database,then reduce the price of each item by 10%?

The summarizing or aggregating data in a crosstab query are displayed at the intersection of the rows and columns.

Action queries can be tested before being run.

The ________ query is a good alternative to the Find and Replace tool.

Before running an action query,it is good idea to backup your database.

As with other actions in Access,you can undo the changes made by running actions queries.

In an Append query,what happens to any records that violate the Primary key (or any other)rule?

When you update data in a query,you are actually updating the data in the underlying table.

Unlike other queries,you can only reference one object as the data source in a Crosstab query.

Which of the following is not true about running action queries?

Which of the following is not true about action queries?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters

Exam 7: Action and Specialized Queries

When creating a crosstab query,you need a minimum of four fields.

Which of the following is an example of a field which should not have duplicate data?

Which of the following is not considered an action query?

It is always a good practice to backup your entire database before running an action query.

A(n)________ query automatically removes records based on certain criteria.

To guard against data loss,it is good practice to have the same record in more than one table.

Which is the first table chosen when creating a find duplicates query?

What query or queries would you use to move every item that has never been sold to a new database,then reduce the price of each item by 10%?

The summarizing or aggregating data in a crosstab query are displayed at the intersection of the rows and columns.

Action queries can be tested before being run.

The ________ query is a good alternative to the Find and Replace tool.

Before running an action query,it is good idea to backup your database.

As with other actions in Access,you can undo the changes made by running actions queries.

In an Append query,what happens to any records that violate the Primary key (or any other)rule?

When you update data in a query,you are actually updating the data in the underlying table.

Unlike other queries,you can only reference one object as the data source in a Crosstab query.

Which of the following is not true about running action queries?

Which of the following is not true about action queries?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters