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