• UK +44 (0)20 7234 0380   US +1 877 406 6078

Market leading Microsoft Access training courses

Our three levels of Microsoft Access training will take you through database design, creation, customisation, automation and security.

Our experienced trainers have delivered thousands of Microsoft Office courses over the years.

The set course topics are listed below, but we're also happy to tailor course content specifically for your requirements.

94% Delivery satisfaction rating94%Delegate satisfaction rating

500+ Clients trained globally???Delivered wherever you require

Delivery Methods1Detailed reference guide included

400,000+ End-users trained since 1998500,000+End users trained since 1998

Our Microsoft Access courses

Our Microsoft Access courses are broken down into flexible chunks, as outlined in the tabs below. These courses are offered on a closed-basis for your employees only, enabling us to tailor the content to your requirements.

They're held at a time and date to suit your needs, in any location of your choice.

Enabling beginners to learn the basics on our Level 1.

Overview

This practical, hands-on course is designed for database users who need to acquire Access skills quickly and effectively. Practice tasks and case studies ensure that fundamental techniques can be applied quickly in a demanding financial and business environment.

Duration

1 Day

Requirements

No previous knowledge of Access is necessary, but you need to be able to manage and navigate Windows, save and retrieve documents and use a mouse to select data.

Objectives

  • Create a database containing related tables
  • Create and identify relationships between tables and define referential integrity
  • Work with data, including sorting and filtering records
  • Select data with queries and control selection by setting criteria and parameters
  • Define and run queries using multiple tables
  • Add calculated fields to queries

Content

Overview of Access:
The concept of a relational database; managing information effectively; working with databases and how Access objects work together to allow you to add, edit, find and report on information.

Creating databases and tables:
Creating a table; using the Table Wizard; defining field names and data types; overview of available data types; establishing a primary key; saving the table definition.

Setting field and table properties:
Validating data entry; using the Expression Builder; creating an index.

Creating relationships between tables:
An overview of relationships; defining and understanding one-to-one, one-to-many and many-to-many relationships; normalising data; working with the relationships window; setting referential integrity and related options.

Entering and editing information:
Opening and closing databases and tables; entering data in the datasheet; how records are saved; editing records; shortcuts for entering repeating information and dates; working with sub-datasheets.

Locating, filtering and sorting records:
Finding records; sorting records; sorting on more than one field; defining and applying filters; clearing filters and sorting.

Customising datasheets:
Changing column widths; choosing the font; printing the datasheet.

Selecting data with queries:
Creating queries; refining selection by setting criteria and parameters; adding calculated fields to a query; querying multiple tables; creating summary queries; setting query properties; saving and running queries.

Introducing forms and reports:
Creating basic forms and reports using wizards.

 

Showing experienced users how to develop their skills on our Level 2.

Overview

This is a practical hands-on course designed for database users who need to extend their Access skills. Practice tasks and case studies ensure that techniques can be applied quickly in a demanding financial and business environment.

Duration

1 Day

Requirements

The course assumes that you have a basic understanding of relational databases, and that you know how to create tables and select data with queries.

Objectives

  • Import and link data and describe the difference between importing and linking
  • Create and use action queries to delete, update and append data
  • Export and use data in another application
  • Create forms using wizards, and use basic design techniques to make them more user-friendly
  • Create reports using wizards, and modify the layout using basic design techniques.

Content

Reviewing Access:
How Access objects work together; the importance of using appropriate relationships in a database; creating and running queries with various criteria.

Working with imported data:
Importing or linking data; importing data from other applications (such as Excel or text files); importing from other Access databases; defining an import specification.

Exporting data:
Exporting to a text file, worksheet or database files; merging Access data with a Word document.

More on queries:
Using the query wizards to find duplicates or unmatched records; using action queries to create tables, delete data, append or update records; summarising information with cross-tab queries and totals.

Creating forms and reports:
Using the form and report wizards to create a basic form and report.

Customising forms:
Using form design view; adding controls; setting properties of controls; setting form properties; changing the tab order.

Customising reports:
Working in design view; report sections and their properties; working with groups; adding subtotals and totals; controlling page breaks.

 

Allowing expert users to complete their knowledge on our Level 3.

Overview

This is a practical hands-on course designed for experienced Access users to extend their skills and expertise.

Duration

1 Day

Requirements

This is a practical hands-on course designed for experienced Access users to extend their skills and expertise.

Objectives

  • Design and create complex forms and reports, including graphics, sub-forms and sub-reports
  • Automate a database using macros and command buttons
    Add finishing touches to a database application including switchboard forms and start-up options
  • Set security levels to control access to your database and objects
  • Customise menus and toolbars.

Content

Designing forms:
Understanding the design window; form sections; adding controls; bound, unbound and calculated controls; adding tab controls; synchronising sub-forms; using list and combo boxes; using a combo box to set query parameters.

Designing reports:
Designing a report; grouping, sorting and summarising; report sections and properties; controlling layout, pagination and page setup; embedding a sub-report; creating a report snapshot; embedding pictures and graphics in forms and reports.

Understanding events:
Exploring Access events; default behaviours for events; how to customise and control event behaviours.

Automating your database:
Creating macros; adding actions arguments and comments; automating data entry with macros; using macros to print records; creating pop-up forms with macros.

Creating an application:
Toolbars and key assignments: creating custom menus; creating keyboard assignments; customising toolbars; attaching custom toolbars to forms.

Implementing security:
Splitting the database; setting passwords; setting a database password; protecting the front end database; testing security settings.

 

Optimum Course Outlines

Download our brochure to find out more about training courses offered by Optimum

download pdf
Whitepaper

Why User-Focused Training Works Best

Whitepaper

Microsoft Office 2016 release – what’s new?

Optimum online chat

Chat with us

Available 9am – 5pm GMT

chat now
Call Optimum

Give us a call

UK +44 (0)20 7234 0380
US +1 877 406 6078

Request a call from Optimum

Request a call

Let us know when
suits you best

request

Benefits of using Optimum

Benefits of Optimum

Certified courses

Our certified training courses will leave you feeling more confident and competent in using the system.

Benefits of Optimum

Delivered anywhere

The training can be delivered in any location of your choice. You name it and we'll be there.

Benefits of Optimum

Various options

We've broken the content down into levels of knowledge, allowing you to learn from any starting point.

Benefits of Optimum

Specific focus

We offer the flexibility to cherry-pick specific elements of the course content for additional focus.

Learn from our experienced Microsoft Office team

Whilst other training providers build training teams with one-off contractors, we have a large group of permanently-employed training consultants, who provide our clients with an expert, flexible service.

meet the team

Tell us about your training requirement

Join our mailing list and get all the latest Optimum news direct to your inbox
Yes

I consent to join the mailing list and have Optimum collect my name and email address.
Read our Privacy Policy to see how we protect and manage your data