COURSE
DESCRIPTION FOR
CUSTOMIZE YOUR REPORTS USING ACCESS
Dazzle coworkers with polished reports. Explore the many
ways Access and other compatible applications can help you create customized
reports for your specific needs. You will also discover techniques for producing
attractive reports and how to share them with non Access users. Learn to:
- Create and enhance subreports in two different report
contexts.
- Add a chart to a report and modify the chart by changing
properties and using Microsoft Graph.
- Add special data and text effects to a report.
- Share Access reports with users who do not have Access.
LENGTH
One four hour session.
PREREQUISITES
Access - Level 2 or equivalent
knowledge. You also need to have a good understanding of basic Microsoft
Windows, file management and personal computers.
SPECIFIC CLASS CONTENT
Lab Activity 1: Use subreports
Identify the main report
Create a query
Add the subreport
Enhance the reports
Lab Activity 2: Add charts
Create a pie chart
Dress up the chart
Change the data source and chart type
Lab Activity 3: Add special effects
Include parameter values
Have conditional text
Create a watermark
Use fancy text
Lab Activity 4: Share reports
Export a snapshot
Share the snapshot
Use Snapshot Viewer
Put in on the Web
View the HTML version
NECESSARY SOFTWARE AND HARDWARE
- Access 97 or 2000. For the "Add charts" activity,
you need Microsoft Graph installed. Word 97 or 2000 including WordArt is
necessary for the activity "Add special effects". Snapshot Viewer
and browser software are needed for the "Share reports" activity.
- A printer (optional).
OTHER ACCESS CLASSES
- Access 2000 - Advanced. Create
advanced queries, work with macros and design forms and reports.
- Mini Power Sessions:
--Analyze Your Product And Sales Data Using Access
--Manage, Plan And Analyze Your Inventory Using Access
--Create And Normalize A Database From Excel Using Access
--Produce Letters, Lists And Catalogues Using Access And Word
| 