Skip to main content

Overview

CRN Code:

22223

Start date:

04/12/2019

End date:

05/12/2019

Attendance:

Wednesday and Thursday, 9:30am-5:00pm

Campus:

Chadstone

Price:

$490

This course combines Microsoft Access Level - 1 and 2 and will teach you the foundations of designing and managing, flexible and versatile databases. Whether you're using a predefined database template or building a database from scratch, this course will cover the steps involved when constructing or modifying databases for custom purposes, as well as working with tables, forms, queries, macros, data validation, password protection as well as reports and charts for record keeping and analysis. Exercise files are included.


Requirements

    • Pen and notebook
    • USB memory stick (2GB minimum)
    • There are no prerequisites for this course

Outcomes

    • Understand how Access is used and how to navigate around it
    • Design a database with lookup tables. Create a database structure
    • 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
    • Use various data validation features to protect data. Format the data in a table
    • Perform more advanced queries using a variety of querying techniques
    • Create and use parameter queries. Create calculated queries
    • Modify and adapt an existing form according to specific needs
    • Create a navigation form for a database. Create forms using a combination of wizards and manual techniques
    • Create and use macros. Work with a number of macro techniques
    • Create and work with macros in forms
    • Create and manage custom categories and groups in the Navigation Pane

Enquire Now

Contact details

All information is correct at the time of printing but subject to change.

Copyright © 2019 Holmesglen CRICOS Provider Code: 00012G RTO-0416 ABN: 40 096 756 729