Deck 12: Creating Advanced Queries

Question 1

It is wise to make a current backup of the database before running any action query.

Answer 1

True

Question 2

Action queries select but do not change data.

Answer 2

False

Question 3

The datasheet shown in the figure above sorts records on the EnrollmentID field.

Answer 3

True

Question 4

In the figure above, what Top Values option is chosen?

A) Top 5
B) Top 100
C) Top 5%
D) All

Question 5

In the figure above, what does item 2 toggle on and off?

A) Criteria row
B) Totals row
C) Show row
D) Sort row

Question 6

When you run an action query Access prompts you with an "Are you sure?" message before actually changing the data.

Question 7

An action query changes data as soon as the type of action query is chosen from the Query Type list.

Question 8

In the figure above, what does item 3 refer to?

A) Count of EnrollmentID field
B) Sum of EnrollmentID field
C) Subtotal of records with numeric values
D) Total of EnrollmentID field

Question 9

The Top Values feature creates summarized calculations on groups of records.

Question 10

In the figure above, which field is being grouped?

A) Enrollments
B) EnrollmentID
C) Description
D) CourseID

Question 11

Double-clicking an action query in the Navigation Pane runs the query.

Question 12

In the figure above, how will the records be presented?

A) Smallest to largest by count of EnrollmentID
B) Largest to smallest by count of EnrollmentID
C) Smallest to largest group by Description
D) Largest to smallest group by Description

Question 13

This kind of operator selects all records between 2 specified values.

A) Find Unmatched
B) Make Table
C) Between...And
D) Yes/No

Question 14

In the figure above, item 1 refers to which feature?

A) Group By
B) Totals
C) Top Values
D) Query Type

Question 15

In the figure above, the parameter criteria is ____.

A) Descending
B) Group By
C) 5
D) There is no parameter criteria in the figure.

Question 16

In Query Design View, the asterisk in the field list represents all the fields in the table.

Question 17

If you use the Top Values option to show the top 5 records and there is a tie for fifth place, the datasheet will display ____.

A) Only four records
B) The first four records plus all records that tie for fifth place
C) The first four records plus one record for fifth place determined by the value in the key field of the records that tie
D) An error message indicating that the Top Values entry must be changed

Question 18

If you modify a field's properties in Table Design View, they are modified for the entire database.

Question 19

In the figure above, which field is being counted?

A) Enrollments
B) EnrollmentID
C) Description
D) CourseID

Question 20

To prevent running an action query accidentally, use the Run button to view the selected records.

Question 21

Which action query would you use if you wanted to export records to another Access database?

A) Make-Table
B) Top Values
C) Update
D) Delete

Question 22

Access automatically adds ____ around date criteria.

A) Quotation marks
B) Pound signs
C) Square brackets
D) Asterisks

Question 23

In the figure above, item 7 refers to the ____ query button.

A) Append
B) Delete
C) Make Table
D) Update

Question 24

In the figure above, item 5 refers to the ____ query button.

A) Append
B) Delete
C) Make Table
D) Update

Question 25

In the figure above, item 6 refers to the ____ query button.

A) Append
B) Delete
C) Make Table
D) Update

Question 26

If a parameter query prompts and searches for any name that begins with the entered character, then which of the criteria cell entries below is the correct one?

A) >=[Enter start date:] and <=[Enter end date:]
B) LIKE [Enter the first character of the last name:] & "*"
C) >=[Enter start date:]
D) None of the above

Question 27

Which button do you use to complete an action query?

A) View
B) Select
C) Show
D) Run

Question 28

The criteria cell entry: LIKE [Enter the first character of the company name:] & "*" searches for companies that do which of the following?

A) Contain the parameter entry anywhere in the field
B) End with the specified letter
C) Have only one character
D) Begin with the specified character

Question 29

The ____ entry in the Recordset Type property locks the recordset.

A) Snapshot
B) Dynaset
C) Dataset
D) Lockset

Question 30

Which of the following is true about the criteria cell entry: LIKE [Enter the first character of the company name:] & "*"?

A) [Enter the first character of the company name:] is the parameter prompt.
B) & is the wildcard.
C) "*" is the second parameter prompt.
D) All of the above.

Question 31

Which of the following is a valid parameter criterion?

A) >=Type date here
B) >=(Type date here:)
C) >={Type date here}
D) >=[Type date here:]

Question 32

In the figure above, item 4 refers to the ____ query icon.

A) Append
B) Delete
C) Make Table
D) Update

Question 33

If a parameter query prompts and searches for words that contain the entered characters anywhere in the field, then which of the criteria below is the correct one?

A) LIKE [Enter the first character of the last name:] & "*"
B) LIKE "*" & [Enter any character(s) to search by:] & "*"
C) [Enter start date:]
D) None of the above

Question 34

All action query icons display a(n) ____ in the icon.

A) Asterisk (*)
B) At symbol (@)
C) Percent sign (%)
D) Exclamation point (!)

Question 35

Which of the following is NOT a type of action query?

A) Select
B) Delete
C) Update
D) Make-table

Question 36

If a parameter query prompts and searches for dates on or after the entered date, then which of the criteria below is the correct one?

