Workshop
The Workshop includes quiz questions that are designed to help you test your understanding of the material covered and activities to help put what you've learned to practice. You can find the answers to the questions in the section immediately following the quiz.
Quiz
| 1: | If you have the Keep Together property set to Whole Group and the group is too large to fit on a page, Access ignores the property setting (True/False). |
| A1: | True. |
| 2: | It's always best to base a report on a stored query (True/False). |
| A2: | False. The only advantage of basing a report on a stored query is that you can share the query with multiple reports. |
| 3: | Name the property that allows a control to expand vertically to accommodate all the data in it. |
| A3: | The Can Grow property. |
| 4: | What property allows you to easily accumulate a value from record to record within a group or overall? |
| A4: | The Running Sum property. |
| 5: | Where does the Source Object property apply? |
| A5: | The Source Object property applies when you are working with subreports. |
Activities
Practice working with the report and control properties that you have learned about in this hour. Practice inserting page breaks and working with bound, unbound, and calculated controls. Finally, build a couple reports based on data stored in more than one table. Modify the sorting and grouping options that the wizard sets for you.
