Centre for Continuing Education

Microsoft Access Course: Level 1

Microsoft Access. Create databases fast without being a developer.

Coronavirus (COVID-19) update: arrangement of our courses

Our courses will be moving to online delivery from Monday 23 March.
We aim to continue to deliver a high-quality educational experience through interactive, online classes in real-time.
If you are currently enrolled in a course with us, we will be in touch soon with options for your enrolment.
Please familiarise yourself with our terms and conditions which have been updated with amendments in response to COVID-19.


This Microsoft Access training course will provide you with the skills and knowledge sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.


By the end of this course, you should be able to:

  • understand how Access is used and how to navigate around it
  • design a database with lookup tables
  • create a database structure using Access
  • modify the structure of an existing table
  • add records to a new table
  • add transactional records to a lookup database
  • work with the records in a database table
  • sort and filter records in a table
  • create simple and effective queries
  • create meaningful reports from tables
  • create and use forms
  • perform more advanced queries using a variety of querying techniques
  • modify and adapt an existing form according to specific needs
  • create a relational database file with multiple tables
  • set table relationships and join tables together
  • create queries based on one or more tables
  • export records to and import records from a wide variety of sources and applications.


Microsoft Access orientation

  • Understanding Microsoft Access
  • Starting access
  • Understanding the start screen
  • Creating a new blank database
  • Understanding the backstage view
  • Opening an existing database file
  • Understanding the access screen
  • Using the ribbon
  • Working with the navigation pane
  • Adding commands to the QAT
  • Working with touch mode
  • Working with a table
  • Working with other database objects
  • Closing a database file
  • Exiting from access

Designing a lookup database

  • Understanding how access stores data
  • Understanding access data types
  • Scoping your new database
  • Identifying table problems
  • Refining table structures
  • Finalising the design

Creating a lookup database

  • Creating a new database file
  • Creating the lookup table
  • Defining the primary key
  • Saving and closing a table
  • Creating the transaction table
  • Understanding lookup table relationships
  • Connecting to a lookup table
  • Viewing table relationships

Modifying table structures

  • Opening an existing table
  • Adding fields to an existing table
  • Understanding field properties
  • Changing field size
  • Changing field names
  • Changing decimal places
  • Changing date formats
  • Indexing fields
  • Deleting fields from a table
  • Copying a table within a database
  • Deleting a table from a database file

Adding records to a table

  • Typing records in a table
  • Adding records using a form
  • Saving a form layout for reuse
  • Adding records using an existing form
  • Adding additional records

*Importing from Microsoft Excel

Adding transactional records

  • Typing transactional records
  • Adding transactional records using a form
  • Adding records using a subdatasheet
  • Removing a subdatasheet
  • Inserting a subdatasheet

Working with records

  • Table navigation
  • Navigating to a specific record
  • Editing a record
  • Deleting record data
  • Undoing a change
  • Deleting a record
  • Deleting several records
  • Searching in a table
  • Searching in a field
  • Finding and replacing
  • Printing records from a table
  • Compacting a database

Sorting and filtering

  • Simple sorting
  • Sorting on several fields
  • Simple filtering
  • Working with filters
  • Filtering between dates

Creating queries

  • Understanding queries
  • Creating a query design
  • Working with a query
  • Changing a query design
  • Applying record criteria
  • Clearing selection criteria
  • Saving a query
  • Running queries from the navigation pane
  • Deleting a query
  • Assignment: creating queries

Creating and using reports

  • Understanding reporting in access
  • Creating a basic report
  • Working with existing reports
  • Previewing and printing a report
  • Changing the report layout
  • Using the report wizard
  • Creating a grouped report
  • Creating a statistical report
  • Working with grouped reports

Creating and using forms

  • Understanding forms
  • Creating a basic form
  • Creating a split form
  • Binding a form to a query
  • Using the form wizard
  • Working with existing forms
  • Editing records in a form
  • Deleting records through a form
  • Deleting an unwanted form

Querying techniques

  • Modifying a saved query
  • Creating and queries
  • Creating or queries
  • Querying numeric data
  • Querying dates
  • Using a range expression
  • Querying opposite values
  • Moving fields in a query
  • Sorting query data
  • Removing fields from a query
  • Querying using wildcards
  • Problem characters
  • Querying with a lookup table
  • Sorting query data numerically
  • Displaying null values
  • Querying for uniqueness

Modifying forms

  • Understanding form design and layout
  • Switching between form views
  • Selecting form objects
  • Working with a control stack
  • Changing control widths
  • Moving controls on a form
  • Aligning controls
  • Understanding properties
  • Changing label captions
  • Adding an unbound control
  • Adding a control source
  • Formatting a control
  • Checking the current tab order
  • Changing the tab order
  • Inserting the date into the form header

Creating a relational database

  • Creating a new database file
  • Creating lookup tables
  • Defining a primary key
  • Saving and closing a table
  • Creating the expense type table
  • Creating the transactions table
  • Creating the details table

Setting table relationships

  • Understanding table relationships
  • Understanding lookup relationships
  • Looking up the employees table
  • Looking up the expense types table
  • Viewing table relationships
  • Understanding table joins
  • Editing the employee table join
  • Editing the expense type table join
  • Creating a new join
  • Creating a relationship report

