Microsoft Access 2021

LESSON 1. Basic Functions for Managing Files 1. Creating a New Access Database 2. Elements of an Access Database 3. Access User Interface 4. Using Access Help LEARNING UNIT 2. Access Interface 1. Datasheet View 2. Design View 3. Table Properties LEARNING UNIT 3. Databases 1. Designing a Database 2. Creating a Database 3. Creating Tables 4. Creating a Chart LEARNING UNIT 4. Tables 1. Entering Data into Tables 2. Modifying the Database Structure 3. Primary Key and Indexes 4. Default Values 5. Relationships and Referential Integrity 6. Copying Tables 7. Deleting Tables LEARNING UNIT 5. Queries 1. Introduction to Queries 2. The Query Datasheet View 3. The Query Design View 4. Basic Structure of Queries 5. Creating Queries LEARNING UNIT 6. Forms 1. What Are Forms? 2. Creating a Form 3. Types of Forms 4. Form Controls 5. Modifying Forms LEARNING UNIT 7. Reports 1. Introduction to Reports 2. Using Reports 3. Report Views 4. Sections and Properties 5. Designing a Report 6. Creating Reports with Wizards 7. Creating a Report with One Click LEARNING UNIT 8. Macros 1. What Are Macros? 2. The Macro Design View 3. Creating Standalone Macros 4. Creating Macros Embedded in Forms and Reports 5. Creating a Data Macro 6. Modifying Actions and Logic Blocks 7. Conditional Macros 8. Running Macros 9. Types of Events 10. Debugging Macros LEARNING UNIT 9. Modules 1. What Are Modules? 2. Types of Modules and Procedures 3. Creating a Module 4. Debugging Modules 5. Debugging Procedures