Auldhouse Anywhere

Auldhouse Anywhere

Our range of Auldhouse Anywhere courses enable you to join live classroom training online – saving you time and money on travel.

Find out More
E-Learning

E-Learning

Discover the benefits of taking a course online at your own pace.

Find out More
Webinars

Webinars

Auldhouse deliver a number of vendor specific webinars. Webinars give you an effective training option with the freedom to attend from virtually anywhere.

Find out More

Microsoft Access - Creating Relational Databases

Code:
ACSL2
Days:
1 Day
Price:
$450 excl GST
Code:
ACSL2
Days:
1 Day
Price:
$450 excl GST
Overview:
Expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports.
Download Course Outline
Course Outline (PDF)

Objectives:

After completing this course, students will be able to:

  • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Validate data entered into a database.
  • Use advanced queries to manipulate your data.
  • Organise a database for efficiency and performance, and to maintain data integrity.
  • Customise reports to organise the displayed information and produce specific print layouts.

Prerequisites:

To ensure your success, it is recommended you have completed the Microsoft Access 2016 Essentials course or have equivalent knowledge. It is also suggested that you have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

Register now for this course

Please take special note of the course prerequisites as it is important that you meet these requirements before attending the course. If you have any questions about dates or locations please dont hesitate to make an enquiry contact us on 0800 835 835.

Wellington

No classes currently scheduled in your location?Enquire about this course

Interested in a private class? Enquire about a private class