Access

Microsoft Access Training Courses

We're experts in delivering Eureka moments with Microsoft Access

Microsoft Access
Training Courses

We're experts in delivering Eureka moments with Microsoft Office

Microsoft Access Training Courses

We're experts in delivering Eureka moments with Microsoft Access

Our Access workshops cater for new users, right through to those wanting to develop custom solutions using Access VBA. Select from our range of standard workshops, or work with one of our experts to build a course, focused on your specific requirements. Our team bring the training to you, delivering the workshops at your site, helping you focus on what’s important to you.

Courses on Access 2010 and 2013 are also available.

Microsoft Access Training Options - Day Courses

Click on an option below, or scroll down to see more information.

Microsoft Access 2016: Introduction

Duration: One day (9:30 - 16:30)

This one-day introductory course is ideal for anyone who is new to Access and needs to learn about working with data tables, fields and queries. The Introduction course will teach you how to:

Apply the principles of database design when you create and maintain a database in Access
Manage Access database files
Create, maintain, use and customise tables and fields
Manipulate text in a table
Establish and manage relationships between tables
Perform searches, search-and-replace operations and sorts
Create and apply a filter
Create and execute queries

Prerequisites: A working knowledge of another Microsoft application, such as Excel is beneficial but not mandatory.

Course Content

Introducing Microsoft Access

Understanding databases
Starting Microsoft Access
Open and close a database
Create a new database
Set tabbed documents view

Work with tables

Design database tables
Create a new table
Add records to a table
Open a table
Edit records in a table
Print a table

Manage tables and fields

Switch between views
Change field properties
Add & remove primary keys

Managing data in tables

Move around the datasheet
Copy & move information
Find data in tables
Delete records
Sort records
Index fields
Create calculations in tables
Work with filters

Manage table relationships

Understand table relationships
Create table relationships
Edit existing table relationships
Delete table relationships
Understand referential integrity
Multi-table datasheet view
Use the Table Analyzer

Work with queries

Understand queries
Create a query
Specify a sort order and criteria
Exclude fields
View the Dynaset
Change queries
Save queries
Query multiple tables

Work with query expressions

Query records with wildcard characters
Query a range of records
Specify multiple criteria
Create calculated fields
Format fields in a query
Create summary & top ten queries
Work with parameter queries

To find out more about this course, or to make a booking, please call us on 0118 9789 279 or click here to email us.

Enquire Now

Microsoft Access 2016: Intermediate

Duration: One day (9:30 - 16:30)

This one-day comprehensive course covers working with and customising forms and reports, and creating sub forms. The Intermediate course will enable you to:

Use the Form Wizard to create a form
Resize, move, copy, align and delete controls
Edit and delete records
Add controls to forms and reports
Insert a subform into a main form
Create a Split Form
Create mailing labels report
Create groups/totals, summary, and tabular reports
Merge Access data with a Microsoft Word document

Prerequisites: Attendees should have completed the Access Introductory course or have the equivalent working knowledge.

Course Content

Create forms

Overview of different types of forms
Create a form by using the form tool
Create a form by using the blank form tool
Create a form by using the Form Wizard
Create a split form

Work with forms

Navigate around a form
Enter & edit records in a form
Delete records in a form
Save & close a form
Understand form views

Customise forms

Understand form controls
Move, size, separate, delete & align controls
The property sheet
Add sections to a form
The toolbox tools
Work with the label controls
Create a bound text box control
Create an unbound text box control
Understand expressions
Create a calculation control
Combine text from multiple fields
Format the controls within a form
Create a combo box and/or list box
Adjust a list or combo box settings
Control the tab order
Invoke the query builder on a form

Create subforms

Use a Wizard
From scratch
Use the subform tool

Create reports

Create a report using the Report Wizard
Save a report
Create a groups/totals report
Create a summary report
Create mailing labels

Customising reports

Understand report controls
Customise the appearance of a report
Control report pagination
Add page numbers & current date to a report
Add lines, rectangles & graphics to a report

Using mail merge

Perform a Mail Merge using Access data with a Microsoft Word document

To find out more about this course, or to make a booking, please call us on 0118 9789 279 or click here to email us.

Enquire Now

Microsoft Access 2016: Advanced

Duration: Two days (9:30 - 16:30)

This two-day, advanced course is ideal if you are looking to extend your existing knowledge of Access.

You will learn how to:

