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

 

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

April

Thursday 15th – Friday 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)

May

Monday 17th – Tuesday 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)

June

Thursday 10th – Friday 11th

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

Z

Live On Demand Virtual Training

Z

Experienced Professional Trainers

Z

Customised Training Solutions for business

Z

Free 12 Months Support

Z

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

 

Make an Enquiry

9 + 14 =