Access Intermediate
Duration: 6 Hrs ( 2 @ 3 hr sessions )
In this Access course we learn how to use Microsoft Access for intermediate level Database design.
Level – Intermediate
This course is intended for those who have completed an introduction course to Access or wish to progress their knowledge.
Live Virtual Training Dates
Why not attend one of our scheduled Live Virtual Training Dates
Access Intermediate Course Details
Course Objectives
∎ This course explains how to use Microsoft Access to create an Intermediate Level database.
∎ The Intermediate course is intended for those who have completed an introduction course to Access and wish to progress their knowledge
∎ We learn how to create a database including building tables, designing queries and forms, building reports and macros.
Course Content
∎ The Access Environment
∎ Designing Tables
∎ Normalising Data
∎ Establishing Relationships
∎ Working with Indexes
∎ Working with Data Types
∎ Designing Queries
∎ Creating Action Queries
∎ Creating Paramater Queries
∎ Creating Calculated Fields
∎ Joining Tables
∎ Designing Forms
∎ Creating Data Entry Forms
∎ Working with Subforms
∎ Working with Switchboards
∎ Designing Reports
∎ Editing Reports
Classroom Training - Scheduled Dates and Booking
∎ Due to Current Covid-19 restrictions we have postponed all classroom-based training courses.
∎ We will reschedule Access training courses as soon as it is practical to resume in-class training.
∎ In the meantime we offer the same Access courses on a Live Virtual Training basis.
∎ Please see below for scheduled dates and information.
Live Virtual Training Bookings
Dates, Fees & Group Discounts
July
Wednesday 21st – Thursday 22nd
9.15 am to 12.45 pm
Full training pack included for each attendee
Training Pack includes:
Access Course Manual
Course Practice Files
Video Recordings of Course
Training Certificate Upon Completion
(prices discounted for larger groups)
August
Monday 9th – Tuesday 10th
9.15 am to 12.45 pm
Full training pack included for each attendee
Training Pack includes:
Access Course Manual
Course Practice Files
Video Recordings of Course
Training Certificate Upon Completion
(prices discounted for larger groups)
September
Wednesday 15th – Thursday 16th
9.15 am to 12.45 pm
Full training pack included for each attendee
Training Pack includes:
Access Course Manual
Course Practice Files
Video Recordings of Course
Training Certificate Upon Completion
(prices discounted for larger groups)
Why Progressive Training
Live On Demand Virtual Training
Experienced Professional Trainers
Customised Training Solutions for business
Free 12 Months Support
Major Discounts for Group Bookings
The training exceeded our expectations. The way that John interacted and engaged with our colleagues meant that they received a lot from the course. Thank you for ensuring the training was delivered so professionally.
Anne Kelly – Irish Windows
From the First point of contact we found Progressive Training to be very helpful in assessing our training needs and delivering a range of Excel training courses to meet our staff needs.
Paul Wilson – HR manager, Gourmet Ireland