Multi table queries

  • Understanding relational queries
  • Creating a relational query design
  • Filtering a relational query
  • Filtering related fields
  • Adding more tables and fields
  • Utilising hidden fields
  • Understanding query joins
  • Creating an inner join
  • Creating a left outer join
  • Creating a right outer join

Importing and exporting records

  • Exporting records to Microsoft Excel
  • Exporting records to a text file
  • Importing from Microsoft Excel
  • Importing from a text file
  • Linking to an external source
  • Challenge exercise
  • Challenge exercise sample

Intended audience

Suitable for beginner’s and assumes little or no knowledge of the software.


You should be familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening files, saving files, familiarity with the accessing the Internet and use of common web browsers. If you do not have these skills, we recommend attending Basic Computer Skills Course and Effective Internet Use before attempting this course.

Delivery style

Delivered as presenter-taught computer-based training in a Microsoft Windows environment.


You will be provided with a link to access and download your own personalised eBook prior to class.

Additional information

Please bring a USB flash drive to class if you would like to make a copy of your work or any relevant class materials. Alternatively, you can save these to a cloud storage space or email them to your personal email address.


  • $50 repeat class - Conditions apply
  • Expert trainer
  • Dedicated computer for every participant
  • Small class size
  • CCE Statement of Completion

Apply for the IT repeat discount.

What others say.

  • Tutor was very capable and engaging, explaining everything very clearly. It went at a good pace and the tutor was always happy to assist when asked. Equipment was good and catering was good too. Thank you.

  • This tutor was very, very, very good at making a dry topic engaging. The communication and subject matter understanding is top notch.

  • This is the third one-day CCE course I’ve done in two years, and I have always gained a huge amount of information that I can use straight away and a great resource book to refer back to.

  • The Tutor was excellent – knowledgeable, skilled and able to impart knowledge in an easy to understand way, and never hurried, always helpful. And by the way, the sandwiches were absolutely top class. Highly recommended.

  • Great session. Tutor was happy to answer all questions. Very useful to go back to the business with this new knowledge.

  • As a mature aged student I approached the course with some trepidation. My fear was geek speak and the acronyms and jargon in IT is without a doubt intimidating to a Luddite like me. But what a surprise. The tutor was articulate in the delivery, treating all as equals and the language was simple plain English. I came away from the course enlightened, relieved and keen to progress to the next level. I would highly recommend this course to anyone and in fact I am enrolling both my son and daughter into this course and I have also enrolled into Level 2 and signed up for Excel Level 1 as my unfounded fear factor has dissipated.

  • I came away from this course feeling confident and inspired in what I had learnt.

  • The course was set at a steady pace for the entire class to keep up. The tutor was engaging and provided thorough explanations.

  • Excellent instructor, great venue, relevant and desired content. Overall, good value. Thank you!

  • The tutor was very clear and concise. I found I could follow the instructions easily and the class went at a good pace.

  • Excellent educator providing clear instructions and explanations which are definitely required for a computing course.

  • This course gave me the knowledge and skills that I need to get started using Microsoft Access, and was well-structured and very well delivered.

  • The course is very time-efficient in that it provides a lot of information in a short time. This is very useful for me as I am busy and have very limited time for doing such courses. Much apprciated.

  • The day was run very well, I felt the course covered all the basic information required. The tutor ran the class really well with all questions answered. the service was very good, thank you.

  • It was a great day with good learning experience. We had an excellent teacher who was very helpful. Although there is always more to learn, in my opinion, the course met expectations. Love the special parking rate of $10.00/day. Will recommend the course to the others.

  • I thoroughly enjoyed this course. The pace, content and the tutor were very enjoyable. Highly recommend the course to anyone.

  • My experience with the University of Sydney Centre for Continuing Education was a very pleasant, informative and great experience overall. I have already recommended this place to family, friends and fellow colleagues.

  • I was feeling a bit nervous about this course as I have had bad experiences with computer courses in the past but the tutor made the course enjoyable and easy to follow.

  • Great presenter. The tutor really went the extra mile to tailor the course to our needs and answer all our specific questions. Thanks so much. Was invaluable. I will be signing up for MS Access Level 2 course!

Microsoft Access Course: Level 1

<p>{block name:“Course Tagline - Microsoft Access”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>{block name:“Course Heading - Aims”}</

Microsoft Access Course: Level 1

<p>{block name:“Course Tagline - Microsoft Access”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>{block name:“Course Heading - Aims”}</

Microsoft Access Course: Level 1

<p>{block name:“Course Tagline - Microsoft Access”}</p><p>{block name:“Course Message - Microsoft and Adobe”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>{block name:“Course Heading - Aims”}</


What others say.

  • I was feeling a bit nervous about this course as I have had bad experiences with computer courses in the past but the tutor made the course enjoyable and easy to follow.
  • Great course - very interesting and informative, and a great tutor! Thank you.
  • I enjoyed the course. The tutor was excellent, having no hesitation with assisting me in the middle of an exercise. After we went through the learning areas there was time to work through some examples. Being supplied with a USB was useful too because it gave me some more data to practise and refine the skills I had learnt today.
We acknowledge the tradition of custodianship and law of the Country on which the University of Sydney campuses stand. We pay our respects to those who have cared and continue to care for the Country.