In this module, we will guide you through creating, saving, and opening databases. You’ll learn to customize the toolbar and menus, explore keyboard shortcuts, and practice building your first inventory database using templates.

In this module, we will teach you the essentials of table creation and management. You will build tables, apply indexing and validation, and perform practical exercises to reinforce your data structuring skills in Access 2021.

In this module, we will show you how to seamlessly import data from Excel spreadsheets and text files into Microsoft Access 2021. You will gain hands-on experience with data import processes to enhance your database's versatility.

In this module, we will explore the Datasheet View in Access 2021, focusing on its design and data manipulation capabilities. You will practice sorting, filtering, and editing records to become proficient in managing data visually.

In this module, we will guide you through setting up and managing relationships between tables in Access 2021. You will learn to create link tables and enforce integrity rules, ensuring your database maintains accurate and related data.

In this module, we will teach you how to create and personalize forms to interact with your database. You’ll explore different views and form properties, culminating in a hands-on exercise building a custom order maintenance form.

In this module, we will cover the process of creating and linking subforms in Access 2021. You’ll learn to build relational forms that improve data presentation and complete practical tasks to reinforce these concepts.

In this module, we will introduce you to creating and running queries in Access 2021. You’ll learn essential join types and practice building queries to extract meaningful information from your database.

In this module, we will focus on setting up validations and expressions in Access 2021. You will learn how to enhance data accuracy and perform calculations, finishing with hands-on practice creating calculated controls on forms.

In this module, we will explore report creation in Access 2021, from running simple reports to designing complex layouts. You will practice crafting personalized reports that showcase your database insights effectively.

In this module, we will introduce additional data types available in Access 2021. You’ll learn to incorporate Boolean fields and attach files to records, expanding the functionality of your database with hands-on application.

In this module, we will deepen your knowledge of form controls and design in Access 2021. You will explore option buttons, themes, and navigation forms, and complete exercises to create polished, user-friendly interfaces.

In this module, we will teach you how to share your Access 2021 databases securely. You’ll learn to export data, set properties, encrypt files, and practice these skills to protect your information.

In this module, we will explore advanced Access features that help maintain and document your database. You will practice compacting, repairing, printing reports, and generating detailed documentation.

In this module, we will conclude the beginner course, recapping essential skills and achievements. This prepares you for the advanced topics coming next in your Access 2021 journey.

In this module, we will introduce the advanced Access 2021 course content. You’ll get set up for success and be ready to dive deeper into complex database management.

In this module, we will cover advanced concepts of primary keys and indexes in Access 2021. You will learn best practices and strategies for efficient database design.

In this module, we will guide you through advanced datasheet view techniques using the Northwind database. You’ll learn customization and data analysis skills to manage complex datasets.

In this module, we will demonstrate how to link tables across Access databases. This technique expands your data sources and improves data management flexibility.

In this module, we will cover integrating Access 2021 with SQL Server using ODBC. You will gain skills in installation, configuration, and linking for enterprise-level database solutions.

In this module, we will explore splitting your Access database to optimize performance and collaboration. You will practice dividing your database and addressing multi-user issues.

In this module, we will introduce macro basics and automation in Access 2021. You’ll learn to build macros, manage events, and secure your macros for effective task automation.

In this module, we will teach you how to personalize the Access ribbon and toolbar. Customizing these elements helps you work faster and more comfortably.

In this module, we will dive into VBA programming in Access 2021. You will unlock powerful customization options by learning to write and manage VBA code effectively.

In this module, we will cover the Access events model, enabling you to automate and control user interactions. You will build advanced functions and user interfaces through event handling.

In this module, we will teach advanced form design techniques. You will learn to format forms, manage errors, and build intuitive tabbed interfaces for better user experiences.

In this module, we will deepen your query skills with advanced SQL and action queries. You will practice building powerful queries that manipulate and analyze data dynamically.

In this module, we will teach you how to protect your Access 2021 databases and code. You’ll learn encryption, password management, and packaging techniques to safeguard your work.

In this final module, we will summarize your advanced Access 2021 journey. You’ll revisit key concepts and celebrate your accomplishment as you complete the course.