Name: 55280: Advanced Microsoft Access Training
Brand: Microtek Learning
Price: 995 USD
Rating: 4.5 (1324 reviews)

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

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

📘 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.