Introduction to Microsoft Access 365 Training

Introduction to Microsoft Access 365 Training Courseware (ACC365.1)

MicrosoftMicrosoft Access

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.

Publisher: Webucator

Benefits

  • Understand when to use a database versus a spreadsheet and how Microsoft Access functions as a relational database.
  • Confidently navigate the Access 365 interface and create databases using built-in tools and wizards.
  • Plan and design well-structured databases using sound design principles, normalization, and relationships.
  • Create and manage tables with appropriate data types, including importing and linking existing data.
  • Build effective queries to filter, analyze, group, and summarize data.
  • Design user-friendly forms to simplify data entry and navigation.
  • Create professional reports to present and share database information clearly.

Outline

  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)

Required Prerequisites

None

License

Length: 2 days | $40.00 per copy

LicenseRequest More InformationDownload Sample CopyRequest Trainer Evaluation Copy
What is Included?
  • Student Manual
  • Student Class Files