Test Yourself

1. You can use queries to filter the data on a form.

a. TRUE

b. FALSE

  Tip:   Advanced   Access, p 37

 

2. Which of the following is correct for Group By Totals?

(Select all correct answers)

a. The Group By Totals command can be found in Query Tools->Design

b. When you select the Totals button there will be a new row for Totals in the QBE grid

c. Queries read from left-to-right

  Tip:   Advanced   Access, p 39

 

 

3. You can link a query to a form with the Expression Builder.

a. TRUE

b. FALSE

  Tip:   Advanced   Access, p 40

 

4. Microsoft Access can filter data with a form. Which of the following is true about form filters.

(Select all correct answers)

a. The command can be found on Home ->Sort and Filter->Advanced

b. When you apply filters to a form the form fields will have drop-down combos

c. You can save a filter as a query.

  Tip:   Advanced   Access, p 53-55

 

5. There can be more than one filter. The additional filter can be found at the bottom of the page on the “Or” tab.

a. TRUE

b. FALSE

  Tip:   Advanced   Access, p 53

Very Satisfying

A couple of hours ago, you began this programming with the goal of making it easier to search and review the records in your database.

 

Well, do you think you made it work for Bo Fexler, Private Eye? Could Bo, or any other user in a hurry, find a movie and look up the details?

 

This was quite a process. You done good. You can have TWO cookies.