Discover Classes. Earn 10% Rewards.

Access – Part 2 is unfortunately unavailable

Thankfully we have 81 other Microsoft Office Classes for you to choose from. Check our top choices below or see all classes for more options.

Project - Managing Projects

Computer Training Source, Inc. See all classes by this school @ Online Classroom

Build your project management skills through our comprehensive online course. Learn how to create and track project plans, analyze project statistics, resolve conflicts, generate reports, and integrate data with other Office applications. Boost your career with this focused training.

(22) All levels 18 and older
$499
Attend
Earn 4,990 points
Gift it!

Microsoft Office Fundamentals Bootcamp

Noble Desktop See all classes by this school - Virtually Online

Get fluent in the essential Microsoft Office programs through this beginner-friendly program. Build proficiency in Excel, PowerPoint, Word, and Outlook in just 4 days. Lift your productivity and efficiency on the job.

(453) All levels 18 and older
$749

4 sessions

Gift it!

Complete Microsoft Office Bootcamp

Noble Desktop See all classes by this school - Virtually Online

Get fluent in the Microsoft Office suite through in-depth classes in Excel, PowerPoint, Word, and Outlook at Noble Desktop. Build the skills you need to thrive at work and stand out from peers. Lift your productivity through this comprehensive bootcamp.

(453) All levels 18 and older
$1,725

9 sessions

Gift it!

Microsoft Master Certification Program with Access

Noble Desktop See all classes by this school - Virtually Online

Get certified in Microsoft Excel, PowerPoint, Word, and Access with this comprehensive program offering group classes, private training, exams, free retakes, study guides, and flexible scheduling. Earn digital and physical certificates in just weeks.

(453) All levels 18 and older
$2,799

9 sessions

Gift it!

Managing Projects with Microsoft 365

American Management Association See all classes by this school

Discover how to manage projects and information using SharePoint in this hands-on, lab-intensive training course to develop SharePoint project sites, utilize functionality, integrate with Microsoft Office and Project Server, and build workflows. Ideal for project managers, business analysts, and IT managers in a project environment.

(8) All levels 21 and older
$1,695

3 sessions

Attend
Earn 16,950 points
Gift it!
See all Microsoft Office classes Online

Access – Part 2

Expand your knowledge of Microsoft Access and become an expert in database design, efficiency, and data integrity. Improve tables, queries, forms, and reports to create a robust, functional database. Prepare for the Access Expert certification with this course.

  • All levels
  • 18 and older
  • Earn 10% back in points
  • Price Lock

    If you find the same class on the same dates for less on another site within 48 hours of booking, send us the link. We match the price as credit or the difference.

  • Interactive Online Classroom
  • 16 hours over 2 sessions

Start Dates (0) $590/person

No upcoming dates are currently available.

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification.

Objectives:

In this course you will:

  • Optimize an Access database.
  • Provide input validation features to promote the entry of quality data into a database.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Improve the usability of Access tables.
  • Create advanced queries to join and summarize data.
  • Use advanced formatting and controls to improve form presentation.
  • Use advanced formatting and calculated fields to improve reports.

Prerequisite(s):

Access for Office 365 – Part 1

Audience:

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Office 365.

Outline:

Module 1 – IMPROVING TABLE USABILITY

  • Create Lookups Within a Table
  • Work with Subdatasheets

Module 2 – CREATING ADVANCED QUERIES

  • Create Query Joins
  • Create Subqueries
  • Summarize Data

Module 3 – IMPROVING FORM PRESENTATION

  • Apply Conditional Formatting
  • Create Tab Pages with Subforms and Other Controls

Module 4 – CREATING ADVANCED REPORTS

  • Apply Advanced Formatting to a Report
  • Add a Calculated Field to a Report
  • Control Pagination and Print Quality
  • Add a Chart to a Report

Module 5 – IMPORTING AND EXPORTING TABLE DATA

  • Import and Link Data
  • Export Data
  • Create a Mail Merge

Module 6 – USING QUERIES TO MANAGE DATA

  • Create Action Queries
  • Create Unmatched and Duplicate Queries

Module 7 – CREATING COMPLEX REPORTS AND FORMS

  • Create Subreports
  • Create a Navigation Form
  • Show Details in Subforms and Popup Forms

Module 8 – CREATING ACCESS MACROS

  • Create a Standalone Macro to Automate Repetitive Tasks
  • Create a Macro to Program a User Interface Component
  • Filter Records by Using a Condition
  • Create a Data Macro

Module 9 – USING VBA TO EXTEND DATABASE CAPABILITIES

  • Introduction to VBA
  • Using VBA with Form Controls

Module 10 – MANAGING A DATABASE

  • Back Up a Database
  • Manage Performance Issues
  • Document a Database

Module 11 – DISTRIBUTING AND SECURING A DATABASE

  • Split a Database for Multiple-User Access
  • Implement Security
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Refund Policy

Open Enrollment Desktop Applications Classes -- You may reschedule or cancel your enrollment in a Desktop Applications class at no charge with at least five (5) or more business days advance written notice. If you reschedule or cancel your class with less notice or “no show” the full amount of your invoice must be paid. If you need to cancel your registration you also have the option to send a substitute student to your class or to reschedule your class at no additional cost on a space available retake basis for up to 12 months.

Open Enrollment Technical Training Classes with Level TT1, TT2 or TT3 Tech Pricing -- You may reschedule or cancel your enrollment in a Technical Training Class with Level TT1, TT2 or TT3 Tech Pricing at no charge with at least ten (10) or more business days advance written notice. If you reschedule or cancel your class with less notice or “no show” the full amount of your invoice must be paid. If you need to cancel you also have the option to send a substitute student to your class or to reschedule your class at no additional cost on a space available retake basis for up to 12 months.

Reviews of Classes at TLG Learning (1)

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • No booking fees. You pay the school's price, with nothing added at checkout.
  • Price Lock. If you find the same class on the same dates for less on another site within 48 hours of booking, send us the link. We match the price as credit or the difference.
  • This class will earn you 5900 points. Earn 10% back in points. 100 points = $1 off a later class.

TLG Learning

TLG Learning is a trusted provider of comprehensive learning solutions in the IT industry, offering a wide range of vendor-certified courses and customized training options. With an impressive recommendation rate from their clients, TLG Learning specializes in Microsoft and F5 Networks and is located in the Greater Seattle Area.

View school profile
TLG Learning
Vetted by CourseHorse

A verified Online educator.

Loading...