Customised computer training in Microsoft, Adobe and other Software

Microsoft Access Training Courses

Microsoft Access is a relational database tool used primarily for information management.

Access stores data in related tables, and through the use of queries, forms and reports, provides users with the ability to bring a lot of information together quickly.

Stored data can be referenced, analysed and reported upon using several tools.

Keystroke Learning’s Microsoft Access courses can take you from beginner to advanced levels.

If you have never used Access before, you will gain a solid understanding of the fundamentals. More advanced users can learn to capitalise on the extensive capabilities of Microsoft Access.

A team of highly skilled and qualified trainers lead our Microsoft Access courses.  Hands-on Full Day, Half Day, Workshop and Live Online Training courses provide flexible delivery options and provide you with practical experience including useful tips and tricks.

We will be happy to organise 1 on 1 or group bookings if you require on dates that suit you. Courses can also be customised for your team.

Based in Melbourne, Australia, we provide in-house Microsoft Access training nationwide. Training can also be delivered virtually anywhere on the planet using our Live Online Training courses.

Microsoft Access Training Courses

Microsoft Access Training courses covering 2007, 2010, 2013, 2016 and previous versions
Microsoft Access Training courses covering 2007, 2010, 2013, 2016 and previous versions

Which Microsoft Access training courses would you like to find more about?

DESCRIPTIONDURATIONSKILL LEVEL
Access Introduction2 DayBeginner
Access Advanced2 DayIntermediate/Advanced

Microsoft Access FAQ

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 involves 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 choose Keystroke Learning?

We Know What Works – Hands-on fully interactive training courses are our bread and butter. Years of real world experience and feedback from our participants have shown us that this type of training produces the best results.
We Listen – By gaining a better understanding of your needs and listening to your feedback we can be sure the training is right for your abilities and goals.
We Innovate – We keep abreast of changing technologies and are constantly developing new courses and updating existing courses to reflect current best practices.

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.

Where are you based?

Keystroke Learning is based in Melbourne, Australia. Most of our training courses take place in the Melbourne CBD, but we also provide Microsoft Access in-house training nationwide.

Do you provide online training?

You bet, our Live Online Training courses can be delivered virtually anywhere around the world. Whether your employees are based in one location or various locations we can deliver live online training to them anywhere they have internet access.

What if I need help after my course?

Every course we run comes with post course support, just email us at support@keystrokelearning.com.au or use our support page.

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.

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.

How do I book a course?

You can fill in your details on our booking form but the easiest way is to give us a call on (03) 9999 7780 and let us take care of all the hard work.

What if I want to customise a course?

If an Off the Shelf solution is not quite what you are looking for, training courses can be tailored to the unique requirements of your team. Our 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 about the best way to structure your customised training course.

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.

What’s included in the course.

You’ll find there is quite a lot included in your course. All Keystroke Learning courses come with a USB Pen loaded with your course manual and exercise files, along with a notepad so you can scribble down all those handy shortcuts.

Our Training Blog

For regular tips and tricks, updates and more visit our training blog.

Enquire Now

Fill in your details and we will contact you to discuss your training needs.

Other Ways To Get In Touch

You can also email info@keystrokelearning.com.au
Or call us on (03) 9999-7780

Request a
Call back


Contact
Us


(03) 9999-7780
info@keystrokelearning.com.au
8 Arthur St, Caulfield North,
VIC, 3161
     

Business
Hours


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

Saturday – Sunday:
Closed