Question 1

The ________ allows you to move to the top and bottom of a table or scroll to a specific record.

Accepted Answer

The Navigation Bar is the tool in Access that allows you to move to the top and bottom of a table or scroll to a specific record. The Forward and Backward arrows will only move you between records that have already been accessed, while the Navigation Pane and Arrows bar are not specific features in Access.

Question 2

When you ________,you select a value in a record and Access filters the records that contain only the values that match what you have selected.

Accepted Answer

When you filter by selection, you select a value in a record and Access filters the records that contain only the values that match what you have selected. The other options listed (Find command, Replace command, Navigation bar) do not involve filtering records based on a selected value.

Question 3

A ________ query is used when you want to find records with the same specific value.

Accepted Answer

A Find Duplicates query will return records with the same specific value, which is exactly what the question is asking for. The other options (B) Crosstab, (C) Find Unmatched, and (D) Simple, are not relevant to finding records with the same specific value.

Question 4

A(n)________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

Accepted Answer

An orphan is a foreign key in one table that does not have a matching value in the primary key field of a related table. This can occur when a record in the parent table is deleted without also deleting the related records in the child table, leaving them without a proper relationship to any record in the parent table.

Question 5

Which of the following is NOT true about creating queries in Design view?

Accepted Answer

In Design view, you build queries manually by specifying fields, criteria, and other options. The Simple Query Wizard is a separate tool that guides you through the process of creating a query using a series of prompts and pre-built options. Therefore, statement B is false, as it implies that the Design view allows you to build a query using a wizard.

Question 6

Which of the following is NOT a method used to open or switch views?

Accepted Answer

All other options are valid methods used to open or switch views. Option B is incorrect as there is no such thing as the Navigation bar. The correct term is Navigation Pane.

Question 7

A ________ query is used when you want to describe one field in terms of two or more fields in the table.

Accepted Answer

A Crosstab query allows you to summarize data based on two or more fields, creating a table with rows and columns that represent the intersection of those fields.

Question 8

Which of the following is NOT a method used to add fields to a query design grid?

Accepted Answer

The answer of Which of the following is NOT a...

Question 9

________ is a feature that can change the column width of the data to match the widest data entered in that field.

Accepted Answer

AutoFit is the feature that adjusts the column width to fit the widest data in that field. This ensures better readability of the data and makes it easier to work with large datasets.

Question 10

Which of the following is NOT true about applying filters to a datasheet?

Accepted Answer

A filter is a temporary condition applied to a table or query, not a permanent one. The other options are true statements about applying filters.

Question 11

To search for a word that starts with "ar" you would enter ________.

Accepted Answer

The asterisk (*) is a wildcard character that can stand for any number of characters, so entering "ar*" will find any word that starts with "ar". The other options are not appropriate for this search - "?" stands for a single character, "#" is not a wildcard character, and "!" has no special meaning in a search context.

Question 12

To search for a three-letter word that starts with "t" and ends with "p" you would enter ________.

Accepted Answer

The symbol "?" is a wildcard that represents any single character. Therefore, entering "t?p" in a search would find any three-letter word that starts with "t" and ends with "p".

Question 13

Text filters allow you to create a custom filter to match ________ the text in a field that you specify.

Accepted Answer

The text filter allows you to create a filter that matches all or part of the text in a field that you specify. This means that both choosing "all" and "part of" would be correct, but "all or part of" is the most accurate option. "Everything except" would not be a valid option for a text filter.

Question 14

A ________ query is used when you want to find the rows in one table that do not have a match in the other table.

Accepted Answer

A "Find Unmatched" query, also known as a "Left Outer Join" or "Not In" query, is used to identify records in the first table that do not have matching records in the second table. This is useful when comparing data from two separate tables and trying to identify any missing or incomplete information.

Question 15

To search for a three-digit number that starts with "75" you would enter ________.

Accepted Answer

The answer of To search for a three-digit number that...

Question 16

If two tables do not have a common field,Access will join the two tables by combining the records,regardless of whether they have a matching field.This is called the ________ effect.

Accepted Answer

The described effect is called the multiplier effect, where all possible combinations of records are created from the two tables without a common field. This can result in a large amount of duplicate data and is not recommended unless absolutely necessary.

Question 17

A ________ is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

Accepted Answer

A wildcard character is a symbol that can be used to represent one or more characters in a value. It is commonly used in search and replace operations where a specific part of the value is unknown or can vary. Examples of wildcard characters are the asterisk (*) and question mark (?).

Question 18

The ________ Query Wizard is used to display fields from one or more tables or queries with the option to choose a detailed or summary query if working with more than one table.

Accepted Answer

The Simple Query Wizard is the best choice for displaying fields from one or more tables or queries with options for detailed or summary queries. The other options listed are designed for specific purposes such as finding duplicates or unmatched records.

Question 19

Which of the following is NOT true regarding the Find Unmatched query?

Accepted Answer

The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in a different table or query, not the same table or query.

Question 20

In Datasheet view,you can use the ________ to quickly locate specific records using all or part of a field value.

Accepted Answer

The Find command allows you to search for specific records using all or part of a field value. The Replace command is used to replace specific values within a field. The wildcard character can be used in combination with the Find command but is not necessary to locate specific records. The Find & Replace command is a combination of the Find and Replace commands, and is not necessary for simply locating specific records.

Quiz 3: Workshop 3: Queries and Data Access