4.7 (750 reviews)
Learn to design queries to extract data for forms and reports.
We have 2 Intermediate courses. Each is a 1-day course. Choose the course that is most appropriate to you specific needs. Or book both at the same time and receive a 10% discount.
Mastering Access Queries
Complex Forms and Reports
Training available on Microsoft Access 365, 2019, 2016 and 2013. Select your version when making a booking.
Mastering Access Queries
Learn to design queries in Microsoft Access to collate and extract data from multiple tables in a database. This skills learned in this course are transferrable to most database applications as you will also learn to work with the underlying SQL query language.
What you will learn:
Queries to select data using various operators
Design advanced queries to find duplicates
Query multiple tables
Design parameter queries
Using the expression builder for calculations in queries
Use Action queries to update, append and delete data
Course Details
Audience:
This course is for individuals who are working with an existing database and needs to learn how to create queries.
Prerequisites:
Access Introduction or experience using an Access database. Basic understanding of Access structure, records, fields and data.
Inclusions
Training Manual with step by step instructions
Practice files relevant to the training material
Completed files - you are free to take away any completed files for review
Unlimited online support as training does not stop when you walk out our door
Course Content
Creating Queries
- Select Queries
- Using And, Or, Not and Between operators
- Excluding records in a query
- Finding Top or Bottom values
- Creating a Calculated Field
- Formatting Calculated Fields
Advanced Queries
- Find Duplicates query
- Find Unique Values
- Find Null Values
- Finding orphaned records
- Using data from multiple tables
- Exporting data from a query
Understanding Joins
- Working with multiple tables
- Understanding Joins
- Using different Join Types
Parameter Queries
- Using parameters to filter results
- Using the IN() operator in parameter queries
- Using wildcards in parameter queries
- Using parameters with calculations
Expressions & Expression Builder
- Manipulating text with expressions
- Calculating Date Values with Date(), DateDiff(), DatePart(), DateAdd() functions
- Using conditional IIF() expressions
- Aggregate Functions - Sum(), Avg(), Count()
Summary Queries
- Using Totals
- Understanding Total Functions and groups
- Mastering Summary queries
Action Queries
- Update queries
- Append queries
- Delete queries
- Make table queries
Querying with Forms
- Using a form form as a query criteria.
Access Complex Forms & Reports
What you will learn:
Design customised forms with calculations
Working with form design controls to enhance the user experience
Automate forms with buttons
Create complex grouped reports
Course Details
Audience:
Students who need to learn skills required to create or modify queries, forms and reports in an existing database.
Prerequisites:
Access Introduction or experience using an Access database. To gain the most from the course, participants must be familiar with database structure, tables, fields and properties.
Inclusions
Training Manual with step by step instructions
Practice files relevant to the training material
Completed files - you are free to take away any completed files for review
Unlimited online support as training does not stop when you walk out our door
Course Content
Learning Outcomes:
- Design customised Forms
- Develop more complex reports
- Using the Expression Builder effectively
- Automating Forms and Reports with buttons
Customised Forms/Reports
- Using the Field List
- Adding bound controls using the field list
- Adding unbound controls
- Binding an unbound control a control source
- Working with the Form sections
- Position, Resizing and Aligning Controls
- Adding lines, images, check boxes, Option Buttons and Groups
- Using Stacked layout
- Adding Command Buttons to navigate forms
- Changing the Tab Order of controls
- Creating Combo Boxes and List Boxes
- Using Multiple columns in a combo box
- Defining Field sizes and default values
Creating Complex Reports
- Using queries for Reports
- Grouping Data in a report
- Adding Headers and Footers
- Report Layouts - stepped & blocked
- Creating a Running Summary
- Using Columns in report
- Using the Keep Together property
- Sorting Report output
- Creating Labels
SubForms & SubReports
- Using sub-forms and sub-reports to display data from two different tables or - queries.
- Using Link Child and Link Master fields
Using Expression Builder with Forms and Reports
- Manipulating Text with expressions
- Calculating Date Values with Date(), DateDiff(), DatePart(), DateAdd() functions
- Using Conditional IIF() expressions
- Aggregate Functions - Sum(), Avg(), Count()
- Referring to subform/subreport controls in expressions
Automating Forms with Buttons
- Using the Control wizard to add a command button to a form
- Form Operations
- Record Operations
- Report Operations
- Formatting command buttons
Available Dates
Available Access Intermediate courses
| Event | Event Date | Location | Individual Price | Register |
|---|---|---|---|---|
| Access Queries Intermediate | 17-02-2025 | Live Online | $495.00 | |
| Access Complex Forms and Reports Intermediate | 18-02-2025 | Live Online | $495.00 | |
| Access Queries Intermediate | 15-05-2025 | Live Online | $495.00 | |
| Access Complex Forms and Reports Intermediate | 16-05-2025 | Live Online | $495.00 |
Brochure