Access 2019 Advanced

Welcome to “Microsoft Access 2019 Advanced,” where you’ll delve into the intricacies of this powerful database management tool. This course provides a comprehensive understanding of Access, introducing its features and a deep dive into primary keys and indexes. You will explore the Datasheet View, learn to set up our database file, customize views, and implement advanced sorting and filtering techniques.

As you progress, we’ll guide you through linking tables to other Access databases, using ODBC and SQL Server, and splitting databases into front-end and back-end components to address multi-user issues. Delve into macros, customize ribbons, and harness the potential of Visual Basic for Applications (VBA) for enhanced automation and functionality. We’ll also cover the Access Events Model, form creation, and advanced queries, including action queries.

By the end of the course, you should master the art of packaging your Access applications for seamless deployment. Practical exercises throughout each section ensure hands-on application of concepts. Whether you’re looking to boost your professional skills or enhance your database management capabilities, this Microsoft Access 2019 Advanced course can equip you with the knowledge and skills needed for efficient database design and management. Join us on this journey to become an Access expert.

In this course, students will learn how to:

• Understand Primary Keys and Indexes for effective database organization.
• Customize and filter in Datasheet View for data presentation precision.
• Establish database links for seamless data sharing across multiple sources.
• Utilize ODBC and SQL Server to enhance database connectivity and functionality.
• Master the process of splitting Access databases into front-end and back-end components.
• Explore Macros, including AutoExec, for automated task execution in Access.
• Apply basic VBA skills, covering coding and error handling in Access.
• Implement advanced form creation techniques to enhance user interface design.
• Execute advanced queries with a focus on “multiple where” criteria for data retrieval.

WHAT YOU GET

Certificate of Completion

• Earn a certificate each time you complete a course.
• Showcase your commitment to continuous growth and professional development.
• Impress potential employers.
• Enhance your professional profile.
• Available in PDF format to Download or Print.

INSTRUCTOR

Deborah Ashby

Meet Deb, your go-to guide in the exciting world of Excel and beyond! With her infectious enthusiasm and razor-sharp expertise, she's on a quest to turn everyone into Excel wizards. Deb doesn't just stop at Excel, though. She'll lead you through the fascinating realms of Microsoft Word, PowerPoint, and other Microsoft 365 apps, helping businesses and individuals alike to unlock their full potential. But she's no ordinary trainer. Boasting an impressive track record of over 25 years and revered by past and current learners alike, Deb's teaching prowess is unparalleled. To top it off, she's a proud recipient of the coveted Microsoft MVP (Most Valuable Professional) award. Buckle up and join Deb on this exhilarating learning journey!