Chapter Questions
When is it appropriate to use Filter by Selection and Filter by Form?
What restrictions does the Simple Query Wizard have for creating queries?
Why is it important to use the naming prefix "qry" for all saved queries?
Why is it not a good idea to add records to a table from a query datasheet?
What is the difference between entering multiple criteria for a query on one line of the design grid versus entering criteria on two or more lines?
What query wizards are available other than the Simple Query Wizard? For what do you use these types of queries?
What is the purpose of an outer join?
What role does "null" play in a field?
When should you use the Expression Builder?
What is a history table and why would a database designer include one or more in the design?
What is the difference between a query written in the query design grid and one written directly in SQL?
Describe a situation in which the IIF function would be appropriate.
What is the difference between an update query and an append query?
Why do many people run a delete query after running a make-table or append query?
Name an advantage that crosstab queries offer that other types of queries do not.