Deck 13: Queries and Data Access

Question 1

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

A) Drag
B) Single-click field name
C) Double-click title bar
D) Click, Shift, click

Answer 1

B

Question 2

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

A) 75?
B) 75#
C) 75##
D) 75!

Answer 2

C

Question 3

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

A) Find Duplicates
B) Crosstab
C) Find Unmatched
D) Simple

Answer 3

B

Question 4

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

A) m[?]t
B) m!t
C) m-t
D) m?t

Question 5

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

A) Find Duplicates
B) Crosstab
C) Find Unmatched
D) Simple

Question 6

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

A) Forward and Backward arrows
B) Navigation bar
C) Arrows bar
D) Navigation Pane

Question 7

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.

A) relationship
B) join
C) multiplier
D) query

Question 8

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.

A) Find Duplicates
B) Crosstab
C) Find Unmatched
D) Simple

Question 9

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

A) ar?
B) ar#
C) ar!
D) ar*

Question 10

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.

A) composite key
B) orphan
C) wildcard
D) duplicate key

Question 11

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

A) Find Duplicates
B) Crosstab
C) Find Unmatched
D) Simple

Question 12

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

A) To open an object in design view, right-click it in the Navigation Pane, and select Design View.
B) To open an object in default view, right-click it and select Edit.
C) To switch views for an already open object, on the Home tab, in the Views group, click the View arrow, and then select your preferred view.
D) To switch views for an already open object, right-click the object tab, and then select the preferred view.

Question 13

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

A) When you open Design view, by default, the Show Table dialog box opens with a list of available tables and queries to add.
B) When you use the query window, you have more control and more options available to manage the details of the query design than with the Simple Query Wizard.
C) The query window in Design view allows you to specify the data you want to see by building a query by wizard.
D) In the query window, you can include specific fields, define criteria, sort records, and perform calculations.

Question 14

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

A) wildcard character
B) Replace command
C) Find command
D) Find & Replace command

Question 15

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

A) wildcard character
B) Replace command
C) Find command
D) Find & Replace command

Question 16

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

A) A filter is a condition you apply permanently to a table or query.
B) You can choose to save a table with the filter applied so when you open the table later the filter is still available.
C) A filter is a simple technique to quickly reduce a large amount of data to a much smaller subset of data.
D) All records that do not match the filter criteria are hidden until the filter is removed or the table is closed and reopened.

Question 17

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

A) AutoFit
B) Form fit
C) Field size
D) Fit by selection

Question 18

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.

A) use the Find command
B) filter by selection
C) use the Replace command
D) use the Navigation bar

Question 19

Which of the following is NOT true about the Find Unmatched query wizard?

A) The wizard uses the primary key from the first table and matches it with the foreign key in the second table in order to determine if there are unmatched records.
B) The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in the same table or query.
C) The wizard will try to match the primary key field and the foreign key field if there is a one-to-many relationship between the two tables.
D) If a one-to-many relationship exists between the two tables, then the wizard will join the two correct fields automatically.

Question 20

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

A) everything except
B) part of
C) all of
D) all or part of

Question 21

Which of the following is NOT used as a comparison operator?

A) =
B) <*>
C) <=
D) >

Question 22

Which of the following is NOT true about changing field names in a query?

A) The default name that Access uses for a field that includes an aggregate function is descriptive and does not need to be changed.
B) Field names in aggregate queries are a composite of the selected aggregate function and the table field name.
C) The field names assigned in an aggregate query can easily be changed either before or after the query is run.
D) You must keep the original field name in the query design grid so Access knows what field to perform the calculation on.

Question 23

The Navigation bar allows you to move to the top and bottom of a table or scroll to a specific record and can be an efficient tool regardless of the size of the table.

Question 24

In a query,if you wanted to display the smallest value from the selected records,you would use the ________ aggregate function.

A) Count
B) Sum
C) Minimum
D) Maximum

Question 25

When you want to specify multiple criteria,and all criteria must be true for a record to be included in the results,then the ________ logical operator is used.

A) AND
B) OR
C) NOT
D) BETWEEN

Question 26

Datasheets are used to view all records in a table at one time.

Question 27

When you want to specify criteria in multiple fields,and at least one of the criteria must be true for a record to be included in the results,then the ________ logical operator is used.

A) AND
B) OR
C) NOT
D) BETWEEN

Question 28

________ equate the values in a table or another query to the criteria value you set up in a query.

A) Comparison operators
B) Is Null criteria
C) Search criteria
D) Query operators

Question 29

Which of the following is NOT true about using aggregate functions in a query?

A) Aggregate functions can be used in queries to perform calculations on selected fields and records.
B) By default, the query design grid has a place to enter aggregate functions.
C) One advantage to using aggregate functions in queries, rather than just a total row, is that you can group criteria and then calculate the aggregate functions for a group of records.
D) Each column or field can calculate only one aggregate function.

Question 30

