Microsoft Access Training Courses

Microsoft Access Introduction Course

A comprehensive 2-day Microsoft Access training course suitable for complete beginners to Microsoft Access. After the training you will able to create a database from scratch. You will understand and be able to build tables, fields and records, set the rules for entering data and create forms for input.

Also, you'll learn how to extract information in the form of simple queries and reports and export to Excel, PDF and mail merge. Our course also covers database design - essential knowledge when learning to build databases and understanding how they work.

Read More

Microsoft Access Introduction training course outline Two Day Course

Getting Started and Table Design
Create a new database
Overview of the Microsoft Access Environment
Create new tables
Set field names
Choose data types
Consider and set field properties
Create a drop down list

Understanding Relationships
Create One to Many Relationships
Create One to One Relationships
Change Relationship Properties
Understand Referential Integrity

Work with Forms
Create a standard Form
Create a Form using the Wizard
Re-design a Form
Create a Form with a sub-form
Input data using Forms

Work with Queries
Create and save standard Queries
Sort data within a Query
Set criteria for Queries
Concatenate data within a Query
Create calculations in a Query
Use Parameter Query

Work with Reports
Create a report from Table data
Create a report from Query data
Group Information in a Report
Re-design Report elements
Create Mailing Labels

Export data from Microsoft Access
Export information to Microsoft Excel
Export information to Microsoft Word
Export information to a PDF file
Use the Mail Merge feature

Training Dates

28th & 29th September 2017

23rd & 24th November 2017

Please call for further dates

Price

£345

Venue

Minstead Lodge, New Forest Venue Information

Download Course Details

Book this course

Microsoft Access Intermediate Course

A full day designed for those users who wish to step up their current knowledge of Microsoft Access to take advantage of the more complex features.  
Learn to build a database application in a multi-user environment. Create advanced queries and reporting, working with interaction between Microsoft Access objects. Understand the power of macros for automation on this in-depth one day training course.

Read More

Microsoft Access Intermediate training course outline One Day Course

Design a Database
Understand and perform Normalisation
Create a new database
Understand relationship types
Know how to resolve a many to many relationship

Import Data
Import data from Excel
Import data from a text file
Analyse imported data

Create an Interface
Create navigation forms
Use command buttons
Display a form at database start up

Work with Forms
Insert Sub-Forms
Create Combo-boxes
Work with Attachment data types

Work with Queries and Reports
Create Action Queries
Use Functions in Queries
Supply parameters to a form from a Query
Use the Expression Builder
Change Query Joins Types
Create Crosstab Queries
Create Total Queries
Build reports and summarise data

Manage a Database
Back up a Database
Compact and Repair a Database
Password protect a database

Training Dates

4th October 2017

6th December 2017

Price

£185

Venue

Minstead Lodge, New Forest Venue Information

Download Course Details

Book this course

Microsoft Access Advanced Course

You have built databases to store and retrieve data. Now you may want to plan, design and administer your own database as a working system. A well-designed database allows easy maintenance and quick access of data. In this course, you will plan, design, create and administer a functional and efficient relational database which includes taking bookings, generating invoices and producing reports.

This course is suitable for those who have either attended our Microsoft Access Intermediate level training course or have a sound knowledge of database design and Microsoft Access.

Read More

Microsoft Access Advanced training course outline One Day Course

Design a Database
Perform Normalisation of data
Create a new database
Set relationships
Import data

Work with Forms
Create a Combo Box Control
Create a List Box Control
Create an Option Group Control
Create a Tabbed Control and manage elements
Insert sub-forms
Identify and understand Form Properties

Create Documents from a system
Work with reports
Use unbound controls
Use bound controls
Write functions
Create Macros to manage behaviour
Use Macros to provide system messages
Assign Macros to events

Work with Queries
Use Date Functions
Use Queries to generate data for Forms

Database Management and Security
Set a database password
Discuss database security
Set Start-up options
Save a database as ACCDE

Training Dates

Please call us for dates

Price

£195

Venue

Minstead Lodge, New Forest Venue Information

Download Course Details

Book this course