Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger sub menu
More
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Access Training Courses: All Versions & Skill Levels
Access Training Courses: All Versions & Skill Levels
Search

ACCESS TRAINING COURSES

Microsoft Access Training

Training for Access 2007 to 2016 delivered in 11 UK locations or at your offices UK-wide
See Our Latest Reviews on TrustPilot:
Versions Covered
Our courses cover 2007, 2010, 2013 and 2016 versions
Get to Grips With the Power of Access Databases

Microsoft Access is flexible, powerful, and easy to use -- if you understand how it works. The difference it can make to the use and presentation of relatively complex sets of data can be quite astonishing.

Some of the screens can often resemble those in Microsoft Excel, but the ability to link data sets to create reports, forms and query results is on a different level altogether.

Our Microsoft Access training courses take you through from the basics -- it's often a good idea to attend the Introduction and Intermediate classes on successive days to secure a solid foundation -- to high-performance, automated applications using SQL commands, macros and Visual Basic.

We have scheduled public (open) classes running at all our UK centres, or can run a private (closed) class for you at your offices, all at excellent prices. So when would you like to start?

How Would You Like to Learn Microsoft Access?
Classroom training Classroom training

Classroom training is proven to give the best learning experience and knowledge retention. You have the benefit of a relaxed but professional learning environment, an experienced trainer and the opportunity to ask questions, so you are 100% sure you understand all the course content.

Click for more about classroom training

E-learning NEW! E-learning

If your budget, and/or time available, are limited, you can now choose the e-learning route: at lower cost, and with the flexibility to study in your own time, at your own pace. The course content is exactly the same as we cover in the classroom, so you are still getting tried and tested Activia courses.

Click for more about e-learning

Move to next Microsoft Access section
Quick Links to Information

REQUEST MORE INFORMATION

PRICES for training

BOOK a public class date

Microsoft Software page

More on This Page
COURSE OUTLINES & LINKS FOR
MICROSOFT ACCESS TRAINING
Browse the outlines and click for more details on each course

Access Introduction

Access Introduction

COURSE OUTLINE
[Duration: one day]

  • Getting Started with Access
  • The New Ribbon Interface
  • Creating a Simple Database
  • Forms; Queries; Reports and Filters

Click for FULL COURSE DETAILS

Access Intermediate

Access Intermediate

COURSE OUTLINE
[Duration: one day]

  • Advanced File Tasks
  • Working with Tables
  • Working with Forms
  • Working with Reports
  • Working with Queries

Click for FULL COURSE DETAILS

Access Advanced

Access Advanced

COURSE OUTLINE
[Duration: one day]

  • Advanced Data Management
  • Advanced Form Tasks
  • Automating Reports
  • SQL and Microsoft Access
  • Macros and Visual Basic for Applications (VBA)
  • Finishing the Application

Click for FULL COURSE DETAILS
Move to next Microsoft Access section
CLASSROOM TRAINING FOR
MICROSOFT ACCESS
Do you want the best? Here's how to get it!
Classroom training for MICROSOFT ACCESS
Classroom training provides the best learning experience and knowledge retention, and is the preferred choice if you want to really get to grips with the subject.
Our class sizes are always small, allowing lots of time for questions and discussion, so you come away with a full grasp of the content, ready to use it right away.
Options for Classroom Training
Scheduled Public Classes

Best for: 1 - 4 delegates

With 11 centres across the UK, we always have a full schedule of great courses at super prices.
And we don't cancel classes – even if you are the only delegate booked on the course!

Price Guide
  • Prices for public classes start at £229
  • Early Bird discounts can reduce the price to £169
  • For multiple delegates, prices can be as low as £80

If you don't see a course at the location, or on the date, you want, it is often possible to take advantage of our unique "Schedule Your Own" feature which is available from £229.

Free E-Learning Revision
Every attendee on a public class also gets access to 12 months free e-learning where you can review and revise the course content.

Book Online
It couldn't be easier with our full listings of classes and dates: just click here and reserve your place in two minutes.

Training at Your Offices

Best for: 3 or more delegates

A great option that's cost effective and easy to organise: just set up the training room and we come to you to deliver the content you want on the day you choose.

