Access 2021 Advanced

Are you already familiar with the basics of Microsoft Access and eager to delve into more advanced concepts and features? Look no further! Welcome to our comprehensive training course, Microsoft Access 2021 Advanced, specifically designed for individuals like you who want to expand their expertise and maximize the potential of this powerful database application.

Building upon your current foundation with Microsoft Access, this course takes your database management skills to new heights, enabling you to tackle complex data challenges with confidence and efficiency.

Our training program is tailored to meet the needs of intermediate and advanced users who seek to master the intricacies of Access 2021. Whether you are a seasoned data professional, a database administrator, a software developer, or an aspiring power user, this course will equip you with the skills and knowledge necessary to harness the full potential of Microsoft’s advanced database management techniques.

Throughout the course, you will embark on an immersive learning journey, exploring a wide range of advanced topics. We will guide you through mastering complex queries, optimizing database performance, writing SQL code, developing macros, leveraging advanced forms and reports, and integrating Access with other applications and data sources.

Whether you aspire to become a database expert, advance your career, or enhance your problem-solving abilities, this course will meet you at your skill level and provide the necessary guidance to become proficient in Microsoft Access 2021. Our goal is to empower you with the skills and knowledge to tackle complex data challenges, optimize performance, and leverage

In this course, you will learn how to:

• Create primary keys
• Understand indexing rules and guidelines
• Set up the sample ‘Northwind’ database
• Work efficiently in datasheet view
• Customize datasheet view
• Apply advanced sorting and filtering techniques
• Create sub-datasheets
• Link to tables in other Access databases
• Install and set up SQL Server Express
• Split an Access database into front end and back end
• Convert tables to local tables
• Address multi-user issues when sharing database files
• Work through the basics of macros
• Modify the AutoExec macro
• Understand macro events
• Adjust macro security settings
• Handle macro errors
• Customize the quick access toolbar
• Convert macros to VBA code
• Write and run VBA code
• Understand VBA error handling
• Create modules, subs, functions, IntelliSense, and variables
• Name variables and strings
• Work with standard functions
• Add events to a database
• Create switchboards and navigation forms.
• Format bound and control forms
• Split forms
• Create tabbed forms
• Adjust combo-box properties
• Build advanced queries
• Write and modify SQL statements
• Understand joins and join types
• Work with action queries
• Create subqueries
• Protect the database and VBA code.

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!