Hands-On Microsoft Access 2019

Video description

Microsoft Access 2019 is an information management tool that stores information and, arguably, helps manage data more efficiently than other spreadsheet apps. It is an ideal and particularly useful tool for small-to-medium-sized (SME) businesses.

This will be a practical, beginner-level course with hands-on, real-world examples you can use as models for your own activities. Beginning with a quick introduction to an example Access database, you will cover the core concepts, interface, and terminology you need to get started. You will then master the key components of data query management; forms to help you view, add, edit, and even delete data in a controlled environment. Then, you will publish your data with the help of built-in reporting, and move on to work with RDBMS concepts relating to ‘joins’ and why they’re important. You’ll find out how to automate your Access database by creating and applying macros and learn about VBA programming and how it’s used with Access.

By the end of the course, you will be confident in your new skills in Microsoft Access 2019 to improve productivity, and data visualization.

What You Will Learn

  • How and why Access provides an ideal solution to store, manage, and manipulate data, whilst keeping it all in one place and synchronized with your daily activities
  • Core fundamentals of building simple-to-use queries that help you get the answers you need from your data
  • Create great-looking forms for end users to submit and view data in easy-to-use layouts
  • Build simple-to-use (and simple-to-visualize) reports for publication to meet the needs of all stakeholders in your organization
  • Automate parts of a database with the aid of macros and VBA code for ease of use without learning to be a programmer
  • Create links with other applications using simple import and export features
  • Handle back-end database administrative tasks for maintaining data and objects in Access


This course is for business professionals, developers, data analysts, and IT professionals who are handling large datasets or spreadsheets but can't easily get key, relevant information or reports and want to gain better functionality and visibility from using a database structure that enables these.


Basic knowledge of Access is beneficial but not necessary.

About The Author

Ben Beitler: Ben Beitler is a highly proficient software developer and consultant with over 25 years experience of database design and implementation of CRM management systems, and bespoke applications using VBA (mainly Excel spreadsheets and Access databases).

He has successfully run several businesses, including desktop training, consultancy, and development in Access and Excel ranging from small to the larger companies including Ford, Toyota, HSBC, Barclays, PWC, Deloitte, Sage, and many others.

Even though he is based in the UK, he has provided consultancy services and developed systems with software specialists as far afield as Australia.

Table of contents

  1. Chapter 1 : Microsoft Access - In the Beginning
    1. The Course Overview
    2. Microsoft Access Components and Terminologies
    3. How to Plan and Build an Access Database
    4. Building Tables and Fields with Data Types
    5. Working with Table and Field Properties
    6. How to Import and Export Data
  2. Chapter 2 : Asking Questions Using Queries
    1. Building Your First Query and Setting Criteria
    2. Calculating in a Query Using the Expression Builder
    3. How to Summarize and Group Data in a Query
    4. Building a Parameter Query
    5. Creating Action Queries
  3. Chapter 3 : Engaging with Data Using Forms
    1. Building Quick Forms
    2. Building a Form from Scratch
    3. Working with the Property Sheet for a Form
    4. Building a Popup Form
    5. Building Navigation Forms
  4. Chapter 4 : Publishing Your Data Using Reports
    1. Building Quick Reports
    2. Building a Report from Scratch
    3. Working with the Property Sheet for a Report
    4. Building a Multi-Page and Sub Report
    5. Using the Report Wizard
  5. Chapter 5 : Building Meaningful Relationships
    1. Understanding and Setting Primary and Secondary Keys
    2. Understanding What Normalization Means
    3. Different Types of Joins
    4. Applying Joins between Tables and Queries
    5. Understanding the Relationship Window
  6. Chapter 6 : Adding 'Bells and Whistles' Using Macros
    1. What Are Macros and Their Benefits
    2. Macro Designer Windows and Controls
    3. Working with Key Commands and Parameters
    4. Understanding and Setting Auto Macros and Debugging a Macro
    5. Working with Data Macros
  7. Chapter 7 : Introducing You to VBA Programming
    1. A Quick Introduction to VBA
    2. The Visual Basic Editor and Settings
    3. Understanding the VBA Code
    4. Working with VBA in Access (Events)
    5. Testing and Debugging VBA Code

Product information

  • Title: Hands-On Microsoft Access 2019
  • Author(s): Ben Beitler
  • Release date: March 2020
  • Publisher(s): Packt Publishing
  • ISBN: 9781838987473