Question 1

To select records from the Customers table that have no related records in the Sales table, create a(n) _____ join.
A) inner
B) outer
C) self
D) referential

Accepted Answer

An outer join includes all records from one table and matching records from another table. In this case, a left outer join would return all records from the Customers table and any matching records from the Sales table, with null values for the Sales table fields where there is no matching record. By selecting records where there are null values in the Sales table fields, we can identify records in the Customers table that have no related records in the Sales table.

Question 2

A(n) self join selects all the records from the "one" table regardless of whether there is a related record in the "many" table.

Accepted Answer

The answer of A(n) self join selects all the records...

Question 3

Because action queries can modify many records at the same time, you should first create an update query to confirm the query is changing the correct records.

Accepted Answer

The answer of Because action queries can modify many records...

Question 4

You could use a(n) action query to delete all paid bills from last year.

Accepted Answer

An action query can be used to delete records from a table based on a certain criteria, such as deleting all bills that were paid last year.

Question 5

John wants to create a temporary table using only some fields from the Contacts table for contacts who live in Chicago. What type of query should he create?
A) Parameter
B) Make-Table
C) Append
D) Update

Accepted Answer

John should create a Make-Table query to create a temporary table with only the desired fields for contacts who live in Chicago. This will allow him to easily manipulate and work with the selected data without affecting the original Contacts table.

Question 6

To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.
A) inner
B) referential
C) self
D) outer

Accepted Answer

An outer join is used to combine records from two tables, including all of the records from one table and only the matching records from the other table. In this case, we want to select records from the Sales table that have no related records in the Customers table, which means that we need to include all of the records from the Sales table and only the matching records from the Customers table. Therefore, an outer join is the best choice.

Question 7

If you want to find records in the table on the "one" side of a one-to-many relationship that do not have related records in the "many" side, which join do you use?
A) inner
B) self
C) outer
D) cascading

Accepted Answer

You would use an outer join, specifically a left outer join, to find records on the "one" side that do not have related records in the "many" side. The left outer join will return all records on the "one" side and any related records on the "many" side, but will also return null values for any records on the "one" side that do not have related records on the "many" side.

Question 8

The purpose of a Delete query is to _____.
A) delete fields from a table
B) correct errors in table records
C) delete records from a table
D) move records to a backup table

Accepted Answer

The purpose of a Delete query is to delete records from a table. It is not used to delete fields from a table or move records to a backup table. While it is technically possible to use a Delete query to correct errors in table records, this is not its primary purpose and it is generally not recommended to use a Delete query for this task as it can result in the loss of important data.

Question 9

Allison wants to add text in the Comment field of every customer record with a particular set of characters in the Email field. What type of query should she create?
A) Make-Table
B) Crosstab
C) Append
D) Update

Accepted Answer

Allison wants to update the Comment field of customer records, so she should create an Update query. The Update query allows her to change existing data in a table based on certain conditions, such as finding records with a particular set of characters in the Email field. The other query types mentioned (Make-Table and Crosstab, and Append) are not relevant to updating existing data in a table.

Question 10

Hanna created a backup table listing renters in Springfield County, and now wants to add records to that backup table from the Rentals table for renters in Lincoln County. What type of query should she create to accomplish this?
A) Make-Table
B) Append
C) Top Values
D) Update

Accepted Answer

To add records from one table to another, an Append query should be created. The Make-Table query creates a new table based on the results of a query, rather than adding records to an existing table. The Top Values query returns only the top few records based on a specified criteria. The Update query changes the values of existing records in a table, rather than adding new records to the table.

Question 11

A Make-Table query is a type of _____.
A) select query
B) parameters query
C) action query
D) crosstab query

Accepted Answer

A Make-Table query is a type of action query that creates a new table based on the results of a select query. It is used to permanently store the results of a select query in a new table.

Question 12

