In this course you will learn:

  • Where to start in Microsoft Access and whether to use a template or not
  • How to modify Access to suit your needs
  • All about importing data and the datasheet view
  • How tables work in Access and how to create relationships between them
  • Creating forms and sub-forms that feed data into your tables
  • How to run queries in Access
  • Setting up validations and calculations using expressions in Access
  • Printing from Access
  • To start to use macros and Modal Dialog
  • The basics of the Access web app
  • Exporting and reporting in Access

Microsoft Access remains a fantastic tool for when your data outgrows spreadsheets. Unlike many other database tools, it’s far more user-friendly and ideal if you’re not a developer.

In this Microsoft Access beginners course, we start at the very beginning and assume you know nothing about MS Access. We take a project approach to this course, which means you build your project out as we go. By the end of this Access 2019 course, you will have built out your database with proper functionality.

If you’ve used Excel in the past, that will help, but it’s not essential. This course is aimed at someone just starting in Access.

Course curriculum

  • 1

    Introduction

    • Introduction to Access 2019

    • Acquiring Access 2019

    • Structure of the Course
  • 2

    Getting Started with Access 2019

    • Using Database Templates

    • Creating, Saving and Opening Databases

    • The Access Workspace and Backstage

    • Online Help and Tell Me What You Want To Do
  • 3

    The Ribbon and Toolbars

    • Working with the Ribbon

    • The Quick Access Toolbar

    • Contextual Menus

    • The Status Bar
  • 4

    Keyboard Shortcuts and Key Tip

    • Keyboard Shortcuts

    • Key Tips
  • 5

    Access Options

    • Exploring Access Options
  • 6

    Tables

    • Creating a Table and Fields

    • Indexed Field

    • Lookup Wizard

    • Numeric Fields

    • Practice Exercise 01
  • 7

    Importing Data

    • Importing Data from Excel

    • Practice Exercise 02
  • 8

    Backup, Restore and Repair

    • Backing up your Database

    • Compact and Repair
  • 9

    Datasheet View

    • Design in the Datasheet View

    • Sorting and Filtering in Datasheet View

    • Entering and Modifying Data in Datasheet View
  • 10

    Relationships

    • Creating a Link Table

    • Setting up Relationships

    • Practice Exercise 03
  • 11

    Forms

    • Creating a Form

    • Modifying a Form

    • Practice Exercise 04

    • Forms in Layout View

    • Forms in Design View

    • Form Design

    • Practice Exercise 05
  • 12

    Subforms

    • Setting Up Subforms - Part 1

    • Setting Up Subforms - Part 2

    • Setting Up Subforms - Part 3

    • Practice Exercise 06
  • 13

    Queries

    • Creating a Query

    • Joins

    • Query Wizard

    • Practice Exercise 07
  • 14

    Expressions

    • Setting Up Validations

    • Calculation using Expressions
  • 15

    Reports

    • Basic Reports

    • Report Design

    • Complex Reports

    • Practice Exercise 08
  • 16

    Printing

    • Printing and Print Properties
  • 17

    More Data Types

    • Yes/No, OLE Objects and Hyperlink Data Types
  • 18

    More About Forms

    • Form Controls

    • Form Themes

    • Navigation Forms
  • 19

    Exporting

    • Exporting an Access Database
  • 20

    Application Parts

    • Adding Application Parts to a Database
  • 21

    More Access Options

    • Additional Access 2019 Options
  • 22

    Info Tab

    • Edit Database Properties and Encrype with Password
  • 23

    Course Close

    • Course Close
  • 24

    Course & Exercise Files

    • Course files

    • Exercise Files