Advanced Access Training

1 day - £225 + vat

Advanced Access Training

"Great teaching - very enjoyable & helpful." - Claire Thackway, Brighton College

Many organisations have large databases in Access that have built up over the years.

Staff have learned enough to build a database with a good relational structure, create forms to enter data and write queries to generate some useful reports.

However when databases get big, making your queries and forms effective can become more complex, and it is worth investing in advanced Access training to get the most from your data and save time.

Advanced Microsoft access training builds upon skills covered on our beginners Microsoft Access Training Course.

Delegates on our advanced Microsoft access training course will learn how to analyse data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros.

We also provide private and in-company Microsoft Access courses. Call 01273 622272 to discuss.

Advanced MS Access Feedback

"Feel I have had a rounded introduction to Access, which is exactly what I required from the course. Very friendly and patient trainer who ran the course at a flexible pace."
Paul Clarke - Hampshire Probation Trust

"Steve understood exactly what I was trying to do. the course was personalised and progressive - excellent step by step method."
Andie Davidson - Mecmesin Ltd 

Microsoft Access Course Objectives:

By the end of this Advanced MS Access training course, delegates will have extended their knowledge of Access databases to advanced levels to include using macros.

Advanced Microsoft Access Training Course Prerequisites:

Delegates on this Microsoft access course should understand the basic concepts of creating an Access Database or attended our Beginners Access training course.

Download the Advanced Microsoft Access Training Course Outline

Advanced Microsoft Access Course Content

Introduction

  • Review of basic concepts:
  • Design concepts
  • Relationships between tables

Designing Queries

  • Using And and Or statements
  • Totals Queries
  • Creating calculations in queries
  • Parameter Queries
  • Autolookup Queries

Designing Forms

  • Adding controls
  • Working with combo boxes
  • Working with calculated controls
  • Control properties
  • Working with subforms

Report Design

  • Creating a report using the Wizard
  • Designing grouped reports
  • Adding sub-totals to reports

Macros

  • Creating simple macros
  • Creating grouped macros
  • Creating conditional macros
  • Assigning macros to command buttons
  • Creating a Switchboard
  • Using macros to pass conditions between forms
  • Using macros to pass conditions to run reports

Download the Advanced Microsoft Access Training Course Outline

For full course content and pre-requisites download the Advanced Access Training Course PDF

From the blog...

Microsoft Office 2010 – Introduction to the Ribbon

microsoft-office-2010-ribbon

If your business has recently upgraded to a new version of Microsoft Office you may have seen a noticeable drop off in productivity from your staff. Versions of Office up to and including 2003 all had a relatively similar layout, with dropdown menus used to access the various functions.  Users had become familiar with this [...]

The post Microsoft Office 2010 – Introduction to the Ribbon appeared first on Silicon Beach Training Blog.

Share This

Request a callback

Advanced Access Training course dates

Brighton

  • 5 Jul 2013
  • 5 Nov 2013

Follow Silicon Beach Training

Sign Up For Our Newsletter

Exclusive offers, free resources and the latest tech & business news

Customer Reviews

Silicon Beach Training
Silicon Beach Training Reviews4.9/5 stars
Based on 22 reviews.
See independent Google Places, Free Index and Qype reviews.

You may also be interested in:

Home | Sitemap | Print |