
Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.
Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.
Access Intermediate
This course will help delegates to build on their basic understanding of Microsoft Access, covering the theory and application of creating a database; creating more complex queries; and enhancing data entry and reporting with forms and reports.
Course Topics
Querying Information in a Database
Select, crosstab, parameter queries • specifying criteria • adding calculated fields • calculating totals in queries • make table query • delete/update/append query
Creating Multiple Table Queries
creating relationships • outer & inner joins • query properties
Creating Grouped Reports
sorting and grouping data • creating/modifying a grouped report • group headers & footers • range and interval grouping • printing properties • calculating totals
Working with Sub-Reports
combining two or more reports • linking a main and subreport
Form Design
editing controls • calculated controls • properties of controls • sizing and aligning controls • setting a forms properties
Customising Forms
adding combo and list boxes • options for displaying yes or no values • creating option groups • adding command buttons
Main and Sub-Forms
creating a menu & sub-form • linking the main & sub-form together
Creating Dialog Box Forms
creating a menu form • using a form as a dialog box
General Topics
compacting & repairing a database • creating an auto-lookup query
Follow on Courses

Course Dates
On Request
Bring Your Own Device Option
This is a BYOD (bring your own device) course.
Don’t have a laptop? No worries, we can provide a PC for training.
Course Duration
1 day
Course Timings
9:30-16:30
Location
Ipswich
Prerequisites
Delegates should have attended the Introductory course or gained similar knowledge in the workplace.
Training Formats
Private course · tailored · 1 to 1 (all instructor led)
Manuals
A comprehensive course manual provides support throughout the course and upon your return to the office.
Not found the course you are looking for?