Using Microsoft Access 2003
Day 3: Designing and Customizing Reports
| Duration: | 1 day |
| Prerequisite: | Basic knowledge of the Microsoft Access environnment. |
| Course Materials: | Training book (350 pages) and handouts. |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | This class is Day 3 of a 3-day our Microsoft Access course. This class teaches you how to create attractive and practical reports. We start off with with creating quick, simple reports. We then discuss the fundamentals of good report design and go on to build advanced reports that are attractive and professional. You have the option of taking all 3 days of training (highly recommended), or cherry-picking topics from any of the 3 days of training to create a 1 or 2 day custom course. |
Creating and Publishing a Report
- Creating a Report with AutoForm
- Running AutoReport Directly on a Table or Query
- Running the AutoReport Wizard
- Creating Simple Reports with the Report Wizard
- Creating a Report in Design View
- Displaying the Design View
- The Architecture of Access Reports
- Understanding Report Controls
- Adding Fields to the Report
- Adding Labels to the Report
- Adding Page Numbers to the Report
- Adding the Date and Time to the Report
- Changing the Size of a Report Section
- Previewing the Report
- Assigning an AutoFormat in Design View
- Working with Report Properties
- Formatting the Background
- Manipulating Report Controls
- Publishing a Report
- Publishing on Paper
- Publishing to E-Mail
- Exporting to Another Format
- Publishing to Word or Excel
Designing Effective Business Reports
- Using Reports in Business
- What's In the Report?
- What is the Goal of the Report?
- Who Are Your Readers?
- Ten Design Guidelines for Business Reports
- Organizing Controls on the Report
- Making Good Use of Lines and Rectangles
- Creating Page Breaks
- Enhancing Report Text
- Formatting Text
- Text Formatting Tips and Guidelines
- Working with Colors
- Adding Images to Your Reports
- Adding Special Effects
- Create a Shadow Effect for Text
Designing Advanced Reports
- Sorting and Grouping a Report
- Setting Up Sorting Options
- Setting Up Grouping Options
- Sorting and Grouping Using an Expression
- Adding Calculations to a Report
- Inserting a Text Box
- Using Text Boxes as Calculated Controls
- Case Study: Creating a Invoice Report
- Advanced Methods for Launching a Report
- Launching a Report with a Command Button
- Launching a Report with a Macro
- Creating the Macro
- Associating the Macro with a Command Button
- Associating the Macro with a Report Event
- Controlling Report Output
- Adding Page Breaks After Sections
- Starting Sections at the Top of a Row or Column
- Avoiding Widowed Records
Creating Specialized Reports
- Creating a Multiple-Column Report
- Setting Up the Report
- Tweaking the Page Setup
- Troubleshooting Multiple Columns
- Case Study: Using Multiple Columns to Reduce Report Page Count
- Creating Mailing Labels
- Running the Label Wizard
- Creating a Custom Label
- Creating a Mail-Merge Report
- Creating a Multiple-Table Report
- Understanding Subreports
- Creating a Report and Subreport with the Report Wizard
- Creating a Subreport in the Report Design View
- Creating a PivotChart Report