Question 1

By creating a query using the Find Unmatched Query Wizard,you will be able to edit,analyze,and cleanse data.

Accepted Answer

A) True 
 B)False

Question 2

The only way to verify that an action query worked correctly is to ________ to see that the proper action occurred.

Accepted Answer

A) open the table 
B) close the table 
C) open the query 
D) run the query 
A) open the table 
B) close the table 
C) open the query 
D) run the query

Question 3

To run your action query in a different database,the database you are creating the table in must be open or the make table query will not run.

Accepted Answer

A) True 
 B)False

Question 4

Action queries ________ modify the data in tables.Because there is no undo feature for action queries,it is important to be cautious when running any action query.

Accepted Answer

The answer of Action queries ________ modify the data in...

Question 5

It is important to be cautious when running any action query because there is no ________ feature.

Accepted Answer

A) redo 
B) undo 
C) backup 
D) modification 
A) redo 
B) undo 
C) backup 
D) modification

Question 6

Which of the following is NOT true regarding simple delete queries?

Accepted Answer

A) A simple delete query is used to remove one or more records from a table or another query. 
B) The number of rows deleted is dependent upon the criteria within the Having clause of the delete query. 
C) Typically,you use delete queries when you need to remove large amounts of data quickly. 
D) If you want to remove a very small number of records,you may want to simply delete them by hand. 
A) A simple delete query is used to remove one or more records from a table or another query. 
B) The number of rows deleted is dependent upon the criteria within the Having clause of the delete query. 
C) Typically,you use delete queries when you need to remove large amounts of data quickly. 
D) If you want to remove a very small number of records,you may want to simply delete them by hand.

Question 7

Match between columns
                        Premises: Truncate
Suggestive sell
Data cleansing
BI tools
Forecasting

Accepted Answer

The Answer of Help managers make improved business decisions and is...

Question 8

Match between columns
                        Premises: Yes/No to Memo
AutoNumber to Number
Number to Date/Time
Text to Number
Memo to Text

Accepted Answer

The Answer of Value must fall between -657,434 and 2,958,465 is...

Question 9

To create a query that includes a customer and the products that the customer has purchased would require you to create a(n)________.

Accepted Answer

A) unmatched query 
B) query join 
C) inner join 
D) outer join 
A) unmatched query 
B) query join 
C) inner join 
D) outer join

Question 10

A delete query is used to remove entire records from a table at one time.

Accepted Answer

A) True 
 B)False

Question 11

A company searches a database to find that the two products that are most likely to sell together on a Wednesday night are peanuts and diapers,they have performed a(n)________.

Accepted Answer

A) data mining activity 
B) update query 
C) select query 
D) make table query 
A) data mining activity 
B) update query 
C) select query 
D) make table query

Question 12

A simple update query involves updating data in one table,allowing you to specify two values-the value you want to replace and the value to use as a replacement.

Accepted Answer

A) True 
 B)False

Question 13

One way business intelligence tools are used is for performing ________,which helps expose trends,patterns,and relationships within the data that might have otherwise remained undetected.

Accepted Answer

A) action queries 
B) data warehousing 
C) data mining 
D) data archiving 
A) action queries 
B) data warehousing 
C) data mining 
D) data archiving

Question 14

Match between columns
                        Premises: Operational database
Transactional database
Business intelligence
Data mining
Data warehouse

Accepted Answer

The Answer of Helps an organization attain their goals and is...

Question 15

Which of the following is NOT true regarding simple update queries?

Accepted Answer

A) The data types for each table field need to match. 
B) A simple update query involves updating data in one table,allowing you to specify two values,the value you want to replace and the value to use as a replacement. 
C) First begin with a select query that identifies the records to be updated and then change the query to an update query and click Run. 
D) A simple update query can be an easy way to update large amounts of data. 
A) The data types for each table field need to match. 
B) A simple update query involves updating data in one table,allowing you to specify two values,the value you want to replace and the value to use as a replacement. 
C) First begin with a select query that identifies the records to be updated and then change the query to an update query and click Run. 
D) A simple update query can be an easy way to update large amounts of data.

Question 16

A(n)________ 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.

Accepted Answer

The answer of A(n)________ is a temporary or virtual relationship...

Question 17

If you need to remove data only on the many side of the relationship,you can create and run your delete query without having to change the relationship.

Accepted Answer

A) True 
 B)False

Question 18

If you are working in your employee database and you accidently delete three employee records,which also removed all payroll records,the best way to recover this data is ________.

Accepted Answer

A) to run an update query 
B) to run an append query 
C) to restore it from your backup database 
D) to physically re-enter the data 
A) to run an update query 
B) to run an append query 
C) to restore it from your backup database 
D) to physically re-enter the data

Question 19

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

Accepted Answer

The answer of A(n)________ query allows the values of one...

Question 20

A transactional database is the database used to record daily transactions.

Accepted Answer

A) True 
 B)False

By creating a query using the Find Unmatched Query Wizard,you will be able to edit,analyze,and cleanse data.

The only way to verify that an action query worked correctly is to ________ to see that the proper action occurred.

To run your action query in a different database,the database you are creating the table in must be open or the make table query will not run.

Action queries ________ modify the data in tables.Because there is no undo feature for action queries,it is important to be cautious when running any action query.

It is important to be cautious when running any action query because there is no ________ feature.

Which of the following is NOT true regarding simple delete queries?

To create a query that includes a customer and the products that the customer has purchased would require you to create a(n)________.

A delete query is used to remove entire records from a table at one time.

A company searches a database to find that the two products that are most likely to sell together on a Wednesday night are peanuts and diapers,they have performed a(n)________.

A simple update query involves updating data in one table,allowing you to specify two values-the value you want to replace and the value to use as a replacement.

One way business intelligence tools are used is for performing ________,which helps expose trends,patterns,and relationships within the data that might have otherwise remained undetected.

Which of the following is NOT true regarding simple update queries?

A(n)________ 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.

If you need to remove data only on the many side of the relationship,you can create and run your delete query without having to change the relationship.

If you are working in your employee database and you accidently delete three employee records,which also removed all payroll records,the best way to recover this data is ________.

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

A transactional database is the database used to record daily transactions.

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

By creating a query using the Find Unmatched Query Wizard,you will be able to edit,analyze,and cleanse data.

The only way to verify that an action query worked correctly is to ________ to see that the proper action occurred.

To run your action query in a different database,the database you are creating the table in must be open or the make table query will not run.

Action queries ________ modify the data in tables.Because there is no undo feature for action queries,it is important to be cautious when running any action query.

It is important to be cautious when running any action query because there is no ________ feature.

Which of the following is NOT true regarding simple delete queries?

To create a query that includes a customer and the products that the customer has purchased would require you to create a(n)________.

A delete query is used to remove entire records from a table at one time.

A company searches a database to find that the two products that are most likely to sell together on a Wednesday night are peanuts and diapers,they have performed a(n)________.

A simple update query involves updating data in one table,allowing you to specify two values-the value you want to replace and the value to use as a replacement.

One way business intelligence tools are used is for performing ________,which helps expose trends,patterns,and relationships within the data that might have otherwise remained undetected.

Which of the following is NOT true regarding simple update queries?

A(n)________ 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.

If you need to remove data only on the many side of the relationship,you can create and run your delete query without having to change the relationship.

If you are working in your employee database and you accidently delete three employee records,which also removed all payroll records,the best way to recover this data is ________.

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

A transactional database is the database used to record daily transactions.

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