Question 1

Create a(n) _____ query to change the name of a supervisor in an Employee table.
A) Make-Table
B) Update
C) Self-Join
D) Target

Accepted Answer

The correct choice to change the name of a supervisor in an Employee table is to use an Update query. This will allow for the specific supervisor's name to be changed in the table without affecting any other information. Make-Table, Self-Join, and Target queries are not relevant for this task.

Question 2

A join line is also called a _____ line.
A) query
B) connection
C) link
D) property

Accepted Answer

Join line is commonly referred to as a link. While query and connection are related to database and network respectively, property is not relevant to describe the join line.

Question 3

All the fields selected in a(n) _____ query must match fields with the same data types in the target table.
A) Make-Table
B) Crosstab
C) Apply
D) Append

Accepted Answer

The Append query is used to combine data from two or more tables, and all fields selected in the query must match fields with the same data types in the target table to ensure data integrity. The Make-Table query is used to create a new table with the results of the query, the Crosstab query is used to create summary reports, and the Apply query is not a valid type of query in Microsoft Access.

Question 4

To create an Update query in Query Design view, you use the Add to row in the query design grid.

Accepted Answer

To create an Update query in Query Design view, you use the "Update To" row in the query design grid, not the "Add to" row.

Question 5

When building an action query, you do not change data until you click the _____ button.
A) Update
B) Select
C) Run
D) View

Accepted Answer

Running the action query is what actually changes the data in the selected records. The Update and View buttons are available within the query design and do not change data until the query is run. The Select button is used to choose the fields and criteria for the query, but does not change data.

Question 6

After setting up a Delete query, you delete selected records by clicking the _____ button.
A) Delete
B) Run
C) View
D) Select

Accepted Answer

After setting up a Delete query, you need to run it to delete the selected records. Therefore, the correct choice is B) Run.

Question 7

Access provides four types of action queries: _____, Append, Delete, and Update.
A) Top Values
B) Crosstab
C) Make-Table
D) Inner Join

Accepted Answer

Make-Table is the correct type of action query among the options given, alongside Append, Delete, and Update. These queries are used to perform actions on the data in the database, such as creating new tables (Make-Table), adding data (Append), removing data (Delete), and modifying data (Update).

Question 8

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

Accepted Answer

This statement is true. The join line is used to identify the fields that establish a relationship between the two tables being used in the query.

Question 9

Delete queries delete entire records, not just selected fields within records.

Accepted Answer

Delete queries delete entire records, not just selected fields within records.

Question 10

As with other action queries, the icon for an Append query includes a(n) _____ to remind you that it changes data when you run the query.
A) question mark
B) red asterisk
C) exclamation point
D) red X

Accepted Answer

The exclamation point icon is used for action queries to remind the user that it will change the data when run.

Question 11

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

Accepted Answer

An action query, like a Make-Table query, can make changes to all selected data in a database when executed.

Question 12

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

Accepted Answer

The answer of When you click the Delete button in...

Question 13

Using an Append query, you can append a Short Text field from one table to a Number field in another table.

Accepted Answer

A Short Text field cannot be appended to a Number field because they are different data types. The data types of the fields being appended must match in order for the append query to work properly.

Question 14

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

Accepted Answer

The answer of If you want to increase the price...

Question 15

If you want to export records to another Access database, create a Top Values query.

Accepted Answer

The answer of If you want to export records to...

Question 16

To remove retired employees from an Employee table, create a(n) _____ query.
A) Delete
B) Parameter
C) History
D) Update

Accepted Answer

The Delete query is used to remove data from a table. In this case, the retired employees need to be removed from the Employee table, so a Delete query would be the best choice.

Question 17

An Append query adds selected records to an existing table.

Accepted Answer

An Append query adds selected records to an existing table.

Question 18

A Make-Table query is a type of action query that creates a new table of data.

Accepted Answer

A Make-Table query does indeed create a new table of data.

Question 19

If you want to remove records for discontinued products from a Products table, create a(n) Update query.

Accepted Answer

The answer of If you want to remove records for...

Question 20

A Make-Table query is a type of _____ query that creates a new table of data.
A) action
B) select
C) structured
D) create

Accepted Answer

A Make-Table query is a type of action query in database systems, specifically designed to create a new table and populate it with data based on the results of the query.

Quiz 9: Exploring Financial Tools and Functions

Create a(n) _____ query to change the name of a supervisor in an Employee table.

A join line is also called a _____ line.

All the fields selected in a(n) _____ query must match fields with the same data types in the target table.

To create an Update query in Query Design view, you use the Add to row in the query design grid.

When building an action query, you do not change data until you click the _____ button.

After setting up a Delete query, you delete selected records by clicking the _____ button.

Access provides four types of action queries: _____, Append, Delete, and Update.

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

Delete queries delete entire records, not just selected fields within records.

As with other action queries, the icon for an Append query includes a(n) _____ to remind you that it changes data when you run the query.

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

Using an Append query, you can append a Short Text field from one table to a Number field in another table.

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

If you want to export records to another Access database, create a Top Values query.

To remove retired employees from an Employee table, create a(n) _____ query.

An Append query adds selected records to an existing table.

A Make-Table query is a type of action query that creates a new table of data.

If you want to remove records for discontinued products from a Products table, create a(n) Update query.

A Make-Table query is a type of _____ query that creates a new table of data.