A) LIKE [Enter start date:]
B) LIKE [Enter start date and end date:]
C) >=[Enter start date:] and <=[Enter end date:]
D) None of the above

Question 37

Parameter criteria are always entered within ____.

A) (Parentheses)
B) {Curly brackets}
C) [Square brackets]
D)

Question 38

Which query criteria are equivalent to "Marketing" ?

A) "marketing"
B) "MARKETING"
C) "mArKeTiNg"
D) All of the above

Question 39

When building an action query, data will not be changed until you click the ____ button.

A) Datasheet
B) Query Type
C) Run
D) Update

Question 40

Which of the following characters is a wildcard?

A) Ampersand (&)
B) Asterisk (*)
C) Plus Sign (+)
D) Percent Sign (%)

Question 41

Explain what a parameter query does.

Question 42

A(n) _________________________ query displays a dialog box prompting you for information to enter as limiting criteria each time the query runs.

Question 43

A(n) _________________________ query is one that makes changes to the data. There are several types of these queries.

Question 44

When you click the Update button from the Query Type list, the _________________________ To row is added to the query design grid.

Question 45

In Query Design View, double-click the _________________________ at the top of a table's field list to quickly add all fields within the table to the query design grid.

Question 46

A table has a(n) _________________________ record when information in the foreign key field of the "many" table doesn't have a matching entry in the primary key field.

Question 47

List the four types of action queries and give an example of what each would do.

Question 48

Use the Find _________________________ Query Wizard to find records in one table that do not have matching records in a related table.

Question 49

Which action query would you use if you wanted to remove product records that are discontinued from a Products table?

A) Delete
B) Update
C) Append
D) Make-Table

Question 50

When you click the Append button from the Query Type list, the _________________________ To row is added to the query design grid.

Question 51

Use the Find _________________________ Query Wizard to find records in one table that have the same values in a field.

Question 52

Which action query would you use if you wanted to change the name of a manager from "Smith" to "Jones" for all selected records?

A) Delete
B) Update
C) Append
D) Make-Table

Question 53

If you type the last 2 digits of a year as 31, such as 1/1/31, Access assumes that they signify:

A) 1931
B) 2031
C) 1831
D) You must type all 4 digits for a year.

Question 54

In the figure above, item 1 refers to the _________________________ Values list arrow.

Question 55

Items 3 through 7 shown in the figure above are Query _________________________ buttons displayed on the DESIGN tab.

Question 56

When you click the Delete button from the Query Type list, the _________________________ row is added to the query design grid.

Question 57

If you type the last 2 digits of a year as 13, such as 1/1/13, Access assumes that they signify:

A) 1813
B) 1913
C) 2013
D) You must type 4 digits for year data.

Question 58

In a one-to-many relationship with referential integrity, the "one" table contains ____ records and the "many" table contains ____ records.

A) parent ~ child
B) orphan ~ parent
C) orphan ~ child
D) child ~ parent

Question 59

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

A) Delete
B) Update
C) Append
D) Make-Table

Question 60

If you wish to increase the price of a product in a particular category by 10%, you could use a(n) ____ query.

A) Select
B) Make-table
C) Append
D) Update

Question 61

Explain null and zero-length string values.

Question 62

Like [Enter the first character of the last name:]& "*" is an example of the Like operator used with parameter criteria. ____________________

Question 63

To enter a long criterion, right-click the Criteria cell then click Expand. ____________________

Question 64

Click the VIEW tab on the ribbon to create a backup. ____________________

Question 65

Enter parameter query criteria in curly brackets. ____________________

Question 66

A backup is a copy of the database that you could use if an error occurs in the current database that cannot be fixed. ____________________

Question 67

The Description property appears on the Database Documenter reports. ____________________

Question 68

To enter a long criterion in Query Design View, right-click the Criteria cell, then click Zoom. ____________________

Question 69

Records are characteristics that define the appearance and behavior of items in the database such as objects, fields, sections, and controls. ____________________

Question 70

Match each term with the best choice.
a.Make Table query
d.Action query
b.Append query
e.Update query
c.Delete query
Makes global changes to the values in a field

Question 71

You can keep an action query in the Navigation Pane but hide it using the Action property. ____________________

Question 72

A prompt query displays a dialog box that prompts you for field criteria. ____________________

Question 73

Read/write is the default value for the Recordset Type property which allows you to update data. ____________________

Question 74

Match each term with the best choice.
a.Make Table query
d.Action query
b.Append query
e.Update query
c.Delete query
Creates a new table from all or part of the data in one or more tables

Question 75

Explain how to query for null and zero-length string values.

Question 76

The Like operator is used with the asterisk wildcard in query criteria. ____________________

Question 77

Match each term with the best choice.
a.Make Table query
d.Action query
b.Append query
e.Update query
c.Delete query
Removes a group of records from one or more tables

Question 78

You can build a form or report based on a parameter query. ____________________

Question 79

Match each term with the best choice.
a.Make Table query
d.Action query
b.Append query
e.Update query
c.Delete query
Adds a group of records from one or more tables to another table

Question 80

Match each term with the best choice.
a.Make Table query
d.Action query
b.Append query
e.Update query
c.Delete query
Changes all selected records