Access 2019

Welcome to “Microsoft Access 2019 for Beginners,” where you’ll embark on an immersive journey into the world of database management. This course will teach you the essential skills to navigate Access 2019 confidently, empowering you to organize, analyze, and manipulate your data efficiently.

Throughout the course, you’ll explore the fundamental aspects of Access, starting with an introduction to the software and understanding its structure. You’ll discover the power of database templates and gain hands-on experience creating, saving, and opening databases. The course ensures proficiency in using the Access workspace and the backstage area and harnessing online help features, making your learning experience seamless.

As you delve into each section, you’ll grasp key concepts such as designing tables, importing data, and setting up relationships. Hands-on exercises provide practical application, reinforcing your ability to navigate the Datasheet View, create forms, and execute queries. You’ll explore advanced features like expressions, report design, and printing, equipping you with the skills to generate complex reports effortlessly.

Moreover, this course provides in-depth knowledge about forms, queries, and various data types. The course concludes by unraveling additional Access options, including exporting databases, utilizing application parts, and understanding the info tab.

By the end of the course, you should confidently wield Access 2019, applying your newfound skills to efficiently manage databases, create reports, and streamline data-related tasks in your professional or personal endeavors.

In this course, students will learn how to:

• Launch and navigate Microsoft Access and choose between templates.
• Modify Access settings for personalized functionality.
• Explore data importation and utilize datasheet view effectively.
• Understand Access tables and establish relationships between them.
• Construct user-friendly forms and sub-forms for efficient data input.
• Execute Access queries to retrieve specific data sets.
• Apply validations and calculations with expressions in Access.
• Utilize Access for printing reports and documents.
• Begin using macros and understand Modal Dialog in Access.
• Grasp the basics of Access web app functionality.
• Master data exportation and reporting features in Access.

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!