This database management certification builds upon our Foundations of Microsoft Access certificate to take your skills with Access to an advanced level. In this program, you will deepen your understanding of relational database concepts and learn to leverage the more complex functions of Access. This includes creating advanced queries, form controls, and custom reporting. By the end of this certification, you will be capable of optimizing databases for performance, maintaining data integrity, and developing powerful data-driven applications in Access.
Who Should Take This Certification?
Microsoft Access is essential for those aiming to excel in database management, especially those working as or seeking to work as Database Administrators, Data Analysts, and Office Administrators. Earning this certificate proves your expertise in designing databases, managing key components like tables and relationships, and conducting sophisticated operations with multi-table queries. It also covers skills in creating user-friendly data entry forms and comprehensive reports. These capabilities apply to any professional environment, enabling you to handle data proficiently and support informed decision-making within your organization. Employees and job seekers looking to improve data management skills should consider this certificate.
Workplace Skills
- Advanced-Data Analysis and Reporting: Learn to use Access for more sophisticated data analysis and how to use more complex data to create professional reports. .
- Relational Database Design: Learn =to design relational databases, including table relationships and integrity constraints, to connect your databases together and ensure that decisions are made based on accurate, relevant data.
- Form Design for Data Entry: Master the design of intuitive forms with advanced controls to create a straightforward, efficient process for the end users of those forms.
- Understanding Relationships: Understand how to establish relationships between tables to ensure your datasets correctly interact and surface connections between appropriate data points. This skill helps with creating advanced database functionalities and automating some data-handling tasks.
Requirements
This certification includes a series of progressive courses: Advanced Applications of Access and Advanced Topics in Access Database Design. Completing this two-course sequence will result in issuing this certification and the accompanying badge, which may be displayed in your email signature and on LinkedIn. Note that each Access course meets for two subsequent days.
Schedule
Courses are held monthly and may be taken online synchronously or in person at our training center in Des Peres, St. Louis County, Missouri. Employers and job centers may also request training held at an offsite location. Please contact info@cetc.umsl.edu for further information.
For More Information
For more information and registration details, please visit the dedicated course area on our website or contact our support team at info@cetc.umsl.edu.