Price Guide
Prices for training at your offices starts at £479

Private Training at Our Centres

Best for: 3 or more delegates

If you want training away from your offices (and possible distractions), we can arrange a day at one of our centres with only your staff in attendance.

Price Guide
Prices for private Microsoft Access training at our centres varies, but generally starts at £529

Call us on 0333 6000 111 or request a callback so we can discuss your needs.

Move to next Microsoft Access section
E-LEARNING MADE EASY FOR
MICROSOFT ACCESS
Get Learning in Five Minutes!

Do you need to improve your Microsoft Access skills, but just don't have time?

Maybe you're busy at your job and can't spare a day out of the office for yourself or your team, or perhaps you're self-employed and juggling work with the school run.

If this is the case, online training is a great solution. Our Microsoft Access online courses will enable you (and/or your team) to learn at your own pace, at the time and place you choose.

E-learning options for MICROSOFT ACCESS
Standard e-learning pack
A1 MULTI-PACK - Standard e-learning pack
Videos with transcripts and tests to earn your diploma
Enhanced pack with downloads
A2 MULTI-PACK - Enhanced pack with downloads
Standard pack PLUS downloadable workbook & exercises
E-Learning Packs

Buy now and start your learning in five minutes!

Save money with our e-learning package bundles!
You have chosen to add the following pack to your cart at a cost of £:
.
You may like to know that this course also comes bundled in the Multi-Packs below which, and as you'd expect, allows you to buy several courses at a substantial discount to the standard prices.

Full Access Multi-Pack: Includes Intro, Intermediate & Advanced courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £49 (SAVE £26)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £75 (SAVE £30)

MS Office Plus Multi-Pack: Includes all Excel, Word, Powerpoint, Outlook & Access courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £119 (SAVE £146)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £165 (SAVE £230)

  • No thank you, just add the single-course pack to my shopping cart

Access Introduction
Course Outline


MODULE 1: Getting Started with Access
Understand how to start Microsoft Access and some of its basic navigation and help controls.

This module contains:

  • Starting Out
  • Interface Basics
  • Database Security
  • Getting Help

MODULE 2: The New Ribbon Interface
Exploring the Ribbon's different tabs and options.

This module contains:

  • The Quick Access Toolbar
  • Basics of Tabs
  • The Home Tab
  • The Create Tab
  • The External Data Tab
  • The Database Tools Tab

MODULE 3: Creating a Simple Database
Creating basic tables and a look at the different types of fields available.

This module contains:

  • First Steps in Database Creation
  • Database Records
  • Creating a Table
  • Formatting Text

MODULE 4: Forms; Queries; Reports and Filters
Creating basic forms, queries, reports and filters; essential to the successful creation and administration of an Access Database.

This module contains:

  • Creating and Using Forms
  • Creating and Using Queries
  • Creating and Using Reports
  • Sorting and Filtering Data
  • Viewing Data
  • Printing a Database Object

Access Introduction   
[Click for course outline]
E-learning A1 Pack
A1 PACK - £25
Click to BUY
E-learning A2 Pack
A2 PACK - £35
Click to BUY
Save money with our e-learning package bundles!
You have chosen to add the following pack to your cart at a cost of £:
.
You may like to know that this course also comes bundled in the Multi-Packs below which, and as you'd expect, allows you to buy several courses at a substantial discount to the standard prices.

Full Access Multi-Pack: Includes Intro, Intermediate & Advanced courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £49 (SAVE £26)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £75 (SAVE £30)

MS Office Plus Multi-Pack: Includes all Excel, Word, Powerpoint, Outlook & Access courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £119 (SAVE £146)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £165 (SAVE £230)

  • No thank you, just add the single-course pack to my shopping cart

Access Intermediate
Course Outline


MODULE 1: Advanced File Tasks
A look at some important administrative features necessary for managing an Access Database file.

This module contains:

  • Using Windows Explorer within Access
  • Database Management
  • Saving Your Files
  • Exporting Files
  • Linking Files

MODULE 2: Working with Tables
Further developing an understanding of tables, looking deeper into a table's properties fine tuning data types and use data validation.

