Book Image

Hands-On Microsoft Access 2019 [Video]

By : Ben Beitler
5 (2)
Book Image

Hands-On Microsoft Access 2019 [Video]

5 (2)
By: Ben Beitler

Overview of this book

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. All the supporting files for this course are available on Github at: https://github.com/PacktPublishing/Hands-On-Microsoft-Access-2019
Table of Contents (7 chapters)
Chapter 6
Adding 'Bells and Whistles' Using Macros
Content Locked
Section 4
Understanding and Setting Auto Macros and Debugging a Macro
Understand the two pre-defined Auto Macro names in Access. Also, see how to set them up and trigger them automatically. The tools to debugging a Macro and options including the single step process and using the single step command. Handling errors using a message box command interface.