The skills and knowledge acquired in Microsoft Access Level 3 are sufficient to automate operations using macros, secure and protect data, and have a general understanding of the programming environment in Microsoft Access. Course Content Relational database design: Designing a relational database; Scoping the system; Determining the inputs; Normalising a database; First normal form (1nf); Second normal form; Second normal form – case study; Third normal form (3nf); Database indexin... [More]

The skills and knowledge acquired in Microsoft Access Level 1 are sufficient to create robust relational database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data Course Content Access orientation: Understanding Microsoft Access; Starting Access; Understanding the getting started screen; Opening an existing database file; Understanding the access screen; Working with the navigation pane; Working with a ... [More]

The aim of this course is to build on the introductory skills of Level 1. You will learn how to ensure that data is entered correctly, how to create more sophisticated and complex queries and will be introduced to some basic automation techniques involving macros. Course Content Data validation: Assigning default values; Validation rules and text; Validating numbers; Setting required fields; Working with validations Querying techniques: Modifying a saved query; Creating and queries;... [More]