Microsoft Access Series

Microsoft Access Series

Virtually every industry benefits from information management and Microsoft Access is one of the most widely used programs used for this task. Data ranging from inventory to customer information can be effectively organized with this longstanding software. If you work with databases of any kind, learning the ins and outs of Access will allow you to take a stronger role in database management.

This course bundle will teach how to use Access to organize, store, and document essential information. The Introduction course focuses on fundamentals, so you can plan and develop a well-organized database. The Intermediate Access course will teach you advanced techniques as you build an entire database project from scratch. You will learn how to import Excel spreadsheets as tables, create query calculations to crunch numbers, and use Visual Basic to automate common tasks.

From initial database creation to using conditional formatting, by the time you complete this course bundle, you will be well-versed in how to best manage and present your data with Access 2019, 2021, or Office 365.

48 Course Hrs
SHARE Share on Facebook Share on Twitter
  • Details
  • Syllabus
  • Requirements
  • Instructor
Enrollment Options Menu
$260.00
imc-icon
Instructor-Moderated
48 Course Hrs
Study online with Instructor moderated discussion boards.
Select a start date for each course below:
Select a Start Date
$260.00
Instructor-Moderated
Select a Start Date

Details

The Microsoft Access Series provides a comprehensive overview of Access 2019, 2021, or Office 365. 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.

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

Prerequisites:

There are no prerequisites to take the Introduction course. Completion of "Introduction to Microsoft Access" is required to complete the Intermediate course.


Requirements:

Hardware Requirements:

  • This course must be taken on a PC. Macs are not compatible.

Software Requirements:

  • PC: Windows 10 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Adobe Acrobat Reader.
  • Software must be installed and fully operational before the course begins.
  • Microsoft Access 2019, 2021 and Office 365 desktop (not included in enrollment). Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional. Microsoft Access 2016 is also acceptable. Please note: There may be some differences between your version of Access and what you see in the course.

Other:

  • Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

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.

Instructor Interaction: The instructor looks forward to interacting with learners in the online moderated discussion area to share their expertise and answer any questions you may have on the course content.

Related Courses

Course Slider Image Intermediate Microsoft Access Course Hours
Course Slider Image Introduction to Microsoft Access Course Hours
Instructor-Moderated Course Code: B9376
Copyright © 1997 - 2025 All rights reserved. The material on this site cannot be reproduced or redistributed unless you have obtained prior written permission from Cengage Learning. Privacy Policy