EU: +44 (0)20 7234 0380
NA: +1 877 406 6078

Microsoft Access

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

HeaderLogo-Access

Training methods available:

Training available for Microsoft Access versions:
2003, 2007, 2010 and 2013.

Overview

Optimum has offered Microsoft Access training from our central London training facility for nearly 20 years.

Our Microsoft Access courses are broken down into flexible chunks, enabling you to learn right from the basics on our Level 1 certification through to advanced outcomes such as automating a database using macros in our Level 3 course.

Our brand-new central location will provide the perfect learning environment as one of our experienced trainers takes you through the curriculum of your choice, all of which is detailed in the user reference guide.

We offer these courses via both the open-course scheduled dates shown below as well as closed-courses, held at a time, date and location to suit your needs.

Scheduled Courses

For more course dates for each level – please select the relevant course tab above.

Course: Date: Price: Places: Book:
Access Level 107/09/2017£250.006Book

Would you prefer a closed-course for your employees only? These courses can be arranged for a time & place to suit your needs.

Access 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

Scheduled Courses

For more course dates for each level – please select the relevant course tab above.

Course: Date: Price: Places: Book:
Access Level 107/09/2017£250.006Book

Would you prefer a closed-course for your employees only? These courses can be arranged for a time & place to suit your needs.

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

Scheduled Courses

For more course dates for each level – please select the relevant course tab above.

No Events
Course: Date: Price: Places: Book:

Would you prefer a closed-course for your employees only? These courses can be arranged for a time & place to suit your needs.

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

The course assumes that you have a good understanding of relational databases, that you know how to create various types of queries.

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.

Scheduled Courses

For more course dates for each level – please select the relevant course tab above.

No Events
Course: Date: Price: Places: Book:

Would you prefer a closed-course for your employees only? These courses can be arranged for a time & place to suit your needs.