Deck 8: Workshop 8: Action Queries and Advanced Relationships

Question 1

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

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

Answer 1

B

Question 2

Suppose your database may have initially been built to track customers and the orders they placed.Now you decide to also track marketing efforts and the quantity of customers who use coupons that were mailed or e-mailed to them.You would need to run a(n)________ to track who redeemed coupons and when they were redeemed.

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

Answer 2

A

Question 3

When a company archives data for later analysis,the data is being stored in the company's ________.

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

Answer 3

A

Question 4

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

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

Question 5

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)data mining activity
B)update query
C)select query
D)make table query

Question 6

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

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 7

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.

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

Question 8

A(n)________ acquires data from one or more tables,and then automatically loads the resulting dataset into a new table once you run the query.

A)make table query
B)append query
C)update query
D)unmatched records query

Question 9

In terms of action queries,"Run" is synonymous with ________.

A)switching to Datasheet view
B)switching to Design view
C)building the action query
D)executing the query

Question 10

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.

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

Question 11

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

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

Question 12

When a bank customer withdraws money from an ATM,the record is being stored in the bank's ________.

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

Question 13

When a company archives data for later analysis,its employees will use ________ tools to work with the data and obtain information on how the organization is progressing toward its goals.

A)data mining
B)data warehousing
C)business intelligence
D)forecasting

Question 14

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

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

Question 15

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

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

Question 16

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

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

Question 17

Which of the following is NOT true regarding make table queries?

A)A make table query acquires data from one or more tables.
B)A make table query,automatically loads the resulting dataset into a new table once you run the query.
C)You can create a make table query by first creating a select query and then changing it to a make table query.
D)Your initial select query cannot include calculated fields and expressions to return the desired data along with verifying your results before running the query.

Question 18

Which of the following is NOT a reason why managers would archive data?

A)Managers do not have access to data warehouses; thus,they want to keep their own copies of data to refer to as needed.
B)Managers do not want to delete historical data because it can be used to help manage and develop their business.
C)A manager may decide at some point,perhaps once you have a few years' worth of data,that you want to archive some of the older data into another database.
D)A major use of historical data is for forecasting.

Question 19

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

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

Question 20

The spa manager could learn a lot about the business and use this information to help increase sales.If the manager knows that two items are most likely to sell together in one transaction,he could ensure he has equal amounts of inventory in stock.This is known as ________.

A)a query join.
B)appending data
C)data warehousing
D)forecasting

Question 21

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

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

Question 22

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

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 23

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

A)If you update data from one table to another and use compatible data types instead of matching data types,Access converts the data types of the fields in the destination table.
B)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.
C)The data types for both the source and destination fields must match and be compatible.
D)Some of the data in the destination fields may be truncated.

Question 24

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

Question 25

Which of the following is NOT true about using the Cascade Update and Cascade Delete Related Records property in the Relationships window?

A)When you set the Cascade Update Related Records property,Access updates the primary key in all related tables if it changes on the one side of the relationship.
B)When you set the Cascade Update Related Records property,Access deletes the related records in all related tables if the key field is deleted on the one side of the relationship.
C)If you want to delete data from several related tables,you must enable the Enforce Referential Integrity and Cascade Delete Related Records properties for each relationship.
D)Running update and delete queries are different than using the Cascade Update and Cascade Delete Related Records property in the Relationships window.

Question 26

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

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.

Question 27

You can use a(n)________ query to delete data in one or more fields in a database.However,to delete entire records,including the primary key value that makes the record unique,you can use a(n)________ query.

A)update,delete
B)append,delete
C)update,append
D)delete,update

Question 28

To create a query that includes all customers and only the products that have been purchased would require you to create a(n)________.

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

Question 29

Perhaps an employee no longer works at the salon and there are dozens of future appointments that need to be changed to a different employee's name.You could create a(n)________ that changes the name of the employee for all future appointments from the employee who left to the a employee.

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

Question 30

Which of the following is NOT true regarding 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 31

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

