COURSE DESCRIPTION FOR
ANALYZE PRODUCT AND SALES DATA USING ACCESS
DESCRIPTION
Do you need to create effective and efficient summaries
of large amounts of product and sales data? This course will show you the
many tools Access has to help you. See how to create a crosstab query, report
and chart and a Pivot form. The class is instructor-led with plenty of hands-on
activities. Learn to:
- Create and modify a crosstab query to summarize a large
amount of data.
- Create a report and a chart based on a crosstab query
to present the summary in an attractive and effective printed format.
- Create a Pivot form and modify a PivotTable as another
tool for summarizing data.
- Design crosstab queries and Pivot forms to save time
and work in analyzing data.
LENGTH
One four hour session.
PREREQUISITES
Access - Level 1 or have equivalent
knowledge. You also must have a good understanding of basic Microsoft Windows,
file management and personal computers.
SPECIFIC CLASS CONTENT
Lab Activity 1: Query it
Begin with the data
Create a crosstab query
Anatomy of a crosstab query
Refine the query design
Lab Activity 2: Report and chart it
Create a report of summary information
Chart the data
Make it easy to read
What does the data mean?
Explore changes to the chart
Lab Activity 3: Pivot it
Create a Pivot form
Modify the PivotTable
Do more with the PivotTable
Lab Activity 4: Make it flexible and efficient
Prompt for crosstab criteria
Another way to use a parameter
Build in flexibility
Pivot forms can be flexible too
NECESSARY SOFTWARE AND HARDWARE
Windows 95 or Windows 98, Access 97 or higher with the
Chart Wizard installed, and, for certain activities, Excel 97 or higher
and Microsoft Graph 8.0 or higher.
WHAT'S NEXT
- Access - Advanced. Create advanced queries, work with
macros and design forms and reports.
- Mini Power Sessions:
--Analyze Your Product And Sales Data Using Access
--Customize Your Reports Using Access
--Manage, Plan And Analyze Your Inventory Using Access
--Produce Letters, Lists And Catalogues Using Access And Word
| 
