During this course you will improve and customise tables, queries, forms, reports and share Access data with other applications.
This course provides the fundamental knowledge and techniques needed to use more complex Microsoft Access features such as maintaining databases and using programming techniques that enhance Access applications.
By actively participating in this course, you will learn about the following:
Build a database by constructing tables and table relationships.
Creating queries to search and interrogate your data.
Create forms to ease data entry, and reports to output your information.
Export information to be able to view or analyse in different formats.
To ensure your success, we recommend that you first attend our Introductory Course MSACL1 - Microsoft Access Level 1 course or have equivalent knowledge and skills.
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
Reports
Lookup tables
Input masks
Relationships
Joins
Exporting
Printing