________ perform arithmetic operations,such as calculating averages and totals,on records displayed in a table or query.

A) Aggregate functions
B) Special operators
C) Comparison operators
D) Is Null criteria

Question 31

Which of the following is NOT true about sorting query results on multiple fields?

A) In datasheet view, you can sort multiple fields by selecting all the fields at one time and using the Sort & Filter group sorts.
B) The second and subsequent fields are called secondary sort fields.
C) The first field you choose to sort by is called the primary sort field.
D) You can have one field sorted in ascending order and another in descending order.

Question 32

________ is a tool in Access that can help you format your calculated fields correctly.

A) Navigation Pane
B) Expression Builder
C) Property Sheet
D) Navigation bar

Question 33

Which of the following is NOT true about using special operators?

A) Special operators are used to compare text values using wildcards using the LIKE operator.
B) Special operators are used to determine whether values are between a range of values using the BETWEEN operator.
C) Special operators are used to compare text values using Find & Replace along with the AND operator.
D) Special operators are used in a set of values using the IN operator.

Question 34

Which of the following is NOT true about sorting query results on a single field?

A) To sort records, you have to select a sort field, or a field used to determine the order of the records.
B) A field may be sorted either in ascending order or descending order.
C) By default, records in a table or query are sorted by the primary key field.
D) Sorting is the process of rearranging records within a table in a specific order.

Question 35

In a query,if you wanted to display the number of records retrieved,you would use the ________ aggregate function.

A) Count
B) Sum
C) Minimum
D) Maximum

Question 36

In a query,if you wanted to display the largest value from the selected records,you would use the ________ aggregate function.

A) Count
B) Sum
C) Minimum
D) Maximum

Question 37

Calculated query fields must be formatted in the query design grid using the ________.

A) Navigation Pane
B) Expression Builder
C) Property Sheet
D) Navigation bar

Question 38

In a query,you can select any records that have no value in a field using the ________ criteria.

A) Query
B) Search
C) Is Null
D) Comparison

Question 39

Which of the following is NOT true regarding calculated fields?

A) The result of the calculated field is displayed each time you run the query.
B) A calculated field can be added to a query using the fields in the query or even fields in another table or query in the database.
C) A calculated field is stored in the table once the query is saved.
D) The calculation can use a combination of numbers and field values, which allows you flexibility in how you perform the calculation.

Question 40

If you need to see a quick snapshot of statistics for a table or query,you can use the ________.

A) total row
B) aggregate row
C) Function pane
D) statistics button

Question 41

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

Question 42

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

Question 43

To search for a word beginning with "a" and ending in "e" with any letter between "b" and "t" in between,you would enter b[a-e]t.

Question 44

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

Question 45

A filter is a condition you apply temporarily to a table or query.

Question 46

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

Question 47

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

Question 48

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

Question 49

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 known as the multiplier effect.

Question 50

To search for a word that starts with "e",contains any of the letters "a" or "r" and ends with "r",you would enter e[ar]r and get "ear" or "err" as a result.

Question 51

In addition to the Simple Query Wizard,there are three additional query wizards available to make quick,step-by-step queries.

Question 52

When using the Find Duplicates Query Wizard,you select the fields that you think may include duplicate information,and the wizard creates the query to find records matching your criteria.

Question 53

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

Question 54

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.

Question 55

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

Question 56

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

Question 57

The query window in Design view allows you to specify the data you want to see by building a query by example.

Question 58

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.

Question 59

A wildcard character can replace a single character or multiple characters for both text and numbers.

Question 60

The Simple Query Wizard provides the opportunity to select data criteria.

Question 61

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

Question 62

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

Question 63

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.

Question 64

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

Question 65

With multiple criteria,it is good practice to add one criteria,run the query to make sure you are getting the correct results,and then continue adding criteria one at a time.

Question 66

To manage larger tables,Access provides ways for you to quickly locate information within the datasheet.Once that information is found,it can then be easily replaced with another value using the ________.

Question 67

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

Question 68

To find all states that are not PA,you could enter < >"PA" for the state criteria.The < > is an example of a logical operator.

Question 69

A sort field can be a Short Text,Long Text,Number,Date/Time,Currency,AutoNumber,Yes/No,or Lookup Wizard field.

Question 70

Relationship lines are the lines connecting the tables that represent relationships.

Question 71

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

Question 72

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

Question 73

________ allow you to create a custom filter to match all or part of the text in a field that you specify.

Question 74

An aggregate function can be used in Datasheet view by adding a total row to a table.

Question 75

To match any single numeric character,you would use the ________ wildcard character.

Question 76

Comparison operators compare the values in a table or another query to the criteria value you set up in a query.

Question 77

Null is the absence of any value and is different from blank or zero.

Question 78

To match any number of characters,you would use the ________ wildcard character.

Question 79

By default,records in a table or query are sorted by the foreign key field.

Question 80

In a query,if you use multiple criteria,then you may also use logical operators to combine these criteria.