Introduction to Microsoft Access 365 Training (ACC365.1)

Introduction to Microsoft Access 365 Training is designed for business professionals, teams, and individuals who want to build a solid foundation in database management using Microsoft Access. It’s ideal for employees who work with data, administrative staff, analysts, or anyone transitioning from spreadsheets to a more structured database solution. No prior database experience is required. This course starts at the basics and is accessible for beginners.

Participants will learn how to create, organize, and manage databases efficiently using Access 365. By the end of the course, learners will be able to design tables, build queries, create user-friendly forms, and generate professional reports. They will also understand core database concepts such as relationships and normalization, helping them manage data more accurately and improve productivity. This course provides practical, hands-on skills that can be immediately applied in real-world business scenarios.

1. Databases and Access Terms
   1. Database Defined
   2. Databases vs. Spreadsheets
   3. Access vs. Excel
   4. Spreadsheet or Database (Exercise)
   5. Relational Database Defined
   6. Understanding Relational Databases (Exercise)
   7. Relational Database Management System (RDBMS) Defined
   8. Access is an RDBMS
   9. Creating a Relationship
   10. Benefits and Limitations of Access
2. Quick Overview Access Interface
   1. Access Ribbon
   2. Quick Access Toolbar
   3. Object Navigation Pane
   4. Access Work Surface
   5. Object Overview
   6. Process Overview
   7. Getting Around the Access Environment (Exercise)
   8. Create a Database Using a Wizard
3. Fundamentals
   1. Questions to Ask Before You Start
   2. Asking Questions (Exercise)
   3. Approaches to Database Design
   4. Gather Information
   5. A Few Words about Naming Conventions
   6. Gathering Information (Exercise)
   7. Normalization
   8. Table Relationships
   9. Normalizing Data (Exercise)
4. Tables and Their Views
   1. Definition and Purpose
   2. Datasheet View
   3. Working with Tables in Datasheet View (Exercise)
   4. Import a Table of Data
   5. Design View
5. Tables
   1. Creating an Access Database
   2. Creating a New Database (Exercise)
   3. Data Types
   4. Determining Data Types (Exercise)
   5. Create a Table in Design View
   6. Creating a Table in Design View (Exercise)
   7. Link a Table of Data
6. Queries
   1. Queries
   2. Select Queries
   3. Select Queries with Criteria
   4. Logical Operators
   5. Group and Total with Queries
   6. Creating Select Queries (Exercise)
7. Forms
   1. Forms
   2. Alter a Form
   3. Adding Data Records in Form View (Exercise)
   4. Form Record Navigation
   5. Layout View and Design View
   6. One-Click Forms
   7. Form Wizard
   8. Creating a Form with the Form Wizard (Exercise)
8. Reports
   1. Reports
   2. Report Wizard
   3. Creating a Report with the Report Wizard (Exercise)

Each student receives a comprehensive set of materials, including course notes and all class examples.