Etopia Computer Training

Training Room Hire

Our Glasgow training room facilities are available for hire.

Microsoft Access Intermediate IT Training Course

Duration:1 day
Price:£200.00
Locations:Glasgow, Edinburgh
Glasgow Dates:Wed 22nd Nov 17,  Mon 18th Dec 17,  Wed 17th Jan 18,  Mon 26th Feb 18,  Mon 26th Mar 18
Edinburgh Dates:

This course shows attendees how to improve upon their existing level of Microsoft Access skills. This training teaches delegates to work in an an organised way with tables, share records with other applications and understand queries and relationship types. 

Course Aims to enable delegates to:

Learn to create advanced queries, create more efficient forms and reports, and work with macros.

 Course Content 

Tables

Revision - Creating a Table

Table Properties

Queries

Action Queries

Parameter Queries

Calculated Fields

Joins

Sharing Records with other Applications

Import

Export

Link data to and from other applications

Relationships

Relationship Window

Understanding the different types

Linking Tables

Joins

Forms

SubForms

Combo Boxes

Command Buttons

Headers and Footers

Tab Order

Pictures

Properties

Reports

Designing

Formatting

Group and Sorting

Adding Different Controls

Follow-on Courses

Microsoft Access Advanced  

Requirements before booking this course:

Delegates enrolling in this course should understand table design and table relationships, and how to create basic queries, forms, and reports. All delegates attending this training must have attended and Access Foundation course or have equivalent knowledge

Notes

Training is available on all versions