Exam 10: Creating Advanced Queries

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.

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?

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

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

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

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

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

Which query criteria are equivalent to "Marketing" ?

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

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

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

The Description property appears on the Database Documenter reports. ____________________

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

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

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

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

Enter parameter query criteria in curly brackets. ____________________

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

Parameter criteria are always entered within ____.

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