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.
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
Other Access Training Courses
Access Introduction
Access Advanced
StressLess Learning, Microsoft Access Training Experts