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 and 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.

 

4. 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

5. 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 264, 271

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

2. A PivotChart in Access 2010 is created as a Report.
A. True
B. False
Tip: Advanced Access, page 255

3. A PivotChart in Access can be formatted like a Chart in Excel.
A. True
B. False
Tip: Advanced Access, page 259

Test Yourself