Hands-On Microsoft Access 2019

Hands-On Microsoft Access 2019

Get more productive with Microsoft Access 2019

Bestseller
Created By: Ben Beitler
15.87 9.52

About This Course

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

Other Information

  • Certificate will provided in this course on Completion
  • Full lifetime access
  • Available on Mobile & Laptop

What Students Will Learn In Your Course?

  • 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

Are There Any Course Requirements Or Prerequisites?

Basic knowledge of Access is beneficial but not necessary.

Who Are Your Target Students?

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.

Course Content

  • 36 lectures
  • 07:18:05
  • The Course Overview
    00:03:47
  • Microsoft Access Components and Terminologies
    00:10:29
  • How to Plan and Build an Access Database
    00:12:06
  • Building Tables and Fields with Data Types
    00:13:14
  • Working with Table and Field Properties
    00:15:10
  • How to Import and Export Data
    00:10:51
  • Building Your First Query and Setting Criteria
    00:10:45
  • Calculating in a Query Using the Expression Builder
    00:08:20
  • How to Summarize and Group Data in a Query
    00:07:51
  • Building a Parameter Query
    00:05:54
  • Creating Action Queries
    00:13:34
  • Building Quick Forms
    00:12:13
  • Building a Form from Scratch
    00:10:22
  • Working with the Property Sheet for a Form
    00:18:35
  • Building a Popup Form
    00:11:08
  • Building Navigation Forms
    00:08:02
  • Building Quick Reports
    00:09:27
  • Building a Report from Scratch
    00:10:09
  • Working with the Property Sheet for a Report
    00:10:44
  • Building a Multi-Page and Sub Report
    00:16:46
  • Using the Report Wizard
    00:11:10
  • Understanding and Setting Primary and Secondary Keys
    00:12:41
  • Understanding What Normalization Means
    00:10:08
  • Different Types of Joins
    00:08:37
  • Applying Joins between Tables and Queries
    00:10:04
  • Understanding the Relationship Window
    00:10:50
  • What Are Macros and Their Benefits
    00:06:36
  • Macro Designer Windows and Controls
    00:11:37
  • Working with Key Commands and Parameters
    00:20:29
  • Understanding and Setting Auto Macros and Debugging a Macro
    00:14:07
  • Working with Data Macros
    00:22:12
  • A Quick Introduction to VBA
    00:09:03
  • The Visual Basic Editor and Settings
    00:06:29
  • Understanding the VBA Code
    00:25:35
  • Working with VBA in Access (Events)
    00:21:18
  • Testing and Debugging VBA Code
    00:17:42
Image

Packt Publication

  • 4.48 (4)
  • 13 Reviews
  • 4 Students
  • 935 Courses