Microsoft Training Courses - London & the UK's Premier MS Office Training Provider

MS Access Training

MS Excel Training

MS Word Training

MS PowerPoint Training

MS Project Training

MS Visio Training

Visio Introduction

MS Outlook Training

Outlook Introduction

Microsoft Access Introduction Training Courses in London and UK wide

With our MS Access Introduction or Beginners training course, you will be provided with the required skills to create a new database from scratch or understand the build of an existing database better. The Access intro training course is designed for new users of MS Access, or existing users who need to fill in knowledge gaps. Our Access beginners course can take place at a date and time that suits you, rather than a schedule of dates that you cannot attend.

All our Access trainers are MOS Master Instructors, which means you will get a trainer that really knows Access inside out to ensure you get the most from your MS Access course.

Your course can take place in London at our training suites, or on-site at your office. We can even provide all the equipment if you do not have a dedicated training room or equipment.

Below is our course contents for the Access Introduction or Beginners course. If you have any questions regarding our training courses or to make a booking, please contact us

MS Access Introduction Training Course Information

The duration of this course is 2 Days. Training usually starts at 09:30 and lasts until 16:30 - 17:00. You will receive a Training Manual CD, course exercises and after course support all included in the cost. We offer fantastic refreshment throughout the day, like hot drinks, snacks and a selection of bottled water and soft drinks

Select the Contact Me Now!!! button below to have a member of our team contact you regarding this course, or contact us

Contact Me Now!!!

MS Access Introduction Training Course Contents

Access Introduction Training Course Contents

Course Objectives -To understand the concept and purpose of a database and to gain a good working knowledge of Access to be able to create and edit Access databases.

Screen Layout

Navigating Microsoft Access

Access Overview

Database Container
Tables
Queries
Forms
Reports
Macros
Pages
Modules
Grouping Favourites

Planning a Database

Designing a Database
Normalisation
Relational Databases

Creating Tables

Create a Database
Designing a Table
Rules for entering Field Names
Enter data types, field descriptions
Setting a Primary Key
Setting Multiple Primary Keys
Removing a Primary Key

Table Properties and Structure

Defining Field Properties
Working with Input masks
The Input Mask Wizard
Validation Rule
Validation text
Other field Properties
Insert fields
Delete fields
Move Fields
Rename Fields
Table Wizards

Entering and Editing Data

Switching Views in Access
Enter data into a table
Modify data in a table
Working in Data Entry Mode
Sorting Data
Finding & Replacing Data
Hiding and Unhiding Fields

Importing and linking data

Importing from Access and Excel
Linking to an external Access Database Table
Linking to an Excel Workbook using the Wizard
Renaming and Copying Tables

Using Filters and Select Queries

Create a filter by selection
Create a filter by form
Save a filter by form as a select query
Running a Select Query
The Query Design Window
Creating a query from the query window
Adding fields to a query
Display/Suppress the display of a field
Removing fields from a query
Specifying Text, numeric, date, and logic criteria
Specifying sub string searches using wild Card Characters

Working with multiple criteria
Working with Conditions - BETWEEN, AND, OR, NOT, NULL
Calculated fields
Simple Query Wizard
Removing fields from a query
Specifying Text, numeric, date, and logic criteria
Specifying sub string searches using wild Card Characters
Working with multiple criteria
Working with Conditions - BETWEEN, AND, OR, NOT, NULL
Calculated fields
Simple Query Wizard

Relationships

Why create relationships between tables?
Different types of relationships
Conditions for setting up a relationship
Referential Integrity
Cascade Update
Cascade Delete
Relationships Report
Inserting Subdatasheets
Removing Subdatasheets
Expanding and Contracting Subdatasheets

Multi-Table Queries

Multiple Table Queries
Joining Tables for a query
Join Properties - Inner and Outer Joins
Find Unmatched Query Wizard
Find Duplicates Query Wizard

Creating Forms

Creating Forms using the Auto Form Tabular/Datasheet/Pivot Form wizard
Creating Forms Using the Form Wizard
Data Entry in Forms
Resizing and Moving Controls
Changing Text Attributes

Form Layout and Formatting

Resizing Forms
The Field List Box
Selecting Controls
Formatting Controls
Format Painter and AutoFormat
Resizing and Moving Controls
Properties of an item

Creating Reports

Standard Reports using Wizard
Inserting, Moving, Sizing, deleting controls
Customising Reports
Grouping Data
Using Expressions
Mailing Labels
Page setup

Course Costs

1 to 1 Training

1 to 1 training is charged at £450 per day.This means you will have the best training possible and only focus on topics you will use and actually benifit from. Read more about the benifits of 1 to 1 training here

All our courses are closed to you.

Groups of 2-8

If you need to have more than 1 person trained, then our group pricing cannot be beaten.

For 2 Delegates = £475 per day. That's less than £200 per day per delegate

For 3 Delegates = £495 per day. Thats less than £170 per day per delegate

For 4 Delegates = £595 per day. Thats less than £150 per day per delegate

For 5 to 8 delegates = £695 per day. That could be as little as £90 per day per delegate.

All prices are excluding VAT

All our courses are closed to you and your company.

How to book

Simply call us on 020 7920 9500
or
Email Us
or
use our Contact Us form

We will then confirm the course and dates with you and send joining instructions

Thats it.

Remember that you do not pay until your course has run. This ensures that you are 100% satisfied with your course. If not, we run it free or you simply do not pay.