Question 1

Removing ________ is a good organizational strategy that all database users should practice.

Accepted Answer

The answer of Removing ________ is a good organizational strategy...

Question 2

________ are a classification of software applications that aide in collecting,storing,analyzing,and providing access to data that helps managers make improved business decisions.

Accepted Answer

Business i

Question 3

Which of the following is NOT a factor to consider when running a delete query?

Accepted Answer

A) To delete records on the one side of the relationship and the related records on the many side,enable the Referential Integrity and Cascade Delete Related Records properties. 
B) To delete records only on the one side of the relationship,first delete the relationship,and then delete the data. 
C) To remove data only on the many side of the relationship,create and run the delete query without changing the relationship. 
D) To remove data in a many to many relationship,create and run the delete query,delete the relationship,and then delete the data. 
A) To delete records on the one side of the relationship and the related records on the many side,enable the Referential Integrity and Cascade Delete Related Records properties. 
B) To delete records only on the one side of the relationship,first delete the relationship,and then delete the data. 
C) To remove data only on the many side of the relationship,create and run the delete query without changing the relationship. 
D) To remove data in a many to many relationship,create and run the delete query,delete the relationship,and then delete the data.

Question 4

A(n)________ query allows the values of one or more fields in a query dataset to be modified.

Accepted Answer

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

Question 5

A(n)________ query is a query where the dataset is added to an existing table.

Accepted Answer

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

Question 6

________ is a process where the delete query will remove data that is not useful or needed anymore.

Accepted Answer

The answer of ________ is a process where the delete...

Question 7

________ helps expose trends,patterns,and relationships within the data that might have otherwise remained undetected.

Accepted Answer

The answer of ________ helps expose trends,patterns,and relationships within the...

Question 8

The ________ finds records in one table that do not have related records in another table.

Accepted Answer

Find Unmat

Question 9

A(n)________ query removes all the records in the underlying table of a query dataset that meet specific criteria.

Accepted Answer

The answer of A(n)________ query removes all the records in...

Question 10

If an accountant is generating employee paychecks for last week's payroll,the accountant is retrieving data from the company's ________ database.

Accepted Answer

A) data warehouse 
B) payroll database 
C) transactional 
D) operational 
A) data warehouse 
B) payroll database 
C) transactional 
D) operational

Question 11

________ queries remove all the data in each field,including the primary key.

Accepted Answer

The answer of ________ queries remove all the data in...

Question 12

Which of the following is NOT a benefit of using an append query?

Accepted Answer

A) You can use criteria to refine your selection. 
B) You can append records only when all of the data source fields exist in the destination table. 
C) You can review the data that will be appended before you run the query. 
D) You can append multiple records to a table at one time. 
A) You can use criteria to refine your selection. 
B) You can append records only when all of the data source fields exist in the destination table. 
C) You can review the data that will be appended before you run the query. 
D) You can append multiple records to a table at one time.

Question 13

Which of the following is NOT true regarding query joins?

Accepted Answer

A) A query join is a temporary or virtual relationship between two tables in a query that do not have an established relationship or common field with the same field name and data type. 
B) Tables that are joined in a saved query also save to the Relationships window. 
C) The type of join used will indicate which records the query will select or perform an action on. 
D) You can control which records will be displayed in the query dataset by using query joins. 
A) A query join is a temporary or virtual relationship between two tables in a query that do not have an established relationship or common field with the same field name and data type. 
B) Tables that are joined in a saved query also save to the Relationships window. 
C) The type of join used will indicate which records the query will select or perform an action on. 
D) You can control which records will be displayed in the query dataset by using query joins.

Question 14

Which of the following is NOT a characteristic of the Unmatched Query Wizard?

Accepted Answer

A) The Find Unmatched Query Wizard is the only way you can create an unmatched records query. 
B) By creating a query using the Find Unmatched Query Wizard,you will be able to edit,analyze,and cleanse data. 
C) The Find Unmatched Query Wizard finds records in one table that do not have related records in another table. 
D) After the wizard constructs your query,you can modify the query's design to add or remove fields or to add a join between the two tables. 
A) The Find Unmatched Query Wizard is the only way you can create an unmatched records query. 
B) By creating a query using the Find Unmatched Query Wizard,you will be able to edit,analyze,and cleanse data. 
C) The Find Unmatched Query Wizard finds records in one table that do not have related records in another table. 
D) After the wizard constructs your query,you can modify the query's design to add or remove fields or to add a join between the two tables.

Question 15

The first and most important step when creating an action query is to ________.

Accepted Answer

A) create a select query 
B) view the data 
C) backup the database 
D) determine the business intelligence tool you will use 
A) create a select query 
B) view the data 
C) backup the database 
D) determine the business intelligence tool you will use

Question 16

