Microsoft Access Anniversary Power User Quiz

Welcome to the third Microsoft Access Anniversary Quiz! So, you think you're an Access power user? Even if you aren't sure, feel free to take this quiz. You'll sharpen your skills, increase your knowledge, and get a chance to win valuable prizes.

---

E-mail this quiz

1. What is the primary difference between a PivotTable report and a crosstab query? a. A PivotTable report can contain sums, counts, and averages, while a crosstab query cannot. b. You can't "pivot" a crosstab query. c. A crosstab query lets you group similar items. A PivotTable report does not.

2. What is the purpose of a subdatasheet? a. To provide a hierarchical view of related tables or queries in a single window. b. To display grouped data in a report. c. To display summarized data.

3. Which of the following are common ways to enforce data validation when entering data into an Access form? a. Create an input mask to restrict the kind of values that can be entered in positions across the field. b. Define a validation rule for that field. c. Both of the above.

4. AutoReports can contain each of the following elements except: a. A detail section. b. A page footer. c. A group header.

5. In Access, the best types of queries to use for data analysis are: a. Select queries. b. Parameter queries. c. Action queries.