Microsoft Access 2019 Series

Details

The Microsoft Access 2019 Series provides a comprehensive overview of Access 2019. You will first learn the basic functions of Access and then learn more advanced techniques that fully utilize this powerful software.

The Introductory course will teach you fundamental data management techniques, like creating forms and tables, efficient data entry, and editing. You will also learn how to use Access to develop queries that locate and isolate records and to design professional reports. By the time you have finished the course, you will know how to organize and assemble an effective database for any kind of information you need to store, document, and manage.

The Intermediate course builds on your previous Access skills. You will start by importing customer and order information from several Excel spreadsheets as tables in a new database. Once you have mastered proper table construction, you will learn how to create forms to manage table data. Then, you will discover how to construct crosstab and summary queries, and crunch numbers using query calculations. Finally, you will build a navigation form, so users can search your database.

Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.

Enrollment Options:

Instructor-Led
6 Weeks Access Course Code: B9376
Start Dates* Nov 13 | Dec 18 | Jan 10 | Feb 07
*Choose start date in cart

$260.00

USD

Enroll before 31th May and get high quality lamination on your hardcopy certificate absolutely free! Use your certificate to your advantage by showing your certified credentials to prospective employers and recruiters.

Syllabus

  1. Introduction to Microsoft Access 2019
    1. Getting to Know Access 2019
    2. Controlling Your Access Table Fields
    3. Creating Tables and Relationships
    4. Building Powerful Forms
    5. Adding Versatility to Forms
    6. Interviewing Your Database
    7. Taking Queries to the Next Level
    8. Multi-Table Query Control
    9. Reporting on Your Tables
    10. Creating Query-Based Reports
    11. Mastering Report Design
    12. Automating Your Database With Macros
  2. Intermediate Microsoft Access 2019
    1. Reviewing Terms and Importing Data
    2. Key Fields and Action Queries
    3. Relationships of the Database Kind
    4. Creating and Modifying Forms
    5. Subforms and the Tab Control
    6. Queries
    7. Query Calculations
    8. Summary Queries
    9. Building Reports That Pinpoint Key Information
    10. Run Reports from a Custom Dialog Box
    11. Using Visual Basic to Automate the Reports Dialog Box
    12. Putting It All Together

Requirements

Hardware Requirements:

  • This course can be taken on either a PC or Mac.

Software Requirements:

  • PC: Windows 8 or newer.
  • Mac: OS X Snow Leopard 10.6 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.

Other:

  • Email capabilities and access to a personal email account.

Prerequisites

There are no prerequisites to take this course.

Instructor

Laurie Ann Ulrich

Laurie Ann Ulrich is lead instructor at the Digital Workshop and has taught since 1992. In addition, she has consulted with corporations on the use of Access for more than 20 years. Outside of teaching, Ulrich is CEO of Limehat & Company, a digital media company. She is also the author and co-author of more than 30 published books on computers, software, and the internet.

Ken Cook

Ken Cook has managed his own successful computer consulting business since 1990. He began as a trainer, instructing numerous users on a variety of software packages, specializing in Microsoft Office. Currently, his main focus is creating expert Microsoft Office solutions, Microsoft Access database solutions, and Microsoft SQL Server solutions for Fortune 500 and small business clients. He is also co-author of four "Access for Dummies" books.

Reviews

About ExpertRating

ExpertRating is an ISO 9001:2015 certified company offering online certification and training services to individuals and companies globally. Over 25 million people have benefited from ExpertRating Online Certifications and assessments. ExpertRating is the winner of the Google SME Hero's award for showing outstanding use of technology in delivering trusted services to thousands of people on a daily basis. Our affordable certifications are an excellent way of demonstrating your knowledge and skills to prospective employers as well as vastly boosting your chances of moving ahead in your business or career.

Company Timeline

Since 2001

Decades of excellence

800+ Skill Tests

World’s largest test inventory

2500+ Companies

Thousands depend on use

25 Million People Tested

10 tests every minute

35 Countries Serviced

Over 1500 clients in the US

86% Reorder Rate

Satisfied clients

We deliver over 3 million online certification tests and online courses annually.

Awards

ExpertRating is a winner of the Google SME Heroes award. This award has been instituted by Google to honor IT companies that have excelled in their domain and have leveraged the internet to grow and expand their businesses in innovative ways.


ExpertRating is an ISO 9001:2015 certified company, which reflects that our courses and tests conform to the highest international quality standards. Our training material is prepared by thorough professionals with years of experience, and goes through several rounds of analysis by expert teams to help develop well-balanced, comprehensive and meaningful content.