This module contains:

  • Customising Tables
  • Table Properties: Formatting
  • More Table Properties
  • Data Validation and Lookup Wizard

MODULE 3: Working with Forms
Building professional forms to enhance the user experience and improve effective use.

This module contains:

  • Basic Form Controls
  • Advanced Form Controls
  • Formatting Your Form
  • Formatting Controls
  • Using Themes

MODULE 4: Working with Reports
Organise and format your reports professionally and common report tasks you may need to perform.

This module contains:

  • Organizing Report Data
  • Formatting Reports
  • Common Report Tasks

MODULE 5: Working with Queries
Creating a range of different queries from very basic queries through to management queries with advanced functionality.

This module contains:

  • Basic Queries
  • Doing More with Queries
  • Creating Advanced Queries
  • Creating Management (Action) Queries

Access Intermediate   
[Click for course outline]
E-learning A1 Pack
A1 PACK - £25
Click to BUY
E-learning A2 Pack
A2 PACK - £35
Click to BUY
Save money with our e-learning package bundles!
You have chosen to add the following pack to your cart at a cost of £:
.
You may like to know that this course also comes bundled in the Multi-Packs below which, and as you'd expect, allows you to buy several courses at a substantial discount to the standard prices.

Full Access Multi-Pack: Includes Intro, Intermediate & Advanced courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £49 (SAVE £26)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £75 (SAVE £30)

MS Office Plus Multi-Pack: Includes all Excel, Word, Powerpoint, Outlook & Access courses
Choose your preference:
  • Add to cart - D1 MULTI-PACK: Standard e-learning multi-pack - £119 (SAVE £146)
  • Add to cart - D2 MULTI-PACK: Enhanced multi-pack with downloads - £165 (SAVE £230)

  • No thank you, just add the single-course pack to my shopping cart

Access Advanced
Course Outline


MODULE 1: Advanced Data Management
A look into table relationships and referential integrity along with introducing SQL, the language database professionals use to manage a database.

This module contains:

  • Referential Integrity
  • Table Relationships
  • An Introduction to SQL
  • Modal Dialog Boxes

MODULE 2: Advanced Form Tasks
Creating navigation forms and sub-forms along with some of the advanced form controls necessary to create a fully rounded user interface.

This module contains:

  • Using Subforms
  • Creating a Navigation Form
  • Advanced Form Controls
  • Exporting a Form
  • Other Form Tasks

MODULE 3: Automating Reports
Create Reports in Access that can return data quickly by using a form to control and launch reports. Look at modifying form properties including combo boxes and link a query to a form.

This module contains:

  • Creating the Report Form
  • Building Query Criteria

MODULE 4: SQL and Microsoft Access
Some of the basic and more advanced SQL commands here along with the concept of JOINS and sub-queries.

This module contains:

  • Understanding SQL
  • Using the SELECT Statement
  • Using Subqueries
  • Using SQL Joins

MODULE 5: Macros and Visual Basic for Applications (VBA)
Using Macros and Visual Basic to create some advanced functionality to your Access Database.

This module contains:

  • Macro Basics
  • More about Macros
  • Access and VBA
  • Building Advanced Procedures
  • Using VBA in a Database

MODULE 6: Finishing the Application
Look at finishing touches to control how users interact with a database using start-up and sharing options. Identify security measures by creating an ACCDE and encrypting a database with a password.

This module contains:

  • Setting Start Up Options
  • Sharing/Splitting the Database
  • Creating an ACCDE
  • Encrypting the Database with a Password

Access Advanced   
[Click for course outline]
E-learning A1 Pack
A1 PACK - £25
Click to BUY
E-learning A2 Pack
A2 PACK - £35
Click to BUY
Save money with our e-learning Multi-Packs
Full Access Multi-Pack

Includes Intro, Intermediate & Advanced courses

E-learning revision
D1 MULTI-PACK: £49
(Save £26)

Click to BUY
E-learning revision
D2 MULTI-PACK: £75
(Save £30)

Click to BUY


MS Office Plus Multi-Pack

Includes all Excel, Word, Powerpoint, Outlook & Access courses

E-learning revision
D1 MULTI-PACK: £119
(Save £146)

