Microsoft Access Training

The Office Expert offers basic to advanced Microsoft Access training and lessons in the comfort of your office or in your own private home for the Cairns region of far North QLD, Australia. If you have a database, which you did not build but you need to know how to develop it use, we can help you with that too. Develop your database further with Queries, Reports, interactive functions or even add more Tables. Send us a request for an appointment and we can get you started to managing your own database immediately. Databases can be are complex things if they are built to rely on excessive amounts VBA code. Want us to check out your database? Make sure you have the password for the backend and we can consult with you about it over an appointment. Contact us today or book in a day of training to learn all the basic operations involved in using a database.

Introduction

At this level you will learn how to build a basic Table, Form, Report and Query. You will learn naming conventions, limitations, security and important fail-safe methods so your database is robust and stable. You will learn how to think like a user and will design your objects accordingly.

Read More

Intermediate

You understanding the purpose and importance of linking tables however are unsure of how to do this. You would like to extend your object design knowledge with inclusion of interactive Forms, higher level Queries and be able to customise Report to suit your business.

Read More

Advanced

You would like to control Events; alter Control Sources; filter records, create Parameter, Update and Append Queries; be able to tweak existing Relationships; Effectively use Command Buttons with some VBA validations, messaging and more.

Read More