Microsoft Access is a powerful visual tool with which to design and develop Windows based database applications. During this course attendees will learn key database design concepts and work to build a robust database system. Exercises develop an expanding database application which is used to integrate Access forms, tables, reports and queries into a complete data entry and reporting solution.
Attendees will learn about data normalisation a key component to building scalable and robust database systems and fundamental to advancing from spreadsheet and flat-file style data models.
The course covers automation in Access using the VBA programming language and teaches the fundamentals of programming using Visual BASIC in the Access environment.
To understand data modelling principles and the ideas behind data normalisation. To understand the different relationship types possible between tables.
To be able to build queries and understand basic SQL syntax. To be able to create a form and programmatically control common data controls. To work with reports and sub-reports. To use events triggered by users to automate forms and connect events.
Existing Access users wishing to advance their knowledge of Access and VBA programming. Knowledge of Access Level 1 Access course or equivalent is assumed.
