Access Module 10 Review

What criterion would you use to find numbers greater than or equal to 100?

>=100

You enter _____ criteria on the same row of the query design grid.

AND

_____ criteria are two or more criteria on the same Criteria row of the query design grid.

AND

Enter _____ criteria on different Criteria rows in the query design grid.

OR

What kind of criteria would you use to find records with OrderDate values in May or June?

OR

_____ criteria are two or more criteria on different Criteria rows of the query design grid.

OR

How can you identify a linked table in a database?

a linked table appears with a link icon in the navigation pane

In which of the following situations would you create a query with a self join?

you want to list managers and their employees

To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.

right outer

AND criteria means that all criteria must be true to select a record.

true

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

alias

To display a field list for the Employees table with the name "Managers" in Query Design view, you change the _____ property for the field list.

alias

A self join relates a record of a table to _____.

another record in the same table

To _____ a query, you right-click it in the Navigation Pane, and then click Copy on the shortcut menu.

copy

What is the first step in creating a query with a self join in Query Design View?

display two field lists for the same table

A(n) self join selects all the records from the "one" table regardless of whether there is a related record in the "many" table.

false

As you add AND criteria to the query design grid, you increase the number of records selected for the resulting datasheet.

false

The outer join is the default join operation in Access.

false

Use >500 as the criterion for a Number field in a query to select records with a value less than 500 in that field.

false

You cannot view a query with a self join in SQL View.

false

How do you specify an outer join between two tables?

in query design view, double-click the join line

If you want to find records in the table on the "one" side of a one-to-many relationship that do not have related records in the "many" side, which join do you use?

left outer

What does the criterion <=200 mean?

less than or equal to 200

To select records from the Customers table that have no related records in the Sales table, create a(n) _____ join.

outer

In a database with a Products table and Orders table, you want to see which products have not been ordered. What type of query should you create?

select query with an outer join

A(n) _____ join relates a record of a table to another record in the same table.

self

Create a(n) _____ join to relate an Employee table to itself using two fields in the same table to identify the relationship between employees and supervisors.

self