Deck 10: Creating Advanced Queries

Question 1

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

Answer 1

True

Question 2

Action queries select but do not change data.

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

Enter parameter query criteria in curly brackets. ____________________

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

You can use the Top Values feature with or without first sorting the records

Question 15

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

Question 16

An outer join is the default join in the Join Properties dialog box.

Question 17

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

Question 18

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

Question 19

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

Question 20

For Select queries, the Datasheet View button and the Run button do the same thing.

Question 21

Access automatically creates link lines in Query Design View if the linking fields have the same name and the same data type in two tables. _____________________

Question 22

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
D) None of the above

Question 23

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

Question 24

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

Question 25

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
B) LIKE [Enter the first character of the last name:] & "*"
C) >=[Enter start date:]
D) None of the above

Question 26

An inner join occurs when a query displays only records in which joined fields from both tables are equal. _____________________

Question 27

The term blank describes a field value that does not exist because it has never been entered. ______________________

Question 28

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 29

Which of the following characters is a wildcard?

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

Question 30

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 31

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

Question 32

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 33

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

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

Question 34

Parameter criteria are always entered within ____.

A) (Parentheses)
B) {Curly brackets}
C) [Square brackets]
D) An error message indicating that the Top Values entry must be changed

Question 35

The Alias property renames a field list in Query Design View. ____________________

Question 36

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 37

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 38

The Description property appears on the Database Documenter reports. ____________________

Question 39

Which query criteria are equivalent to "Marketing" ?

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

Question 40

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 41

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 42

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 43

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 44

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 45

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

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

Question 46

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 47

The _____ property allows you to better document the purpose or author of a query.

A) Author
B) Description
C) Document
D) Purpose

Question 48

The _____ property renames a field list in Query Design View.

A) Alias
B) Description
C) Document
D) Alternate

Question 49

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 50

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 51

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

A) 1817
B) 1917
C) 2017
D) You must type 4 digits for year data.

Question 52

Access automatically adds ____ around date criteria.

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

Question 53

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 54

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 55

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

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

Question 56

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

Question 57

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

Question 58

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

Question 59

Which button do you use to complete an action query?

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

Question 60

The _____ feature in Query Design View allows you to specify a number or percentage of sorted records to display in a query result.

A) Count Records
B) Count Sorted
C) Top Values
D) Values Sorted

Question 61

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

Question 62

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

Question 64

Explain what a parameter query does.

Question 65

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

Question 66

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 67

Explain null and zero-length string values.

Question 68

A(n) _________________________ query selects fields and records that match specific criteria and displays them in a datasheet.

Question 69

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

Question 70

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

Question 71

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