Microsoft Access Training when you need it
Want training on your site?
We travel to you
Want training on your site?
We travel to you
Interactive hands-on experience
Get fully interactive hands-on experience
We have everything you need to succeed
We have everything you need to succeed
No Computer? No problem, use our computers
No Computer? No problem, use our computers
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
Microsoft Access Introduction
Microsoft Access Introduction
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
Introduction
10 Students (max)
2 Day Training Course
9:00am -4:00pm
$960+GST
Upcoming Public Courses
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
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 Advanced
Microsoft Access Advanced
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
Advanced
10 Students (max)
2 Day Training Course
9:00am -4:00pm
$960+GST
Upcoming Public Courses
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
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
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.
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]