Click to BUY
E-learning revision
D2 MULTI-PACK: £165
(Save £230)

Click to BUY


Call us on 0333 6000 111 or request a callback so we can discuss your needs.

NOTES
Licenses for e-learning allow up to 40 sessions for each module on one PC in any 12-month period.
But once purchased and accessed, no refund can be given.
Due to screen resolution requirements, they are not suitable for mobile devices.
Downloaded documents are the copyright of Activia Ltd and are for the use of the individual license holder only: further distribution is expressly forbidden.

TRY BEFORE YOU BUY
Our free Microsoft Access Mini-Course allows you to see how easy and flexible our e-learning is:  click here to find out more.

Move to next Microsoft Access section
DELEGATE FEEDBACK
FOR OUR MICROSOFT ACCESS COURSES
AVERAGE REVIEW: 4.6 out of 5  BASED ON 172 REVIEWS
Sarah Bees, Course: Feb 27 2017
Course rating of 5 stars "I really enjoyed the course and felt like I learned a lot!"

 
Sarah Bees , Course: Feb 27 2017
Course rating of 5 stars "The trainer was very clear, knowledgeable, friendly and patient!"

 
Beverley Dean, Course: Access Intermediate Feb 21 2017
Course rating of 4 stars "Thank you for all your help with this training, it has been successful and will help me in many ways to progress my database. Thanks to Steve, the teacher from Activia. "

 
John Routley , Course: Access Intermediate Feb 14 2017
Course rating of 5 stars "Our course tutor Tracey was excellent and once she knew our requirements she tailored the course to suit both our needs and our knowledge of Access."

 
Charles Barker , Course: Access Introduction Feb 1 2017
Course rating of 5 stars "Gareth was a great teacher and really made the effort to meet the requirements of the pupils, as well as being very friendly and approachable."

 
Jade Tracey, Course: Access Intermediate Jan 17 2017
Course rating of 4 stars "The facilitator is brilliant."

 
Leti Hawthorn, Course: Access Introduction Jan 11 2017
Course rating of 5 stars "Many thanks for a perfectly tailored course. Steve took into account our backgrounds and individual needs and we got through a huge amount of material through the day. Highly recommended!"

 
Graham Ferris, Course: Access Introduction Jan 5 2017
Course rating of 5 stars "You should warn vegetarians to bring their own lunch as I was offered a chicken or ham sandwich. But that was infinitely better than the following day on the intermediate course when there was no lunch provided for either the trainer or me - very poor: had to buy my own."

 
Denella Welds, Course: Access Introduction Nov 30 2016
Course rating of 4 stars "Excellent trainer. Good energy. Kept course going at a good pace. Good class size of 6."

 
Kay Blischke , Course: Access Intermediate Nov 15 2016
Course rating of 4 stars "Great to get a one on one experience."

 
Naomi Crewe, Course: Access Introduction Nov 2 2016
Course rating of 5 stars "Gareth was a really good trainer"

 
Siyana Dimova , Course: Access Introduction Oct 19 2016
Course rating of 5 stars "Great course and instructor!"

 
Stuart Brown , Course: Access Introduction Oct 19 2016
Course rating of 5 stars "Very good trainer"

 
Aqib Afzal , Course: Access Introduction Oct 19 2016
Course rating of 5 stars "the trainer was really informative "

 
Steve Downing , Course: Access Introduction Oct 12 2016
Course rating of 5 stars "The trainer, Chris, was very engaging and entertaining, and as such, kept attention and energy throughout the day."

 
Move to next Microsoft Access section
FREE TOOLS & RESOURCES
FOR MICROSOFT ACCESS
Resources to make your training easier to organise
FREE Skills Check
See where your training needs lie: click to view

FREE Bespoke Course Creator
Build your own bespoke course: click to view

Move to next Microsoft Access section
YOU MAY ALSO LIKE ...
SUPPLEMENTARY INFORMATION
More content that may be of interest to you
Version history of MS Access
Changes introduced in the different versions of Microsoft Access: read more

Access 2007 new features
A look at the major upgrade brought about with Access 2007: read more

Access 2010 new features
Access 2010: building on the new interface from 2007: read more

Access 2013 new features
Access 2013: improvements in usability and collaboration: read more

