Microsoft Access for Office 365: Part 2

Your training and experience using Microsoft® Access® has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. 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 Specialization that covers the skills needed to perform database design and development in Access. 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. This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Microsoft 365. In this course, 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; and use advanced formatting and calculated fields to improve reports. This course requires that you have Microsoft Access installed on a Windows PC. The course setup instructions provided in the first module of the course go into more detail about the hardware and software requirements.