About Us
  |  
Free Tools
  |  
Courses
  |  
Locations
  |  
Contact Us
ABOUT ACTIVIA
Activia for Microsoft Access Training
Tutor led training that gets results
Bookings and Enquiries:
Customer Service:
0333 6000 111
0333 6000 555
Icon for Training for Access 2003 to 2013

Access Training Courses

Training for Access 2003 to 2013

Contact information Click to request a callback
Access training at our centres or your offices UK-wide
All Courses
Course Outlines
Prices
Dates and Venues
Delegate Feedback
General Information
Access Training Courses from Activia main image
General Information
about Microsoft Access training

You can use Access to build powerful databases with relatively little effort. Microsoft Access is extremely versatile, and applications can range from linking simple data lists to fully functional accounts and invoicing systems.
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 Access to recognise and work with the shared relationship.

Our Approach

Microsoft Access is one of the most powerful applications in the Microsoft Office suite, and requirements for Microsoft Access training can be extremely varied.

Activia courses are fully interactive, allowing delegates to engage with the course material. Our fees are competitive too and can be accommodated in to your training budget.

More about training with Activia

With Activia, you can check your skill level (see the button above on the right) 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 the button above on the right) to suit your own or your company project requirements, incorporating the modules which cover the subjects you want to learn.

Delegate Feedback  from our Microsoft Access courses
Average Review 4.5/5 based on 123 reviews.

"It was great to have one-to-one tuition and this meant I was able to ask lots more questions and look at databases with specific reference to my work, which was excellent. It was also good to be able to plan my basic database on paper (as homework!) to work on next day."     Catherine Roth     Jul 27 2015     Rating for feedback (5 stars)

"Very good and informative course that covered exactly what I required. Our trainer Alasdair was very good and very helpful throughout the day."     David Powell     Jul 20 2015     Rating for feedback (4 stars)

"The course was really enjoyable, I found the contents extremely interesting and they will prove to be very useful for work I carry out going forward. The workbooks we also have from the course will be a great point of reference when I am working in Access and they contain some really handy exercises."     Joseph Constantine     Jul 13 2015     Rating for feedback (5 stars)

"The teacher was excellent, very knowledgable and also very helpful. The speed of the class was also perfect. "     Darragh Creegan     Jul 6 2015     Rating for feedback (4 stars)

"Lara is a great trainer - very knowledgeable and prepared to talk about our individual requirements which was much appreciated."     Kate Aley     Jun 29 2015     Rating for feedback (4 stars)

"Enjoyed the course and how it was presented."     Fernlet Maxwell     Jun 22 2015     Rating for feedback (5 stars)

"Small group size made for good interactive session"     John Councer     Jun 2 2015     Rating for feedback (4 stars)

"Very enjoyable training"     Z. Adam Holboj     Jun 2 2015     Rating for feedback (5 stars)

"Small group size was excellent"     John Councer     Jun 1 2015     Rating for feedback (4 stars)

"Great training and very professional delivery"     Z. Adam Holboj     Jun 1 2015     Rating for feedback (5 stars)

"The course tutor was very good and helpful!"     Victoria Radonjic     May 22 2015     Rating for feedback (5 stars)

"great day, learned a lot - thanks!"     Gabriele Klosters     Apr 21 2015     Rating for feedback (5 stars)

"The instructor (Jamie) was very helpful"     Karl Findlay     Apr 20 2015     Rating for feedback (4 stars)

"very good knowledgeable and approachable trainer."     Matthew Hind     Apr 14 2015     Rating for feedback (4 stars)

"The course and tutor were excellent."     Les Sayer     Apr 9 2015     Rating for feedback (5 stars)

"The course and tutor were excellent"     Les Sayer     Apr 7 2015     Rating for feedback (5 stars)

"This was a very useful day for me."     Miranda Loutet     Apr 1 2015     Rating for feedback (3 stars)

"Steve was highly enthusiastic and informative in his presentation and instruction. There were plenty of tips and guidance for me to fit into the way I use MS Access in my current working environment."     Graeme Robertson     Mar 23 2015     Rating for feedback (5 stars)

