About This Training Course

In this training course, students will learn how to build basic lists and group reports that work with almost any database.

Subjects Covered

"Lesson 1: Creating a Report
- Set Default Report Settings
- Specify Fields for a New Report
- Preview a Report
- Modify Field Display
- Add a Report Title
- Position Fields
- Add Fields from Other Tables

Lesson 2: Displaying Specific Report Data
- Find Data
- Sort Data
- Filter Data by a Single Criterion

Lesson 3: Grouping Report Data
- Insert a Group
- Add Summaries
- Format Summary Information
- Change Group Options
- Add a Second-Level Grouping
- Filter Records by Group
- Create a Top N Sort Group

Lesson 4: Building Formulas
- Create a Formula
- Edit a Formula
- Combine Fields by Formula
- Delete a Formula
- Filter Data by Multiple Criteria
- Modify a Filter Using an OR Operator
- Create a Parameter Field
- Account for Null Fields in a Formula

Lesson 5: Formatting Reports
- Remove White Space
- Insert Page Header/Footer Data
- Add Borders, Boxes, and Lines
- Change Field Background colour
- Change the Margins

Lesson 6: Enhancing Reports
- Add a Watermark
- Insert Objects Using Object Linking and Embedding
- Modify Formatting Based on Data Value
- Suppress Report Sections
- Insert Hyperlinks
- Hide Blank Report Sections

Lesson 7: Creating Pie Charts
- Create a Pie Chart with a Drill-Down
- Modify Chart Text
- Format a Chart
- Present a Chart by Group

Lesson 8: Distributing Data
- Export to a PDF File
- Export to a Microsoft Excel File
- Export to an Access Database File
- Export a Report Definition
- Create Mailing Labels "

Prerequisites

It is recommended that students know how to launch and close programs; navigate to information stored on the computer; manage files and folders and use the Windows user interface.

Other Information

"This course can also be completed by the Walk-In Classroom Learning method. The New Horizons Walk-In Learning methodology was developed by industry professionals and certified trainers to provide a method of training that combines the least amount of time away from the office, with the most time dedicated to learning what they need to know.

The Walk-In Learning Approach: When students arrive at a New Horizons Walk-In centre, they are greeted by the mentor (a certified trainer with industry expertise) who will be mentoring and guiding them through their training. They are then assigned their own networked workstation containing two monitors. This environment allows for simultaneous access to the lecture delivered via recorded audio and video, and a live lab environment.

Why Walk-In Learning?

Flexible Scheduling: Flexible course schedules allow the student to determine when they attend training. The training schedule can be built around a work schedule so productivity in the workplace is maintained.

Focus on and learn relevant modules: Not every course is entirety relevant to a student’s needs. The Walk-In classroom allows you to focus on modules which are more relevant to the technology environment you work in and to your specific learning needs.

Time away from the office now reduced to ONE day blocks: Traditional ILT (Instructor Led Training) courses involved IT staff taking five continuous days out of the office to attend the course. This impacted the business and service levels. In the Walk-In classroom you can pick the days of training and create a custom attendance schedule to suit your calendar, projects and convenience."