Microsoft Access Training Course

Microsoft Access Training when you need it

Microsoft Access is a flexible database application that is used to store information for reference, reporting, and analysis purposes. Microsoft Access can help you analyse large amounts of information, and it manages related data more efficiently than Microsoft Excel or other applications.

Spreadsheets like Microsoft Excel are great for working with and calculating small sets of information, but they are not ideal for handling thousands of records for customers, contacts, or other items you need to track. This is where Microsoft Access comes in, making it easy to analyse and report on your data.

Discuss your needs. (03) 9999 7780

Want training on your site? We travel to you.

Training delivered right to your office on a day that works best for your team.

Get fully interactive, hands-on experience.

Professional instruction, lots of practice time, and solutions for your Access concerns.

We have everything you need to succeed.

Fill out our free assessment and we will determine the right course content for your team.

No Computer?
No problem, use ours.

If you’re short on computers, we will gladly supply a laptop for each person.

Custom Computer Training Course- Build Your Own Course

Build your own custom course

Any of our courses can be tailored to the unique requirements of your team. Our Off the Shelf courses are modularised with this option in mind, which means that you could mix and match from a selection of existing topics, or we can work with you to develop something specific to your organisation. Either way, we are on hand for advice on the best way to structure your customised training course.

To help you with your customised option, you can choose from our extensive list of course topics. We can then help you to assign the appropriate amount of content based on your training timeframe, and the best order of topics to ensure your training flows well. Our aim is to help every participant gain valuable knowledge and skills.

microsoft access training

Standard 2 Day Access Courses

Comprehensive training manual with exercise files. Lifetime post-course support.
Pricing
 from: $960 / per participant. 

Access Introduction

Discover the fundamental principles of Microsoft Access Databases. This includes relational database design principles, navigating Access and creating Tables, Forms, Queries, and Reports.

Access Advanced

Review your knowledge of database design principles and Relationships, before moving on to advanced tools such as Parameter Queries and Custom Forms and Reports.

Microsoft Access Introduction

Overview

Participants in this Microsoft Access Introduction 2 day course will gain an understanding of the fundamental principles of Access, including relational database design principles, navigating Access and creating Tables, Forms, Queries, and Reports. You will be given a solid foundation of skills upon which to build.

The course assumes no prior knowledge of Access, however, people with limited exposure to the software or if you are using databases built by others you will also benefit from this course.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

The instructor was great and happy to answer questions. Very insightful course and learnt heaps.

F. Taylor

Upcoming Courses

There are no upcoming events at this time.

However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants to run the course.

Course Details

  • Skill Level: Beginner
  • Duration: Two Day
  • Time: 9am-4pm (approx)
  • Class Size: 10 Students (max)
ratings 4.7

Course Instructors

Course Content

Access Orientation

  • Exploring the Access Interface
  • Understanding Database Design
  • Planning a Database

Setting up Tables and Entering Data

  • Creating Tables
  • Setting up Fields
  • Saving Tables

Importing and Linking Data

  • Importing from Access
  • Importing from other Sources

Working with Tables

  • Copying Tables
  • Appending Data

Relationships

  • Understanding Relationships
  • Setting up Table Relationships
  • Modifying Relationships

Forms

  • Understanding Forms
  • Building Forms with the Wizard
  • Types of Forms

Queries

  • Setting up Queries
  • Single Table Queries
  • Multi Table Queries
  • Query Properties

Reports

  • Creating Reports
  • Modifying Reports

Options

  • Setting Database Startup Options

Microsoft Access Advanced

Overview

Participants on this Microsoft Access Advanced 2 day course will build on their existing knowledge and skills using Access. You will review database design principles and Relationships, before moving on to advanced tools such as Parameter Queries and Custom Forms and Reports.

The course assumes you have a solid working knowledge of Access, those needing to extend their database skills will benefit from this course.

Call us on (03) 9999 7780 to discuss your invoice requirements, such as a Purchase Order Number or information about our Public Liability and Professional Indemnity insurance.

Reviews

Mark walked us through the course thoroughly, provided us with useful, practical Access tips to use. He gave us lots of opportunities to ask questions and for clarification. The small group setting was suitable and conducive for learning.

D. Choo

Upcoming Courses

There are no upcoming events at this time.

However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants to run the course.

Course Details

  • Skill Level: Inter / Advanced
  • Duration: Two Day
  • Time: 9am-4pm (approx)
  • Class Size: 10 Students (max)
ratings 4.8

Course Instructors

Course Content

Review of Relationships

  • Exploring Database Relationships

Parameter Queries

  • Setting up Flexible Queries
  • Modifying Parameter Queries

Using Query by Form

  • Designing a Query by Form
  • Setting up the Form Properties

Setting up Action Queries

  • Understanding Action Queries
  • Designing Action Queries
  • Delete Queries
  • Update Queries
  • Make Table Queries
  • Append Queries

Customising Reports

  • Creating Custom Fields
  • Report Layout Options

Customising Forms

  • Building Custom Forms
  • Adding Form Fields
  • Adding Controls to a Form

Using Expressions in Forms

  • Working with Expressions
  • Using Calculations

Macros

  • Building Macros
  • Using the Macro Builder

Frequently Asked Questions

What is Access?

Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis.  Microsoft Access helps you to analyse large amounts of information, and to manage related data. It is more efficient at these tasks than Microsoft Excel or other spreadsheet applications. This is because spreadsheets are not ideal for handling thousands of records where you need to have a single source of truth for something like a customer, a contact, or an item you need to track.  It can be easy to introduce errors into a spreadsheet, making the analysis and reporting extremely difficult to do with any degree of accuracy.

