Question 1

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

Accepted Answer

Since action queries modify the data in a table, the only way to confirm that the intended changes were made is to check the table after executing the query.

Question 2

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.

Accepted Answer

A make table query creates a new table to store the results, but it does not automatically load the dataset into Datasheet view; you must run the query to create the table.

Question 3

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

Accepted Answer

A transactional database is designed to record daily transactions, such as sales, purchases, and payments. It is optimized for recording and processing individual transactions in real-time, rather than analyzing large amounts of data.

Question 4

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

Accepted Answer

While both actions involve updating or deleting related records, the Cascade Update/Delete feature in the Relationships window automatically performs these actions when a user makes changes to a record in the parent table. Writing a specific update/delete query provides more control over the specific records that are affected.

Question 5

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

Accepted Answer

Switching to Design view allows you to create and modify the query, not preview the records that will be added to the other table. The preview of records can be seen in Datasheet view or by actually running the query.

Question 6

Data warehousing is a technology used to establish business intelligence.

Accepted Answer

Data warehousing is a technology used to establish business intelligence by collecting, storing, processing, and analyzing large sets of data from various sources to help make informed business decisions.

Question 7

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

Accepted Answer

The answer of Update queries are similar to the Find...

Question 8

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

Accepted Answer

It is always recommended to back up your data before making any changes or modifications to it. In case something goes wrong during the append query process, having a backup can prevent data loss and make data recovery easier.

Question 9

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.

Accepted Answer

The answer of An operational database contains a large amount...

Question 10

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 simple update query allows you to replace a value in a table with a new value, and you can specify both the value to be replaced and the replacement value.

Question 11

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

Accepted Answer

The statement accurately describes an append query.

Question 12

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.

Accepted Answer

The answer of When you update data from one table...

Question 13

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

Accepted Answer

An operational database is specifically designed to support day-to-day business operations, such as processing transactions and managing workflows. It is optimized for regular use and is often the backbone of an organization's information system.

Question 14

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

Accepted Answer

A simple delete query is used to remove data from a single table. To delete data from multiple tables, you would typically need to execute multiple delete queries or use a more complex SQL statement like a join with a delete.

Question 15

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.

Accepted Answer

The answer of One way BI tools are used is...

Question 16

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.

Accepted Answer

You can disable these warning messages in Access by adjusting the settings in the Access Options or by using VBA code to set the warnings off.

Question 17

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

Accepted Answer

A simple delete query is specifically designed to remove records from a table or another query.

Question 18

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

The answer of To run your action query in a...

Question 19

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

Accepted Answer

A delete query can remove entire records from a table in a single operation.

Question 20

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.

Accepted Answer

A make table query creates a new table from existing data; it does not add records to an existing table. To add records, an append query should be used.

Quiz 8: Workshop 8: Action Queries and Advanced Relationships