In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users. This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access. Microsoft Access for Office 365: Part 2 (this course): Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports. This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam.
* Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Learning Objectives
In this course, you will optimize an Access database. You will:
Provide input validation features to promote the entry of quality data into a database.
Organize a database for efficiency and performance, and to maintain data integrity.
Improve the usability of Access tables.
Create advanced queries to join and summarize data.
Use advanced formatting and controls to improve form presentation.
Use advanced formatting and calculated fields to improve reports.
$295
Length: 1.0 day (8 hours)
Level:
Course Schedule:
5:00 PM ET
5:00 PM ET
4:00 PM PT
5:00 PM ET
5:00 PM ET