IT Computer Training Courses Edinburgh, Glasgow, Scotland: Microsoft Access Level 2 Computer Training: iTrain Scotland: Microsoft Office 2016 Training, Adobe Training, Windows 10 training, Office 2013 training, Computer Courses, Computer training room equipment hire

In-Person Classroom
Or
On-Line Classroom

1 Day

Training Options:

Edinburgh Training Centre
or
Live Online Classroom

Onsite anywhere in UK

Company course

Tailored content

In-Person Classroom
Or
On-Line Classroom

1 Day

Public Schedule

Onsite anywhere in UK

Company course

Tailored content

Edinburgh Training Centre
or
Live Online Classroom

Onsite anywhere in UK

Company course

Tailored content

Microsoft Access Level 2

Suitable for versions 2016 / 2013 / 2010

This course will vastly increase your current understanding of Access. Existing users will learn how to get the most out of Access, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our expert Access trainers.

Course content

Prerequisites

This course is aimed at those who have a good understanding of Access at a Foundation level.

Delegates should already be able to:

Design a simple database from scratch
Create and understand table relationships
Create filters and queries
Use expressions in the Query Designer

Course goals

Delegates will learn advanced query design, automation, forms, switchboards and sharing. Delegates will also learn shortcuts and tips about how to use Access in the most efficient way.

Topics

Advanced Table Design

Field properties
Input masks
Captions
Validation rules
Field size
Formats
Lookups

Advanced Queries

Review of basic queries
Action Query
Parameter Query
Crosstab Query
Ad hoc Joins
Calculated Fields

Develop Relationship concepts

Referential Integrity
One-to-One
One-to-Many
Many-to-Many
Query Multiple Tables
Create Junction Tables

Customising Reports

Format Reports
Control Report Pagination
Summarise Report Information
Add a Subreport to an Existing Report
Create a Mailing Label Report

Sharing Data Across Applications

Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge
Linking tables

Splitting a Database

Creating front end / back end
Sharing across a network
Multiple users

Advanced Form

Sub Forms
Lookup Query in a form
Creating a welcome screen
Switchboards
Form navigation
Adding macros
Command buttons
Adding images
Using VBA code in buttons
Combo boxes
Calculated fields
Jump-to combo box
Event Procedures
Control Source

Prices

Prices below are for scheduled courses held in our Edinburgh Training Centre or Live Online Classroom with Tutor. Major discounts available for onsite or private courses: click General Enquiry button below to enquire about private courses.

Group discount

1 place £ 205 n/a

2 places £ 410 n/a

3 places £ 615 £ 565

4 places £ 820 £ 665

5 places £ 1025 £ 765

6 places £ 1230 £ 865

7 places £ 1435 £ 965

8 places £ 1640 £ 1065

		Group discount
1 place	£ 205	n/a
2 places	£ 410	n/a
3 places	£ 615	£ 565
4 places	£ 820	£ 665
5 places	£ 1025	£ 765
6 places	£ 1230	£ 865
7 places	£ 1435	£ 965
8 places	£ 1640	£ 1065