When you change a select query to an Update query, Access displays the _____ row in the query design grid.
A) Update To
B) Totals
C) Calculated Field
D) Join

Accepted Answer

When changing a select query to an Update query in Access, the "Update To" row appears in the query design grid. This row allows the user to specify the new value or values for the field or fields being updated in the selected records. Therefore, option A is the correct choice.

Question 13

Which of the following could you use to export records to a new table?
A) Parameter query
B) Make-Table query
C) Update query
D) Delete query

Accepted Answer

A "Make-Table" query can be used to export records to a new table. This type of query creates a new table and inserts the selected records into it.

Question 14

Eric wants to remove records from the Offices table for offices in Texas. What type of query should he create?
A) Delete
B) Make-Table
C) Crosstab
D) Update

Accepted Answer

Eric should create a Delete query to remove records from the Offices table for offices in Texas.

Question 15

The outer join is the default join operation in Access.

Accepted Answer

The inner join is the default join operation in Access.

Question 16

In the Services table, Ian wants to change the value in the DiscountAmt field from .04 to .05 for Landscaping services. What type of query should he create?
A) Delete
B) Make-Table
C) Update
D) Find Duplicates

Accepted Answer

The answer of In the Services table, Ian wants to...

Question 17

Which action query would you use if you wanted to add records from one table to a backup table?
A) Append query
B) Delete query
C) Backup query
D) Update query

Accepted Answer

An append query is used to add records from one table to another. In this case, we want to add records from one table to a backup table, so an append query is the best choice.

Question 18

After running a Delete query, you cannot _____.
A) run another action query
B) undo the deletions
C) view the table with the deleted records
D) save the query

Accepted Answer

Once you have run a Delete query, you cannot undo the deletions. It is advised to always backup your data before running a Delete query. You can still run another action query, view the table with the deleted records, and save the query after running a Delete query.

Question 19

Append queries are most often used to add records to _____.
A) queries
B) table designs
C) table documentation
D) history tables

Accepted Answer

Append queries are used to add records to history tables, which store past data for reference or analysis.

Question 20

What type of query should you create if you want to change a manager's name from "Jones" to "Ames" for all selected records?
A) Update
B) Select with self join
C) Is Null
D) Append

Accepted Answer

An update query is used to modify data within a database. In this case, we want to update the manager's name from "Jones" to "Ames" for all selected records. An update query will allow us to do this efficiently and effectively.

Quiz 1: Access 2019

To select records from the Customers table that have no related records in the Sales table, create a(n) _____ join.

A(n) self join selects all the records from the "one" table regardless of whether there is a related record in the "many" table.

Because action queries can modify many records at the same time, you should first create an update query to confirm the query is changing the correct records.

You could use a(n) action query to delete all paid bills from last year.

John wants to create a temporary table using only some fields from the Contacts table for contacts who live in Chicago. What type of query should he create?

To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.

If you want to find records in the table on the "one" side of a one-to-many relationship that do not have related records in the "many" side, which join do you use?

The purpose of a Delete query is to _____.

Allison wants to add text in the Comment field of every customer record with a particular set of characters in the Email field. What type of query should she create?

Hanna created a backup table listing renters in Springfield County, and now wants to add records to that backup table from the Rentals table for renters in Lincoln County. What type of query should she create to accomplish this?

A Make-Table query is a type of _____.

When you change a select query to an Update query, Access displays the _____ row in the query design grid.

Which of the following could you use to export records to a new table?

Eric wants to remove records from the Offices table for offices in Texas. What type of query should he create?

The outer join is the default join operation in Access.

In the Services table, Ian wants to change the value in the DiscountAmt field from .04 to .05 for Landscaping services. What type of query should he create?

Which action query would you use if you wanted to add records from one table to a backup table?

After running a Delete query, you cannot _____.

Append queries are most often used to add records to _____.

What type of query should you create if you want to change a manager's name from "Jones" to "Ames" for all selected records?