Microsoft Access 2019/Office 365 Series

Microsoft Access 2019/Office 365 Series

SHARE
  • Details
  • Syllabus
  • Requirements

Details

The Microsoft Access 2019/Office 365 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
Course Code: B9376
Start Dates*Oct 16 | Nov 13 | Dec 11 | Jan 15
*Choose start date in cart
$225.00

Syllabus

Introduction to MS Access 2019/Office 365 Syllabus

  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

 Intermediate MS Access 2019/Office 365

  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 must be taken on a PC device. A Mac OS is not compatible.

Software Requirements:

  • PC: Windows 10 or later operating systems.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Microsoft Access 2019: Available to download with a subscription to Office 365, or with Microsoft Office Professional 2019. (not included in enrollment)
  • Adobe Flash Player. Click here to download the Flash Player.
  • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
  • Email capabilities and access to a personal email account.
  • Software must be installed and fully operational before the course begins.

Instructional Material Requirements:

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