Hands-On Microsoft Access 2019

Video description

Get more productive with Microsoft Access 2019

About This Video

  • A 'one-stop' shop to learn about data management, interrogation, reporting and automation using all the key Access tools (tables, queries, forms, report, and macro)
  • Hands-on, practical training to get you up and running with an industry-leading database management suite that can integrate with core Microsoft applications (including r Excel, Word, and Outlook), exchanging data with ease
  • Take advantage of organizing data sets into logical units that take advantage of RDBMS, simulating real-world business/organizational workflows and processes

In Detail

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.

Publisher resources

Download Example Code

Table of contents

  1. Chapter 1 : Microsoft Access - In the Beginning
    1. The Course Overview 00:03:47
    2. Microsoft Access Components and Terminologies 00:10:29
    3. How to Plan and Build an Access Database 00:12:07
    4. Building Tables and Fields with Data Types 00:13:14
    5. Working with Table and Field Properties 00:15:10
    6. How to Import and Export Data 00:10:52
  2. Chapter 2 : Asking Questions Using Queries
    1. Building Your First Query and Setting Criteria 00:10:45
    2. Calculating in a Query Using the Expression Builder 00:08:21
    3. How to Summarize and Group Data in a Query 00:07:51
    4. Building a Parameter Query 00:05:55
    5. Creating Action Queries 00:13:34
  3. Chapter 3 : Engaging with Data Using Forms
    1. Building Quick Forms 00:12:13
    2. Building a Form from Scratch 00:10:23
    3. Working with the Property Sheet for a Form 00:18:36
    4. Building a Popup Form 00:11:09
    5. Building Navigation Forms 00:08:02
  4. Chapter 4 : Publishing Your Data Using Reports
    1. Building Quick Reports 00:09:28
    2. Building a Report from Scratch 00:10:10
    3. Working with the Property Sheet for a Report 00:10:44
    4. Building a Multi-Page and Sub Report 00:16:47
    5. Using the Report Wizard 00:11:11
  5. Chapter 5 : Building Meaningful Relationships
    1. Understanding and Setting Primary and Secondary Keys 00:12:42
    2. Understanding What Normalization Means 00:10:08
    3. Different Types of Joins 00:08:38
    4. Applying Joins between Tables and Queries 00:10:05
    5. Understanding the Relationship Window 00:10:50
  6. Chapter 6 : Adding 'Bells and Whistles' Using Macros
    1. What Are Macros and Their Benefits 00:06:37
    2. Macro Designer Windows and Controls 00:11:38
    3. Working with Key Commands and Parameters 00:20:30
    4. Understanding and Setting Auto Macros and Debugging a Macro 00:14:08
    5. Working with Data Macros 00:22:12
  7. Chapter 7 : Introducing You to VBA Programming
    1. A Quick Introduction to VBA 00:09:04
    2. The Visual Basic Editor and Settings 00:06:30
    3. Understanding the VBA Code 00:25:35
    4. Working with VBA in Access (Events) 00:21:18
    5. Testing and Debugging VBA Code 00:17:43

Product information

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