Users can import documents from other Microsoft Office applications such as Microsoft Excel into Access. Databases can be built by selecting from the available templates or starting from a blank database.

Who uses Microsoft Access?

Access has a variety of features for different database needs. It can be used to develop several types of applications. These include the following:

  • Customer Information applications
  • Small business applications
  • Marketing and Sales applications
  • Financial Tracking applications
  • Front-end interface for SQL etc
  • Web applications

These are just some of the areas where Microsoft Access can be used, and it can cover just about any kind of database application.
The main components of a Microsoft Access database are:

  • Tables
  • Queries
  • Forms
  • Reports
  • Macros

These elements are combined to store your business data and allow in-depth analysis. For example, tables are used to store your data, queries to find information, forms are for data input, reports for output and macros are used to automate database tasks.

Should I buy a Microsoft Access for Dummies book or attend a Training Course?

Have you ever wondered why the Dummies books are so popular? Well, it’s probably because so many of us are self-taught, using Google to find out how to use a function, or we are shown how to use software by someone at work. Although this can be useful, it also means we tend to spend a lot of time with trial and error, or we are just picking up somebody else’s bad habits. Trial and error, unfortunately, involve a lot of error, and the bad habits you pick up will probably be passed on to the next person, so soon they spread across the business, meaning entire teams can end up working inefficiently.

At this point, you might head to the bookstore or do an online search to find a Microsoft Access for Dummies book to help solve some of those tricky issues. That’s a step in the right direction, and we sometimes use reference manuals ourselves. The problem is that it still takes time to find the information you need.

Our Microsoft Access courses are designed to target the key features and tools included in the applications to help you get back to work and apply them right away.

Why should I attend an Access Training Course?

A training course with Keystroke Learning can set you up to take full advantage of your software. We want Microsoft Access to work for you, not the other way around. We also make a point of passing on the best of our knowledge and experience to help you save time in your daily work. We know lots of shortcuts for your software applications, and we want you to know them as well.

Typically, one of our experienced trainers will walk you through the features and functions of the software, then you will try them out on your own, with tips and guidance on getting the best out of the features. We also encourage participants to ask lots of questions to help you get the most out of your learning experience.

You’ll receive a manual to take away at the end of the course, as well as exercise files so you can practice later, or just to jog your memory when you need.

Can I use my Excel data in Access?

Absolutely, in fact, there are lots of times when it is advantageous to use Excel and Access together. There are several ways to get your Excel data across into Microsoft Access. You can copy an Excel spreadsheet into a table. You can also link a table directly to a spreadsheet. If you prefer, you can import your Excel data into Access.

Keep in mind that this functionality also works in reverse.  In other words, you can connect to your Microsoft Access data from Excel.

Do I need to write code to get Access to work for me?

Definitely not! One of the nice things about Microsoft Access is that you can build a fully functional relational database without the need for code. Years ago, database building was very much the domain of professional programmers, but Access helped to open database design to mere mortals like you and me.

It is still necessary to have some understanding of the fundamentals of good database design so that you can build a database that is properly suited to your purpose, but you certainly don’t need to be a programmer.

Where to from here?

Your learning doesn’t stop once you have completed your course. We hope you will continue your experience by taking some time to practice what you have learned and apply it to your own situation and environment.

If we have done our job well, you may be inspired to learn even more by attending another course. If you are looking for something other than Microsoft Access, we have a comprehensive range of courses available for you to choose from.

We are here to help, so please don’t hesitate to contact us if you need any further advice.

Why use Access instead of Excel?

Great question. There are some important differences to consider. Excel is fantastic for presenting your data using rich graphical tools such as charts, sparklines, conditional formatting etc. It’s also extremely good at analysing your data.

Where Excel is not so good is in the storing and organisation of large sets of data. You will generally find that your spreadsheets become slow and inefficient when you get to 100,000 rows of data, and there tends to be repetition in your worksheets. This is usually unavoidable due to the structure of an Excel spreadsheet.

On the other hand, Microsoft Access is excellent for storing much larger sets of data. Because data is stored in multiple tables, which are related, you can avoid most of the repetition you see in a spreadsheet. The tools available in a database make sorting and searching your data much faster. Access can combine data from multiple tables and highlight relationships that you may not have been aware of.

Simply stated, Microsoft Access helps you analyse large amounts of information, and manage related data more efficiently than Microsoft Excel or other spreadsheet applications.

Don’t forget that it’s not always a case of using one or the other, you can use both Access and Excel together and take advantage of the strengths that each application has to offer.

Does Microsoft Access have some templates to get me started?

Yes, Access comes with several templates. These can save you lots of time when you are starting out. You might find a template that suits your requirements precisely, but it’s more likely you will need to modify a template to fit. That can be a simple task. You can also download templates from the Microsoft Access website if you need something more.

Access also comes with a sample database called Northwind. The nice thing about this is that by delving into the back end of the database you can learn a lot about how they work. You can also use parts of the database in your own applications if you need to.

Keystroke Learning

Learn Today with Keystroke Learning

As you can see, we have a wide array of top computer courses. Out training approach is professional yet friendly, motivating participants to learn quickly and easily. When you complete our training, you will be ready to apply your new skills right away. Course prices are listed on the Upcoming Courses page alongside the relevant course.

If you have a customised training solution in mind, please call us for a quote.

To schedule our popular computer courses, call (03) 9999 7780 or email us @ [email protected]