An action query is a query that makes changes to records or moves many records from one table to another.

Accepted Answer

A) True 
 B)False

Question 17

A(n)________ query creates a new table based on a query dataset.

Accepted Answer

The answer of A(n)________ query creates a new table based...

Question 18

If a manager wants to ensure he has current data for decision making,he needs to regularly add new records to the table.The best way to do this is by using a(n)________ query.

Accepted Answer

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

Question 19

Which of the following is NOT a type of action query?

Accepted Answer

A) make table 
B) append 
C) update 
D) remove 
A) make table 
B) append 
C) update 
D) remove

Question 20

Which of the following is NOT a reason to cleanse data within your database?

Accepted Answer

A) It is important o ensure that the data within your database is current. 
B) Cleansing outdated or incorrect data creates a database that is easy to use and maintain. 
C) It will allow for real-world changes that can occur within your business. 
D) At times you may need to backup newer data and want to remove it from the database completely. 
A) It is important o ensure that the data within your database is current. 
B) Cleansing outdated or incorrect data creates a database that is easy to use and maintain. 
C) It will allow for real-world changes that can occur within your business. 
D) At times you may need to backup newer data and want to remove it from the database completely.

Removing ________ is a good organizational strategy that all database users should practice.

________ are a classification of software applications that aide in collecting,storing,analyzing,and providing access to data that helps managers make improved business decisions.

Which of the following is NOT a factor to consider when running a delete query?

A(n)________ query allows the values of one or more fields in a query dataset to be modified.

A(n)________ query is a query where the dataset is added to an existing table.

________ is a process where the delete query will remove data that is not useful or needed anymore.

________ helps expose trends,patterns,and relationships within the data that might have otherwise remained undetected.

The ________ finds records in one table that do not have related records in another table.

A(n)________ query removes all the records in the underlying table of a query dataset that meet specific criteria.

If an accountant is generating employee paychecks for last week's payroll,the accountant is retrieving data from the company's ________ database.

________ queries remove all the data in each field,including the primary key.

Which of the following is NOT a benefit of using an append query?

Which of the following is NOT true regarding query joins?

Which of the following is NOT a characteristic of the Unmatched Query Wizard?

The first and most important step when creating an action query is to ________.

An action query is a query that makes changes to records or moves many records from one table to another.

A(n)________ query creates a new table based on a query dataset.

If a manager wants to ensure he has current data for decision making,he needs to regularly add new records to the table.The best way to do this is by using a(n)________ query.

Which of the following is NOT a type of action query?

Which of the following is NOT a reason to cleanse data within your database?

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters

Exam 8: Workshop 8: Action Queries and Advanced Relationships

Removing ________ is a good organizational strategy that all database users should practice.

________ are a classification of software applications that aide in collecting,storing,analyzing,and providing access to data that helps managers make improved business decisions.

Which of the following is NOT a factor to consider when running a delete query?

A(n)________ query allows the values of one or more fields in a query dataset to be modified.

A(n)________ query is a query where the dataset is added to an existing table.

________ is a process where the delete query will remove data that is not useful or needed anymore.

________ helps expose trends,patterns,and relationships within the data that might have otherwise remained undetected.

The ________ finds records in one table that do not have related records in another table.

A(n)________ query removes all the records in the underlying table of a query dataset that meet specific criteria.

If an accountant is generating employee paychecks for last week's payroll,the accountant is retrieving data from the company's ________ database.

________ queries remove all the data in each field,including the primary key.

Which of the following is NOT a benefit of using an append query?

Which of the following is NOT true regarding query joins?

Which of the following is NOT a characteristic of the Unmatched Query Wizard?

The first and most important step when creating an action query is to ________.

An action query is a query that makes changes to records or moves many records from one table to another.

A(n)________ query creates a new table based on a query dataset.

If a manager wants to ensure he has current data for decision making,he needs to regularly add new records to the table.The best way to do this is by using a(n)________ query.

Which of the following is NOT a type of action query?

Which of the following is NOT a reason to cleanse data within your database?

Workshop 1: The Four Main Database Objects

Workshop 2: Tables, Keys, and Relationships

Workshop 3: Queries and Data Access

Workshop 4: Access Information From an Access Database

Workshop 5: Advanced Tables

Workshop 6: Pattern Matching and Functions in Queries

Workshop 7: Aggregated Calculations, Subquerying, and Sql

Workshop 9: Advanced Reports and Mailing Labels

Workshop 10: Advanced Form Settings and Form Types

Workshop 11: Develop Navigation Forms and the User Interface

Workshop 12: Create a Refined User Experience With Macros

Workshop 13: Use VBA in Access

Workshop 14: Implement Your Database

Normalize a Database for Effective Design

The Common Features of Microsoft Office

Efficient Interaction With a Touch Screen

Filters