Use Query Wizards to create crosstab queries, find duplicate records and find unrelated records
Create AutoLookup, outer join, advanced parameter, and action queries
Manage database objects
Link and embed objects from other applications
Import information into Access and export database tables
Automate Access tasks with Expression Builder and macros
Use conditional macros and event properties

Prerequisites:To get the most from this course you will have attended the Introduction and Intermediate workshops, or have the equivalent working knowledge.

Course Content

Review - select queries

Summary queries
Top 10 queries
Calculation queries

Query wizards

Create a crosstab query
Find duplicate records
Find unmatched records

Action queries

Create a new table
Update, add or delete records

Specialised queries

Summary
Autolookup
Outer join
Parameter
Advanced parameter queries

Manage database objects & files

Copy & rename database objects
Compact & repair databases
Encrypt & decrypt databases
Set a database password
Convert databases
View information on object dependencies
Use the analyse options

Link data

Attach a table to a database
Link & embed in access databases

Import & export files

Import data, spreadsheets & text files
Export data
Export to Microsoft applications

Automate tasks

Work with the Expression Builder
Create & execute a macro
Debug a macro
Manipulate data with macros
Automate data transfers
Create macro groups
Execute macros in the macro group
Assign a macro to a button on a form
Assign a macro to the quick access toolbar
Assign a macro to a key
Create a front-end user interface
Customise start-up options

Conditional macros & event properties

Use conditional macros
Work with event properties
Assign a macro to an event property

To find out more about this course, or to make a booking, please call us on 0118 9789 279 or click here to email us.

Enquire Now

Microsoft Access: Visual Basic for Applications (VBA) - Introduction

Duration: Two days (9:30 - 16:30)

This comprehensive two-day course will benefit anyone who is already confident building Access databases and wants to learn how to automate manual procedures using Visual Basic for Applications (VBA). Even if you’ve never programmed before, our Microsoft Office Access VBA workshop will help you learn how to leverage the power of VBA to make your work with Access more efficient than ever before.

Prerequisites: To benefit from this course, you should already have attended the Introduction, Intermediate and Advanced workshops, or have the equivalent working knowledge.

Course Content

Getting Started

Introduction to Access programming
Understanding the development environment
Using VBA help

Developing with Procedures & Functions

Understanding and creating modules
Defining procedures
Creating a sub-procedure
Calling procedures
Utilising the immediate window to call procedures
Making and naming a function procedure
Working using the code editor

Understanding Objects

Understanding classes and objects
Navigating the Access object hierarchy
Understanding collections
Using the Object Browser
Working with the Application Object
Understanding the Form Object
Working with Properties
Using the With Statement
Working with Methods
Understanding the DoCmd Object
Working with Events
Understanding the order of events

Utilising Intrinsic Functions, Variables and Expressions

Defining expressions and statements
How to declare variables
Determining data types
Programming with variable scope
Harnessing intrinsic functions
Defining constants and using intrinsic constants
Adding message boxes and using input boxes
How to declare and use object variables

Controlling Program Execution

Understanding control-of-flow structures
Working with Boolean expressions
Using the if...end if decision structures
Using the select case...end select structure
Using the for...next structure
Using the for each...next structure
Using the do...loop structure
Guidelines for use of branching structures

Working with Recordsets

Declaring and creating object variables
Working with the ADODB Recordset object
Specifying a Recordset cursor type
Locking records for updating
Specifying a Recordset cursor location - optional
Using the cache size property - optional
Understanding Recordset cursor properties - optional

Debugging the Code

Defining errors
Working with debugging tools
Determining breakpoints
How to step through code
Working with break mode during run mode
Identifying the value of expressions

Handling Errors

Understanding error handling
Understanding VBA's error trapping options
Trapping errors with the on-error statement
Understanding the error object
Writing an error handling routine
Working with inline error handling

To find out more about this course, or to make a booking, please call us on 0118 9789 279 or click here to email us.

Enquire Now

Need 1-2-1 support?

We offer face-to-face and virtual sessions, tailored to your specific needs and designed to: build confidence; help you work more effectively and understand what to do next. Find out more.

DOWNLOAD OUR BROCHURE

We're delighted to announce that our brochure, covering our core services - IT Training, Consultancy & Personal Development - is now available for download.

Click below to request a copy:

Download Brochure

Bookings & Further Information

To find out more or book a Microsoft Access training course, call our team now on 01189 789 279 or complete this form: