Microsoft Access 2019 – Advanced
Participants will further build their knowledge on Access 2019 in the course of Microsoft Access 2019 – Advanced.
Participants will be able to perform complex queries, design forms and reports, import and export data, and handle database security effectively.
Upon completion of this course, you will optimize an Access 2019 database.
- Create control properties to validate and promote quality data entry into a database.
- Organize a database for efficiency and performance, and to maintain data integrity by enforcing Table Referential Integrity
- Create advanced queries such as multiple table query, work with Expression and Expression tables, summarizing group of records and use of IIF functions
- Use advanced formatting and controls to improve form presentation. Learn to use subforms.
- Use advanced formatting and calculated fields to improve reports.