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 at Competitive Prices
Access Training at Competitive Prices
Search

PRICES FOR MICROSOFT ACCESS TRAINING

Access Training Courses to suit your budget

Interactive hands-on courses for users of Microsoft Access – great prices with flexibility and friendly helpful service included
Please note: all prices exclude VAT
E-Learning

A great option if your time and/or budget are limited.

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
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



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.

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

Scheduled Public Classes

The simplest and most cost-effective option for 1, 2 or 3 delegates.

  • For scheduled public classes, prices start at £229
  • For multiple delegates, prices can be as low as £159
  • If you book in advance, Early Bird prices start at just £190
  • If a course is not scheduled, you can usually Schedule Your Own from £229

NOTES:
Lower prices for additional delegates are subject to booking at the same time.
Bookings made at discounted prices cannot be cancelled.

To view course dates or book a place please click here.

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

Training At Your Offices

A convenient and very cost-effective option for groups of delegates

  • Onsite training is available from just £479
    [NOTE: small additional charges apply per delegate]

Notes:
For delivery of training over more than one day, make sure to multiply the full day rate by the number of days to get the total cost.

We can also deliver "Private" (or "Closed") courses for you at one of our centres from £529
[NOTE: small additional charges apply per delegate].

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


Click for more about Microsoft Access training

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 PRICES

We are here you help you improve your skills with Microsoft Access software training with a UK wide network of twelve centres, as well as the ability to come to your offices: for groups of three or more staff, this is a very convenient, flexible and cost effective option for training. All our access courses are 1 day, and this keeps "out of office" periods for delegates at a minimum.

Be sure that we have the expertise, the experience and the dedication to provide the best return on your investment in Microsoft Access Training.   Since our formation in 1995, we have been delivering Microsoft access training across the UK, continually developing our quality, flexibity and effectiveness in supplying Training in Access from Activia which has ensured continually improving standards.

Please contact us today to see how we can assist you with training in 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