WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 481 reviews for our classroom and online training
Classroom training -  Access Developers

Classroom Training

Microsoft Access Developers

Available as classroom training course only

£1,295 + VAT for most venues (£1,495 + VAT for London)

3 days

The first (and most important) part of any Access database is getting the design right, which is where this 3-day course begins. You'll learn about primary keys and relationships, and find out how to create an Access database consisting of multiple linked tables.

The course then goes on to show how to create queries (to display data from one or more tables) and a front-end to your system, using forms, reports and the VBA coding language.

If you've been given the job of creating an Access database - and you're not sure where to start - this is the course for you!

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking.

Alternatively, you could enquire about running the course in your office or even (if available) as a tailored online course.

Course Contents

The contents of this course are as follows:

Designing a database

  • Identifying the tables
  • What are relationships?
  • Setting a primary key
  • Using multivalue fields

Creating tables

  • Defining fields
  • The types of field
  • Entering data

Different field types

  • Creating attachments
  • Rich text format fields
  • Date fields (using calendars)
  • Calculated fields

Importing data

  • Importing from Excel
  • Making tables from Excel

Covered if time allows If time

Table rules

  • Record-level validation
  • Basic triggers

Drawing relationships

  • Creating relationships
  • Referential integrity

Creating queries

  • The query design grid
  • Sorting
  • Setting criteria
  • Combining criteria

Advanced queries

  • Grouping and totalling
  • Creating expressions
  • Parameter queries

Joins

  • Creating ad hoc joins
  • Types of join

Covered if time allows If time

Crosstab queries

  • Columns, rows and values
  • Overriding column headings

Covered if time allows If time

Action queries

  • Making tables
  • Updating records
  • Appending records
  • Deleting records

Creating forms

  • Layout and design view
  • Using the form wizard
  • Split forms
  • Creating controls

Covered if time allows If time

Advanced controls

  • Multitabs
  • Webbrowser controls
  • Navigation bars

Creating reports

  • Using the report wizard
  • The group, sort and total pane
  • Report design

Creating subforms

  • Multiple item forms
  • Creating subforms
  • Tidying up subforms

Basic VBA coding

  • Creating modules
  • Using Project Explorer
  • Writing comments
  • Indenting code

Uses of VBA

  • Form validation
  • Criteria forms
  • A simple menu system

You do not need to have used Access before to attend this course, although you should be a confident computer user.

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Excel isn't an easy topic to be delivered. Still our trainer succeeded to deliver it, not just keeping our interest awake but with such a flow and it was so easy to understand. The course was also very up to date with the latest (1 months old) excel updates by Microsoft. I had also found their customer service very friendly and customer focused. It was a pleasure to organise the course with them. I would highly recommend them to anyone."

Marianna Magocsi (Interfood Technology Ltd)

"I really enjoyed this course. I've done a number of courses over the years (not Wise Owl Training and not PBI), but this was head and shoulders above the others. It might be that I was interested in learning about the topic, but the whole experience was seamless. The pre-course IT check was an important detail (I did a course the previous week with another provider and this beset with IT issues upon starting). Using the remote desktop meant I had easy access to the data and the trainer could see when I did something wrong. The trainer was also very good. I'd actually be happy to do another online course again (even after Covid) - I didn't feel like I lost anything by doing it this way. It was booked for me - but I'm glad the person who booked it, chose Wise Owl."

Stuart Andrews (Valuation Office Agency)

"Course content great & we had a very patient trainer. Thank you."

Jayne Pasco (Waltham Forest Council)

"Great course, very insightful and the trainer was comprehensive with everything he showed me. Thanks!"

Jordan Byrom (Addleshaw Goddard)

"I enjoyed the on-line course and the pace at which it was taught. I feel I can now tackle SQL queries and hope to build my confidence in this area. The teaching was clear and well explained."

Louise France (Portsmouth Hospitals University NHS Trust)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Related Courses

Access Querying

Basic

1 day course

Access VBA macros RECOMMENDED

Advanced

2 day course

Advanced VBA

Guru level

2 day course

Other Microsoft Access training resources

Access exercises

Access exercises

To give you a chance to see whether this 3-day Access course is for you, we've published all of our Microsoft Access exercises online.

View Access VBA or Access 2010 exercises

Access blogs

Access blogs

In addtion to other Access training resources, you may find some of our Access blogs useful.

View Access or VBA macros blogs

This page has 0 threads Add post