Practice Activities

Lesson 9: Prepare to Share Try This: Do the following steps 1. Open your Brown Bag Lunch database. Or, you may download BBL Adv ver9.accdb 2. Create a CrossTab Query with the Query Wizard. Use the following answers: Record Source: ItemSQ. Row Headings: Type Column Headings: Specialty Select Item for the Calculated Field and use COUNT for the Function. Save the Query: ItemSQ_Crosstab. 3. Export the ItemSQ_Crosstab to Microsoft Excel. Save it in your Documents Folder. 4. Go to the Documents Folder, open the spreadsheet in Excel and review the data. Did this spreadsheet include any Formulas? Close this file and return to Access. 5. Save and Close the Query. 6. Go to Access and open a Report: Products by Specialty. 7. Export the Report as a Text File. Save it to your Documents Folder as Products by Specialty-rtf. Go to the Documents Folder, open the document in Word and review the formatting. Close this file and return to Access. 8. Export the Report as a PDF File. Save it to your Documents Folder as Products by Specialty-pdf. Go to the Documents Folder, open the document in Adobe Acrobat. Close this file and return to Access. 9. Close the Report. Close the Brown Bag Lunch database.   2. Which of the following is true about PivotChart Filters? (Give all correct answers.) A. Can Filter data on the Chart by adding or removing Fields B. Controls are available in Layout View C. Controls are not available in Print Preview Tip: Advanced Access, page 264 3. Which are options for sharing Access data? (Give all correct answers.) A. Excel B. Word C. PDF/ XPS D. E-mail E. Text File Tip: Advanced Access, page 263, 264 1. Which is true about a CrossTab Query? (Give all correct answers.) A. Creates a Table that compares data B. Can use a Table or Query as a Record Source C. Can use many math functions, such as Count and Sum Tip: Advanced Access, page 248, 252 Test Yourself