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 Complex Databases

Code:
ACSL3
Days:
1 Day
Price:
$450 excl GST
Code:
ACSL3
Days:
1 Day
Price:
$450 excl GST
Overview:
This course is suited to database administrators or prospective database administrators who have experience working with Access and need to learn advanced skills.
Download Course Outline
Course Outline (PDF)

Objectives:

After completing this course, students will be able to:

  • Customise a form layout to improve usability and efficiency of data entry.
  • Share data across applications.
  • Use macros to improve user interface design.
  • Use VBA to enhance tasks.
  • Organise data into appropriate tables to ensure data dependency and minimize redundancy.
  • Lock down and prepare a database for distribution to multiple users.
  • Create and modify a database switchboard and set the startup options.

Prerequisites:

To ensure your success it is recommended you have completed the Microsoft Access 2016 Creating Relational Databases course or have experience working with Microsoft Access 2016, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships.

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.

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

Interested in a private class? Enquire about a private class