Access Queries and Reports training

Course duration

(we will customise to your learning requirements and timeframe)

Target audience

This course is designed for those who already have a good understanding of Microsoft Access and need to create queries, and report on the data.

Download the PDF Course Outline.

Course Objectives

At the end of the course participants will be able to:

• Create Calculated Fields within Queries
• Create and use Action Queries
• Create and use Multi-Table Queries
• Build Advanced Queries and increase Query performance
• Create complex Reports, incorporating sub reports and calculated controls

Building Simple Queries

• Creating a Query
• Design View
• Adding Fields
• Datasheet View
• The QBE Grid
• Sorting
• Criteria
• Logical Operators
• Relational Operators

Applied Queries

• Creating and Formatting Calculated Fields
• Using Calculated fields in Combo Boxes

Action Queries

• Make-Table
• Append
• Update
• Delete
• Multi-Table Queries

Introductory Reports

• Creating a Report
• AutoReport
• Using Wizards to Create Reports
• Grouping and Subtotalling in a Report
• Creating Mailing Labels
• Mail Merge using Microsoft Word

Report Design

• Design View
• Formatting
• Aligning Controls
• Performing Calculations in Reports
• Dates and Times
• Combining Text Values
• Page Numbers
• Summary Calculations
• Sorting and Grouping in a Report
• Formatting a Report
• Embedding Images
• White Space