Deck 3: Workshop 3: Queries and Data Access

Question 1

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 Pane
C)Arrows bar
D)Navigation bar

Answer 1

D

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.

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

Answer 2

A

Question 3

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

Answer 3

A

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.

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

Question 5

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

A)In the query window,you can include specific fields,define criteria,sort records,and perform calculations.
B)The query window in Design view allows you to specify the data you want to see by building a query by wizard.
C)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.
D)When you open Design view,by default,the Show Table dialog box opens with a list of available tables and queries to add.

Question 6

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,double-click it in the Navigation bar.
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 7

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

Question 8

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

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

Question 9

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

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

Question 10

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 11

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

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

Question 12

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

A)t?p
B)t#p
C)t*p
D)t!p

Question 13

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 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.

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

Question 15

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

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

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.

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

Question 17

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

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

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.

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

Question 19

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

A)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.
B)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.
C)If a one-to-many relationship exists between the two tables,then the wizard will join the two correct fields automatically.
D)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.

Question 20

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

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

Question 21

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

A)Field properties sheet
B)Navigation Pane
C)Expression Builder
D)Navigation bar

Question 22

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 23

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

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

Question 24

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

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

Question 25

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

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

Question 26

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 27

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

Question 28

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

A)Special operators are used to compare text values using Find & Replace along with the AND 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 in a set of values using the IN operator.
D)Special operators are used to compare text values using wildcards using the LIKE operator.

Question 29

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

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

Question 30

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)The calculation can use a combination of numbers and field values,which allows you flexibility in how you perform the calculation.
D)A calculated field is stored in the table once the query is saved.

Question 31

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 32

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

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

Question 33

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 34

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

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

Question 35

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

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

Question 36

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

A)Field properties sheet
B)Navigation Pane
C)Expression Builder
D)Navigation bar

Question 37

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 38

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

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

Question 39

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

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

Question 40

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 41

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

Question 42

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 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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 48

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 49

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

Question 50

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

Question 51

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 52

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 53

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 54

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

Question 55

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 56

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 57

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

Question 58

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

Question 59

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

Question 60

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 61

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 62

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 63

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 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

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 records with the same specific value.

Question 72

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

Question 73

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

Question 74

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

Question 75

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 76

To match any single character not within brackets,you would use the ________ wildcard character.

Question 77

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

Question 78

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 79

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

Question 80

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