Expand your Microsoft® Access® database expertise and create more sophisticated, functional databases. Building on your foundational knowledge of tables, forms, reports, and queries, this course develops your understanding of relational database architecture, teaches advanced query writing, improves data organization, enables data sharing across multiple applications, and develops custom reporting capabilities. Strengthening your Access proficiency will result in powerful, efficient databases that serve your organization's needs effectively.
This course also prepares you for the Microsoft Office Specialist (MOS) certification exams for Microsoft Access, validating your professional-level database skills.
Software Version Information:
This course is designed for users of Access 365, 2019, or 2016, and instruction uses Access 2019 software. Differences between versions 365 and 2019 are minimal from an end-user perspective. Our instructors have extensive experience across all versions and can quickly clarify the few interface variations. Regardless of which Access version you use, you will learn effectively in the 2019 environment.
Course Objectives:
This intermediate course serves students seeking to develop intermediate-level database skills and professionals whose roles involve designing relational databases, performing database maintenance tasks, constructing advanced queries and custom reports, or integrating Access with other business applications.
Required Prerequisites:
To ensure your success and understanding of course content, completion of the Access Introduction Course or equivalent foundational knowledge is strongly recommended.