Move to next Microsoft Access section

GENERAL INFORMATION
ABOUT MICROSOFT ACCESS TRAINING

What we do, and how we work, to make sure you get the most from the courses you attend
Blended learning FREE E-learning Revision

With our latest Microsoft Access courses, you get free e-learning revision for 12 months after your class so you can reinforce the knowledge you have gained.
Use the right hand menu on this page to click on the course you want for more information.
Access is simple: go to www.activia.co.uk/login/ and log in using your email address. This will give you free access to our e-learning revision modules.
Note: These have been developed and written exclusively by Activia to maximise effectiveness, by matching the e-learning exactly to what you cover in class. We hope you have fun, on the day of the course and with honing your knowledge afterwards!

About Microsoft Access

Microsoft Access is one of the more advanced programmes in the Microsoft Office suite, and is used to build powerful databases with relatively little effort. The aoftware is extremely versatile, and uses can range from linking simple data lists to fully functional accounts and invoicing systems.

But of all the Microsoft Office applications, Access needs to be set up and used in the correct way. It is possible to teach yourself up to a point, but once an application starts to be used, the effects of not following best practice can have serious consequences. By attending an Activia training course, delegates will learn the correct way to set up, run and develop database applications, with no fear of problems later on.

Are you taking advantage of what Access can offer?

About Microsoft Access

Access is a Relational Database Management System (or RDBMS for short). As you may know, all databases store information -- but Access is a relational system, in that it links together data stored in separate lists, or tables. As an example, one table could contain a list of customers while another might show orders placed. A connection would be made via an account number or ID appearing in both tables, thus enabling the application to recognise and work with the shared relationship.

Our Approach

Activia courses are fully interactive, and tailored workbooks enable delegates to fully engage with the course material, and use the software to develop their skills, all under the tuition of an experienced and helpful trainer. Our fees are competitive too and can easily be accommodated into your training budget.

More about training with Activia

With Activia, you can check your skill level (click here to view our Tools and Resources) which ensures you book on the correct course.   This facility is also invaluable when putting together training programmes or bespoke courses for numbers of delegates.

You can also build your own Microsoft Access course (click here to view our Tools and Resources) to suit your own or your company project requirements, incorporating the modules which cover the subjects you want to learn.



GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

MICROSOFT ACCESS TRAINING

We can enhance your skills with Microsoft Access software training at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our access courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering Microsoft access training all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of training in Access to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Training in Access from Activia.

Why not contact us today to see how we can help with providing your courses for Microsoft Access ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook
YouTube

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777



Back to top
Quick Links to Information
More on This Page
HOME
Resources
About Us
Free Tools
Courses
Locations
Contact Us
Assertiveness
Time Management
Communication Skills
Likeability
About Online Courses
TRY BEFORE YOU BUY
Prices for Online Courses
Online Training FAQ
VIDEO: How to Use It
Free Microsoft Office Course
Microsoft Access
Microsoft Excel
Microsoft Office (incl. 365)
Microsoft Outlook
Microsoft Powerpoint
Microsoft Project
Microsoft Publisher
Microsoft Visio
Microsoft Word
Crystal Reports
Windows Desktop Infrastructure
Office 365
Windows Server
SQL Server
Exchange Server
Sharepoint
Oracle Foundation Skills
Oracle 12c
Oracle Developer Skills
e-Business Suite (Financials)
Management Skills
Performance Management
Supervision & Teams
HR and Coaching
Accounts and Finance
Project Management Essentials
PRINCE2® Project Management
Agile® Project Management
HR and Recruitment
Training & Coaching
Sales
Presentation Skills
Sales Management
Negotiation Skills
Business Writing Skills
Minute Taking Made Easy
Professional Report Writing
Professional Telephone Skills
Touch Typing
Assertiveness
Time Management
Communication Skills
Customer Service
Receptionist Skills
Kings Cross (WC1)
London Victoria (SW1)
Tower Bridge (E1)
Bristol (BS1)
Milton Keynes (MK9)
Reading (RG1)
Slough (SL1)
Birmingham (B1)
Nottingham (NG1)
Manchester (M1)
Leeds (LS1)