Hands-On Microsoft Access 2019

.MP4, AVC, 1920x1080, 30 fps | English, AAC, 2 Ch | 7h 18m | 1.48 GB

Instructor: Ben Beitler

Get more productive with Microsoft Access 2019

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

About

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:

Features

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