During this course you create complex Access databases by structuring existing data, writing advanced queries, working with macros and performing database maintenance.
The course is designed for those people whose job responsibilities include working with heavily related tables, creating advanced queries, forms and reports, writing macros to automate common tasks and performing general database maintenance.
By actively participating in this course, you will learn about the following:
Obtain skills in advanced query, form and report design, and manage their databases.
Provide some levels of automation with the use of Macros. Create more complex queries looking at different query types.
Pull data in from other sources to use in your database.
To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is recommended. The following or equivalent knowledge is recommended:
Software Requirements for Virtual Classroom
Delegates will need to have Microsoft Access 2013, 2016, 2019 or 365 (desktop version) installed on their PC to participate in Virtual Classroom courses.
This course is not suitable for MAC users.
Trusted locations and default locations
Queries
Forms
Reports
Macros
Linking Data
Importing Data