(03) 9999 7780

Call For Queries?

Training Centre

View on Map

Keystroke Learning - Main Menu

(03) 9999 7780

Call For Queries?

Keystroke Learning - Main Menu

Microsoft Access Training Courses

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.
Keystroke Learning - Want training on your site? We travel to you

Want training on your site?
We travel to you

Want training on your site?
We travel to you

Training delivered right to your office on a day that works best for your team.
Keystroke Learning - Get fully interactive hands-on experience

Interactive hands-on experience

Get fully interactive hands-on experience

Professional instruction, lots of practice time, and solutions for your Access concerns.
Keystroke Learning - We have everything you need to succeed

We have everything you need to succeed

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 our computers

No Computer? No problem, use our computers

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

Microsoft Access Introduction

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

Microsoft 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.
Keystroke Learning - Microsoft Access Training Course

Microsoft Access 
Introduction

Microsoft Access Introduction

Microsoft Access Computer Training Course

Course 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.

Course Details

Course Skill Level

Introduction

Class Size

10 Students (max)

Course Duration

2 Day Training Course

Class Times

9:00am -4:00pm

Price

$960+GST

Upcoming Public Courses

There are no upcoming courses 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.

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
custom computer training options

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.

Keystroke Learning - Microsoft Access Training Course

Microsoft Access 
Advanced

Microsoft Access Advanced

Microsoft Access Computer Training Course

Course 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.

Course Details

Course Skill Level

Advanced

Class Size

10 Students (max)

Course Duration

2 Day Training Course

Class Times

9:00am -4:00pm

Price

$960+GST

Upcoming Public Courses

There are no upcoming courses 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.

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
Microsoft Access FAQ's
Frequently Asked Questions

Microsoft Access FAQ's

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.

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.

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.

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.

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.

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.

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

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.

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 - Building Computer Skills to Enable Success

Learn 
Today
Face to Face
Online
 with Keystroke Learning

Learn with Keystroke Learning

Our training approach is professional yet friendly, motivating participants to learn quickly and easily. 

When you complete our training course, you will be ready to apply your new skills right away. 

If you have a customised training solution in mind or need to schedule our popular computer courses

call (03) 9999 7780 or email us @ [email protected]

Melbourne Training Venue

Level 2 / 52 Albert Rd
South Melbourne, VIC, 3205

Venue Access Hours

Monday – Friday 8:30am – 5:00pm

Are you Running Late???

Keystroke Learning - Building Computer Skills to Enable Success