Microsoft Logo

55280: Advanced Microsoft Access Training

Students who wish to construct databases at a high level or who want to enhance existing Access 2019 or Access 365 databases should enroll in this Advanced Access training course.

📘 MS Office 👥 1324 Enrolled ⏱️ 2 Days 💼 Level ⭐ 4.5 | 113 Reviews

Why Microtek Learning?

500+

Courses

10+ Years

Experience

95K+

Global Learners

Virtual Instructor-Led Training

$995
| 55280: Advanced Microsoft Access

Course Overview

Students who wish to construct databases at a high level or who want to enhance existing Access 2019 or Access 365 databases should enroll in this Advanced Access training course.

 

Training Exclusives

Mode of Training

🏫 Classroom 💻 Live Online 🧪 Blended 👨‍👩‍👧‍👦 Private Group

What you will learn

  • Recognize the relationships in a database.
  • Use the linkages between tables.
  • Work using advanced query techniques.
  • Advanced formwork is required.
  • Working with reports at a high level.
  • Utilize macros.
  • Utilizing the navigation form, finish the desktop program.

Who Should Attend This Course?

This course is designed for students who already have a working knowledge of Microsoft Access and wish to expand their knowledge of the interface or study the topics covered in this course.

 

Prerequisites

  • Microsoft Access knowledge and proficiency at the beginner level.

📞 Talk to a Learning Advisor

Please enter Name
Please enter a valid email address.
Please enter a valid phone number in international format (e.g., +14155552671).
Please enter Message
Please agree to I agree to Terms & Privacy Policy*.
Please agree to I authorize Microtek Learning to contact me via Phone/Email*.

📘 55280: Advanced Microsoft Access Outline

This module explains how to work with relationships in Microsoft Access.

Lessons

  • Review
  • Referential Integrity
  • Relationships
  • A Few Words about Naming Conventions

Lab 1: Installing and Configuring Windows 7

After completing this module, students will be able to:

  • Understand referential integrity.
  • Establish relationships between tables.

This module explains how to work with queries in Microsoft Access.

Lessons

  • Query Design View
  • Review of Select Queries
  • Review of Select Queries with Criteria
  • Logical Operators
  • Parameter Queries
  • Action Queries

Lab 1: Queries Exercises

  • Creating Select and Action Queries
  • Creating a Parameter Query

After completing this module, students will be able to:

  • Work with select and action queries.
  • Work with logical operators.
  • Create and run select, parameter, make a table, append, update, and delete queries.

This module explains how to work with table functions.

Lessons

  • Importing Data
  • Linking Tables from External Sources
  • Import Tables from Other Databases
  • Tables from Templates and Application Parts

Lab 1: Table Functions Exercises

  • Importing Data from Excel
  • Exporting Data to Excel

After completing this module, students will be able to:

  • Import data from Excel.
  • Export data to Excel.

This module explains how to work with forms in Microsoft Access.

Lessons

  • Design View
  • Formatting
  • Tab Order
  • Create Forms with Application Parts
  • Creating a Subform
  • Alter a Form

Lab 1: Creating Forms

After completing this module, students will be able to:

  • Understand the parts of a form.
  • Add objects to a form.
  • Add, move, format, and order fields on a form.
  • Understand controls available for forms.
  • Work with form properties, section properties

This module explains how to work with reports in Microsoft Access.

Lessons

  • Design View
  • Report Sections
  • Arranging Fields on a Report
  • Resizing the Detail Section
  • Grouping and Sorting
  • Setting Properties on a Report
  • Special Report Fields
  • Controls
  • Subreports
  • Application Parts
  • Deleting a Report
  • Formatting a Report

Lab 1: Creating Reports

After completing this module, students will be able to:

  • Create and format Access reports.
  • Work with the various sections of a report.
  • Group, sort, and add totals for records on a report.
  • Work with the Expression Builder.
  • Work with property sheets.

This module explains how to work with macros in Microsoft Access.

Lessons

  • Macro Basics
  • Running a Macro

Lab 1: Creating Simple Macros

After completing this module, students will be able to:

  • Create several simple macros.
  • Run macros.

This module explains how to complete the desktop application in Microsoft Access.

Lessons

  • The Navigation Form
  • Running Macros from a Navigation Form
  • Setting the Navigation Form as the Default Form
  • Splitting the Database
  • Distributing the Front-end Database
  • Database Maintenance

Lab 1: Creating a Navigation Form

After completing this module, students will be able to:

  • Create navigation forms.
  • Split an Access database into front-end and back-end databases.
  • Distribute an Access database front end to your users.

Still have questions?

Reach out to our learning advisors for personalized guidance on choosing the right course, group training, or enterprise packages.

📞 Talk to an Advisor

What You Get with Microtek Learning

Instructor-Led Excellence

  • Certified Instructor-led Training
  • Top Industry Trainers
  • Official Student Handbooks

Measurable Learning Outcomes

  • Pre- & Post-Training Assessments
  • Practice Tests
  • Exam-Oriented Curriculum

Real-World Skill Building

  • Hands-on Activities & Scenarios
  • Interactive Online Courses
  • Peer Collaboration (Not in self-paced)

Full Support & Perks

  • Exam Scheduling Support *
  • Learn & Earn Program *
  • Support from Certified Experts
  • Gov. & Private Pricing *

Our Clients

For over 10 years, Microtek Learning has helped organizations, leaders, students and professionals to reach their maximum potential. We have led the path by addressing their challenges and advancing their performances.

Actemium
US Dept of Defense
Education Advisory Board
GE Digital
Department of Homeland Security
Pacific Life
MetLife
AIG
Chase
DC Gov
Johnson & Johnson
William Osler Health System
Google

Our Awards

Microsoft Award

Microsoft Learning
Partner of the Year

Inc 5000

5000 List of the Fastest-Growing Private Companies in America

Top IT Training

Top IT Training Companies
(Multiple Years)

Why We Are Best To Choose?

Team Support

Professional Team Support

Our expert counseling team provides round-the-clock assistance with the best value offers.

Experienced Trainers

Experienced Trainers

Certified trainers with 5–15 years of real-world industry experience guide your learning.

Satisfaction Guarantee

100% Satisfaction Guarantee

We guarantee satisfaction with top-quality content and instructor delivery.

Real-World Experience

Real-World Experience

Train with industry projects and curricula aligned to current standards.

Best Price Guarantee

Best Price Guarantee

We promise the lowest pricing and best offers in the market.

Guaranteed to Run

Guaranteed to Run

All courses are assured to run on scheduled dates via all delivery methods.

MS Office Learning Resources

Explore our collection of free resources to boost your MS Office learning journey

Blogs

MS Office Expert Blogs

Explore insights from industry experts to stay ahead in tech—dive into our Expert Blogs now!

Read Blogs
Talk to Advisor