A)Cascade update
B)Cascade delete
C)Data cleansing
D)Data mining

Question 32

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

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 33

Action queries permanently modify the data in tables,but you can undo the changes to your data if you change your mind.

Question 34

Which of the following is NOT true regarding outer joins?

A)One or more fields can serve as a join field.
B)To create an inner join,select the "Only include rows where the joined fields from both tables are equal" option in the Join Properties dialog box.
C)An outer join selects all of the records from one database table and only those records in the second table that have matching values in the joined field.
D)Creating an outer join will not establish a permanent relationship between the tables.

Question 35

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

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 36

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

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 37

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)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 38

The spa manager decided to remove all coupon codes from the database that were not redeemed and have now expired.By using a(n)________,the database will remain cleansed.

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

Question 39

Which of the following is NOT true regarding inner joins?

A)Only one field can serve as a join field.
B)An inner join is a join that selects only those records from both database tables that have matching values.
C)Records with values in the joined field that do not appear in both of the database tables will be excluded from the query dataset.
D)To create an inner join,select the "Only include rows where the joined fields from both tables are equal" option in the Join Properties dialog box.

Question 40

Many new area codes have been created in the United States over the past few years.It would take too much time to have an employee look through each customer's data and modify the area code as needed.This is when a(n)________ query can be helpful.

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

Question 41

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

Question 42

A make table query acquires data from one or more tables,and then automatically loads the resulting dataset into a new table once you switch to Datasheet view.

Question 43

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

Question 44

Running update and delete queries are the same as using the Cascade Update and Cascade Delete Related Records property in the Relationships window.

Question 45

Switching to Design view allows you to preview the records that will be added to the other table before actually running the query.

Question 46

Data warehousing is a technology used to establish business intelligence.

Question 47

Update queries are similar to the Find and Replace dialog box,but not as powerful.

Question 48

You should always back up your database or the destination table before running an append query.

Question 49

An operational database contains a large amount of different types of data that present a clear picture of your business environment at a specific point in time.

Question 50

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.

Question 51

An append query selects records from one or more data sources and copies the selected records to an existing table.

Question 52

When you update data from one table to another and use compatible data types instead of matching data types,Access converts the data types of the fields in the destination table.As a result,some of the data in the destination fields may be truncated.

Question 53

An operational database is a database used to carry out regular operations,such as payroll and inventory management,of an organization.

Question 54

A simple delete query is used to remove data in multiple tables.

Question 55

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

Question 56

When you run an action query,Access will always warn you that you are about to make a change to your data as well as ask you to confirm the change.Unfortunately,you cannot disable these messages.

Question 57

A simple delete query is used to remove one or more records from a table or another query.

Question 58

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.

Question 59

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

Question 60

You can use a make table query when you need to add new records to an existing table by using data from other sources such as an Excel workbook,a Word document,a text file,or another database.

Question 61

A company's ________ database is the database used to carry out day-to-day tasks,such as payroll and inventory management,of an organization.

Question 62

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

Question 63

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

Question 64

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

Question 65

A major use of historical data is for ________,predicting or estimating future sales trends,budget,and so forth.

Question 66

A(n)________ query is similar to a make table query,except that a query dataset is appended to an existing table.

Question 67

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

Question 68

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

Question 69

An outer join selects all of the records from one database table and only those records in the second table that have matching values in the joined field.

Question 70

An outer join,the default join type in Access,is a join that selects only those records from both database tables that have matching values.

Question 71

A company's ________ database is the database used to record daily transactions.

Question 72

A query join is a permanent 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.

Question 73

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.

Question 74

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

Question 75

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.

Question 76

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

Question 77

To delete records on the one side of the relationship and related records on the many side,enable Referential Integrity and Cascade Delete Related Records.

Question 78

The Find Unmatched Query Wizard finds records in one table that do not have related records in another table.

Question 79

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

Question 80

________ helps an organization attain their goals and objectives by giving them a better understanding of past performance as well as information on how the organization is progressing toward its goals.