"I thoroughly enjoyed my course and found it very informative. The trainer (Jane Brown) was extremly helpful and made everything easy to understand. If I had the choice, I would choose her again if I attend another course. "     Mary Miller     Mar 10 2015     Rating for feedback (5 stars)

"Thank you"     Vicki Lepley     Mar 9 2015     Rating for feedback (5 stars)

Microsoft Access Introduction (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course
Click to view all courses
Activia icon
Versions covered
This course covers Microsoft Access 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.
Course objectives
  • Create an Access file and become acquainted with Access' basic controls
  • Understand and list Access' different Ribbon tabs and the options it offers
  • Create tables and set their fields appropriately
  • Create Forms, Queries, Reports and Filters
Summary of content covered
  • Getting Started with Access
  • The New Ribbon Interface
  • Creating a Simple Database
  • Forms; Queries; Reports and Filters

NOTE: A full outline, along with comprehensive course information, is available by clicking the "full course details" button here:

Microsoft Access Intermediate (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course
Click to view all courses
Activia icon
Versions covered
This course covers Microsoft Access 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.
Course objectives
  • Identify and use functions to manage and safeguard your database
  • Understand different field types and validation to improve database efficiency
  • Create and customise forms to improve user interaction with your database
  • Create and customise reports for better presentation of your data
  • Create basic and more advanced queries using Access' query tools and wizards
Summary of content covered
  • Advanced File Tasks
  • Working with Tables
  • Working with Forms
  • Working with Reports
  • Working with Queries

NOTE: A full outline, along with comprehensive course information, is available by clicking the "full course details" button here:

Microsoft Access Advanced (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course
Click to view all courses
Activia icon
Versions covered
This course covers Microsoft Access 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.
Course objectives
  • Understand how table relationships are created and recognise SQL code
  • Create navigation and other specialist forms to achieve the complete user experience
  • Use forms to launch reports without having to constantly change criteria in a query
  • Understand and Create useful SQL statements to manage your database with effectively
  • Create Macros and Procedures for bespoke functionality using the Developer tab
  • Use advanced Access features to secure a database and control how users access database objects
Summary of content covered
  • Advanced Data Management
  • Advanced Form Tasks
  • Automating Reports
  • SQL and Microsoft Access
  • Macros and Visual Basic for Applications (VBA)
  • Finishing the Application

NOTE: A full outline, along with comprehensive course information, is available by clicking the "full course details" button here:

Microsoft Access Introduction (2003 & XP)

Course Outline

Duration: this is a one-day training course
Click to view all courses
Activia icon
Versions covered
This course covers Microsoft Access 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.
Course objectives
  • Open, close and work with Access basics including Help files
  • Create an Access table and perform simple tasks such as inserting data
  • Effectively create forms, reports and queries using the built in wizards
  • View and organise database objects ready to print
Summary of content covered
  • Getting Started
  • Creating a Database
  • Doing More with Your Database
  • Viewing and Printing Your Data

NOTE: A full outline, along with comprehensive course information, is available by clicking the "full course details" button here:

Microsoft Access Intermediate (2003 & XP)

Course Outline

Duration: this is a one-day training course
Click to view all courses
Activia icon
Versions covered
This course covers Microsoft Access 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.
Course objectives
  • Understand database design and the creation of relationships
  • Use database file tools to perform file tasks including backup and repair
  • Work with the properties and design of an Access table
  • Create and customise the design of an Access Form
  • Generate and customise the properties of a report
  • Understand the use of and create queries to extract data from tables
Summary of content covered
  • Database Design Basics
  • Advanced File Tasks
  • Working with Tables
  • Working with Forms
  • Working with Reports
  • Working with Queries

NOTE: A full outline, along with comprehensive course information, is available by clicking the "full course details" button here:

Microsoft Access Advanced (2003 & XP)

Course Outline

Duration: this is a one-day training course
Click to view all courses
Activia icon
Versions covered
This course covers Microsoft Access 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.
Course objectives
  • Effectively use macros to automate common tasks in the database
  • Use advanced tools to develop databases, such as switchboards and data access pages
  • Use advanced queries to extract more complex data from the tables
  • Use Access Pivot tables to analyse large quantities of data
Summary of content covered
  • Customising Access
  • Advanced Data Tools
  • Advanced Queries
  • Pivot Tables and Pivot Charts

NOTE: A full outline, along with comprehensive course information, is available by clicking the "full course details" button here:

All Courses  for Microsoft Access training
Course Summaries

  TIP :    Click on the blue Course Outline button for any course to see its content.

Image for Access Introduction (2007, 2010 & 2013)
Access Introduction (2007, 2010 & 2013)

About the course: Microsoft Access is THE application for creating desktop databases. This introduction course shows you the basics of creating a desktop database and gives you a solid foundation on which to build your database skills. During the day we will create a new database and populate it with all the necessary elements: tables, queries, forms and reports, as well essential tasks such as entering data, sorting and filtering data and printing database objects.
Course aims: In this comprehensive course, beginners will get to grips with the main features of Microsoft Access 2007, 2010 and 2013, including how to navigate the new Ribbon interface.
Who should attend: New users of Microsoft Access 2007, 2010 or 2013, who want to become productive. Basic IT skills are required.
Image for Access Intermediate (2007, 2010 & 2013)
Access Intermediate (2007, 2010 & 2013)

About the course: As a basic database user, you probably know how frustrating it can be to take Access to the next level, and this course is designed to do that in just a day. You will learn about importing and exporting data and customising tables through their properties, you will increase your knowledge of forms and reports by using more advanced controls and techniques and you will find out how to use queries more productively by performing calculations and using management queries.
Course aims: On this in-depth course, delegates will gain a solid understanding of the more advanced tools and concepts within Microsoft Access 2007, 2010 and 2013 enabling them to increase their knowledge and productivity.
Who should attend: Current users of Microsoft Access 2007, 2010 or 2013 who need to build upon their existing knowledge of the basic features of this package.
Image for Access Advanced (2007, 2010 & 2013)
Access Advanced (2007, 2010 & 2013)

About the course: Are you are an experienced Access user looking to add extra functionality to your database? Then this is the course for you. During the day we will expand your knowledge of Access by creating navigation forms and form driven reports, look at the issues of table relationships and referential integrity in more detail and how to generate your own SQL queries. We will also start to automate our database using macros and simple VBA code.
Course aims: Learners will be taught how to use the advanced tools and concepts of Microsoft Access 2007, 2010 and 2013, enabling them to become more productive on this practical, one-day course.
Who should attend: Highly proficient users of Microsoft Access 2007, 2010 or 2013 who want to improve their capabilites as soon as possible.
Image for Access Introduction (2003 & XP)
Access Introduction (2003 & XP)

About the course: Access 2003 is Microsoft's desktop database application and can be used to create powerful database solutions. The Activia Introduction course to Access 2003 is aimed at complete beginners and is designed to show you the fundamentals of creating a desktop database and give you a solid base on which to build your database skills. During the day you will learn how to create a database from scratch and populate it with: tables, queries, forms and reports. How to enter and edit data, sort and filter data and print out your results.
Course aims: Delegates will gain an understanding of the major features and functions within Microsoft Access 2003 and XP, including an introduction to database theory and some hints and tips on good database design techniques.
Who should attend: Suitable for beginning users of Microsoft Access 2003 or XP with little or no existing database knowledge. Basic It skills are required.
Image for Access Intermediate (2003 & XP)
Access Intermediate (2003 & XP)

About the course: Access 2003 is a complex application, and once you have learned the basics it can be frustrating to take it to the next level, so that's what the Access 2003 intermediate course is designed to help with. During the day we will increase your knowledge of Access 2003 by looking at; the fundamentals of database design, importing and exporting data and customising tables through their properties, use more advanced controls and techniques on forms and reports and also, how to create calculations in queries and using advanced query types.
Course aims: In this intensive one-day course, delegates will learn how to use complex queries, enhance data entry and reporting with forms and reports in order to enable them to create more comprehensive databases.
Who should attend: Current users of Microsoft Access 2003 or XP who can create a basic database, but would like to learn about some of the more advanced features of this software.
Image for Access Advanced (2003 & XP)
Access Advanced (2003 & XP)

About the course: If you are an experienced Access 2003 user you are probably looking to add an extra bit of functionality to your database. This is what our Access 2003 Advanced course will achieve. During the day we will expand your knowledge of Access by showing you ways to customise Access, how to create a switchboard and data access pages, create summary and crosstab queries, create and use pivot forms and charts and how to use macros to automate your database.
Course aims: On this practical, one-day course, delegates will be given a thorough understanding of the advanced Microsoft Access 2003 or XP, enabling them to increase their knowledge and productivity.
Who should attend: Proficient users of Microsoft Access 2003 or XP who want to consolidate and expand on their knowledge in a short space of time.
Prices  for Microsoft Access training
Please note : all prices exclude VAT.
Scheduled public classes
[The simplest and most cost-effective option for 1, 2 or 3 delegates]
If you book in advance, Early Bird prices start at just £139
•  Access Introduction (2007, 2010 & 2013)
 
First delegate: £199
2nd delegate: £159
3rd delegate +: £139 each
•  Access Intermediate (2007, 2010 & 2013)
 
First delegate: £199
2nd delegate: £159
3rd delegate +: £139 each
•  Access Advanced (2007, 2010 & 2013)
 
First delegate: £199
2nd delegate: £159
3rd delegate +: £139 each
•  Access Introduction (2003 & XP)
 
First delegate: £249
2nd delegate: £199
3rd delegate +: £159 each
•  Access Intermediate (2003 & XP)
 
First delegate: £249
2nd delegate: £199
3rd delegate +: £159 each
•  Access Advanced (2003 & XP)
 
First delegate: £249
2nd delegate: £199
3rd delegate +: £159 each
NOTE   [click to show/hide]
To view scheduled dates, click the "Dates" button on the right

Training at your offices
[A convenient and very cost-effective option for groups of delegates]
•  Access Introduction (2007, 2010 & 2013)
 
First delegate: £479
Extra delegates: £45 each
(Price per day)
•  Access Intermediate (2007, 2010 & 2013)
 
First delegate: £479
Extra delegates: £45 each
(Price per day)
•  Access Advanced (2007, 2010 & 2013)
 
First delegate: £479
Extra delegates: £45 each
(Price per day)
•  Access Introduction (2003 & XP)
 
First delegate: £479
Extra delegates: £45 each
(Price per day)
•  Access Intermediate (2003 & XP)
 
First delegate: £479
Extra delegates: £45 each
(Price per day)
•  Access Advanced (2003 & XP)
 
First delegate: £479
Extra delegates: £45 each
(Price per day)
NOTES   [click to show/hide]

Dates and Venues  for our public classes

Prices vary, and in general, the earlier you book, the lower the price.
Our small class sizes mean that classes are often full, so it's usually best to book as soon as you can.   So don't be disappointed by leaving it too late!

If you see classes at higher prices set to run over the next few days, these are empty classes and if you book, you may be the only delegate attending.

NOTE : prices are per delegate and exclude VAT.

Click on the links in the right panel for outlines and more information on any course.
View scheduled dates for the course you want by clicking on "Show/Hide Dates" in the relevant blue panel below.
Click on 'Book now' against the class you wish to book.

Access 2007, 2010 and 2013
 Application/Subject
Level
Date
Centre
Price
 
Access Introduction (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
Sep 7, 2015
Nottingham
 
**Full**
Sep 21, 2015
Reading Green Park
£199
Book Now
Sep 21, 2015
Milton Keynes
£199
Book Now
Sep 21, 2015
Leeds
£199
Book Now
Sep 28, 2015
Birmingham City Centre
£199
Book Now
Sep 28, 2015
Tower Bridge
£199
Book Now
Oct 5, 2015
Bristol
£199
Book Now
Oct 5, 2015
Manchester Princess Street
£199
Book Now
Oct 12, 2015
London Baker Street W1
£199
Book Now
Oct 12, 2015
Slough
£199
Book Now
Oct 19, 2015
Nottingham
£179
Book Now
Nov 2, 2015
Reading Green Park
£179
Book Now
Nov 2, 2015
Leeds
£179
Book Now
Nov 2, 2015
Milton Keynes
£179
Book Now
Nov 9, 2015
Tower Bridge
£159
Book Now
Nov 9, 2015
Birmingham City Centre
£159
Book Now
Nov 16, 2015
Manchester Princess Street
£159
Book Now
Nov 16, 2015
Bristol
£159
Book Now
Nov 23, 2015
Slough
£139
Book Now
Nov 23, 2015
London Baker Street W1
£139
Book Now
Nov 30, 2015
Nottingham
£139
Book Now
Access Intermediate (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
Sep 8, 2015
Nottingham
 
**Full**
Sep 22, 2015
Milton Keynes
£199
Book Now
Sep 22, 2015
Leeds
£199
Book Now
Sep 28, 2015
Reading Green Park
£199
Book Now
Sep 29, 2015
Tower Bridge
£199
Book Now
Sep 29, 2015
Birmingham City Centre
£199
Book Now
Oct 6, 2015
Bristol
£199
Book Now
Oct 6, 2015
Manchester Princess Street
£199
Book Now
Oct 13, 2015
Slough
£199
Book Now
Oct 14, 2015
London Baker Street W1
£199
Book Now
Oct 20, 2015
Nottingham
£179
Book Now
Nov 3, 2015
Reading Green Park
£159
Book Now
Nov 3, 2015
Leeds
£159
Book Now
Nov 3, 2015
Milton Keynes
£159
Book Now
Nov 10, 2015
Birmingham City Centre
£159
Book Now
Nov 10, 2015
Tower Bridge
£159
Book Now
Nov 17, 2015
Bristol
£159
Book Now
Nov 17, 2015
Manchester Princess Street
£159
Book Now
Nov 24, 2015
Slough
£139
Book Now
Nov 24, 2015
London Baker Street W1
£139
Book Now
Access Advanced (2007, 2010 & 2013)
[ Click to Show/Hide Dates +/– ]
Sep 9, 2015
Nottingham
 
**Full**
Sep 23, 2015
Leeds
£199
Book Now
Sep 23, 2015
Milton Keynes
£199
Book Now
Sep 30, 2015
Reading Green Park
£199
Book Now
Sep 30, 2015
Birmingham City Centre
£199
Book Now
Sep 30, 2015
Tower Bridge
£199
Book Now
Oct 7, 2015
Manchester Princess Street
£199
Book Now
Oct 7, 2015
Bristol
£199
Book Now
Oct 14, 2015
Slough
£199
Book Now
Oct 14, 2015
London Baker Street W1
£199
Book Now
Oct 21, 2015
Nottingham
£179
Book Now
Nov 4, 2015
Leeds
£159
Book Now
Nov 4, 2015
Reading Green Park
£159
Book Now
Nov 4, 2015
Milton Keynes
£159
Book Now
Nov 11, 2015
Tower Bridge
£159
Book Now
Nov 11, 2015
Birmingham City Centre
£159
Book Now
Nov 18, 2015
Bristol
£139
Book Now
Nov 18, 2015
Manchester Princess Street
£139
Book Now
Nov 25, 2015
London Baker Street W1
£139
Book Now
Nov 25, 2015
Slough
£139
Book Now
Need another date or location ?   Click to schedule your own class from £299.

Access 2003 & XP: no public classes currently scheduled.

Access Training Courses from Activia

Activia Training logo

We can provide training in Access at any of our ten centres UK wide, or we can come to your offices – if you have groups of staff who need training, this is a particularly convenient, flexible and cost effective option.

We have been training business all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and cost effective provision of training in Access.   This means you can be confident that we have the expertise, and the experience, to give all you need with courses for Microsoft Access.

Activia Training logo
Quality Assurance
Quality assurance from Activia Training
 
Privacy Policy     |     Terms & Conditions     |     Blog     |     Course Finder     |     Request a callback