Microsoft Access Training Courses

This page contains a cornucopia of Access training information!

Microsoft Access classroom training

Access classroom training

We run a variety of courses in MS Access - choose the right one for you!

Can't see the course you want? Have a look at our onsite Microsoft Access training page, or see our other Access training resources.

Not sure which course you want? See what you can learn on one of our Access courses.

Which is the right Access course for you?

Access is Microsoft's end-user database (think of it as SQL Server's much younger brother, and you won't go far wrong). 

If you're contemplating upsizing an Access database to SQL Server, we also offer tailored training covering the main pitfalls to avoid.

Before discussing the training that Wise Owl offer, some important notes to begin with:

Note Details
Availability of Access courses We were finding that many of our Access courses were running with one or at most two delegates, so we no longer schedule public Access training courses.  However, if you have three or more people who want training we'll always consider adding courses to our schedule (ask us!), or you could always ask about onsite Access training.
Versions covered Access comes in two flavours: databases and web apps.  We only teach the former.  There are many reasons to avoid the latter; not least the fact that Microsoft are no longer supporting them.
Language taught Access comes with two competing languages: macros and modules.  Macros (confusingly) are nothing like the macros used in Excel - instead, they allow you to choose commands from a list.  Modules, by contrast, allow you to write code in VBA within Access.  We think Access macros are a really silly idea (they aren't as powerful as modules) so we only teach VBA.

If you imagine Access as a swimming pool, you can stay in the shallow end or swim through it to reach the deep end.  Here's what this analogy means!

Pool end What you'll learn Course Length
Shallow How to create a relational database, including creating tables, entering data and linking tables together with relationships.  You'll also learn how to create queries to extract data from tables. Access Querying 1 day
Deep All of the above, plus how to create forms and reports to build a user interface, including using VBA code to link everything together. Access for Developers 3 days
Diving pool Once you've learnt to swim, you might like to consider learning more about how to write VBA within Access (note that some of the content is repeated from the 3 day developers' course). Access VBA 2 days

Although Microsoft sell Access as easy-to-use end-user software, it has many foibles, and you should put aside weeks rather than days to become proficient in using it.  In particular, users of Excel can take a while to get used to the more structured approach to storing data that Access demands.

To see more details about our range of Access training courses, have a look at our more detailed Access help page.

10 things our Access courses include

Each of our scheduled courses includes:

  1. Small course sizes - we have a maximum of 6 people on each course, and frequently run courses with fewer.
  2. A computer for each delegate (obviously).
  3. A trainer! And not just anyone - Wise Owl courses are only ever given by Wise Owls.
  4. Full colour courseware of oustanding quality .
  5. Interesting exercises to reinforce what you've learnt (you can review some of the Access exercises we use here).
  6. Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
  7. Unlimited refreshments during the day, including Tassimo or Nespresso coffee and a range of biscuits and snacks to keep you going through those dark afternoon hours.
  8. A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too.
  9. A Sheaffer biro and notepad.
  10. Unofficial help after the course (although we don't have a dedicated post-course support line, in practice trainers will be happy to answer the odd ad hoc question after a course has taken place).

Have a look at our full list of benefits, or read hundreds of testimonials to the quality of our training.

Scheduled Access training dates

Here are the Access courses we have scheduled for the next 3 months:

Course Dates Days Venue Price Booking
Tue/Wed 17-18 July 2018 2 £750 Book places
Course Date(s) Venue
17/07

All prices exclude VAT. If you can't see the dates you want, don't forget that you always have the option of arranging onsite Access training at your offices (we'll even provide the computers and projector).

About our Access training

It makes us sad that less people are booking Access training courses, because we've still got a soft spot for this versatile and powerful application.  We've built many Access databases for clients in the past, and still use Access for (among other systems) the following areas of our business:

System Notes
Accounts Our bespoke accounts system uses an Access front end to get at data stored in SQL Server.
Expenses Although we're in the process of creating a web front-end to our expenses system, at the moment it runs exclusively in Access.
CMS Our website content management system uses an Access front-end, although the underlying tables are stored in SQL Server.

We're not sure why Access is falling out of corporate favour - book a course with us to fight the power of IT departments, who want to control everything centrally!

Other Microsoft Access training resources

Microsoft Access exercises

Try our Access exercises

You can have a look at any of our Access exercises online:

Microsoft Access courseware

Access courseware manuals

To help you decide if Wise Owl is the Access training company for you (!), you can download one of our Access courseware chapters:

Microsoft Access blogs

Blogs on Access

Here are the blogs we've written on things to with Microsoft Access:

Microsoft Access skills assessment

Test your Access skills

See how well you know MS Access by doing one of these tests:

Microsoft Access training venues

Access training venues

Microsoft Access consultancy

Access consultancy

We pride ourselves on create Access databases which are easy to use, but we're really just geeks at heart, as our consultancy service shows:

This page has 0 threads Add post