Microsoft® Office Access® 2019: Part 2 Training


MS Office


Per Participant

Course Description

Microsoft Office Access: Part 2 Training expands your acquaintance with relational database design, accelerates quality input by users, enhances database efficiency, and data integrity. Further, it also implements advanced features such as queries, tables, forms, and reports as a part of our module. With the pro advancement in technicalities of Access 2019, students can end up providing robust and functional database reports to the end-users.

For a successful hike in salary and ensured promotions, complete all three Microsoft Office Access training courses. Our courses get more effective with a private on-site training session at the end of which, video tutorials are also provided. With certified instructors' guidance, our course objectives aim to use advanced format and control for improvisation to form presentation and calculate fields to modify better reports.

This technical training course primarily aims to educate students who want to gain intermediate-level skills or corporate professionals whose functional role involves constructing relational databases and tables development, forms, queries, and report presentation. Microsoft Office Access 2019 training serves all these details with its modules.

Who should attend this course?

This training recommended for the students who want to achieve intermediate skills in databases, tables, forms, reports and queries in Microsoft Office Access 2019.

microsoft logoMicrosoft Certified Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).


Oops! For this course, there are currently no public schedules available. Clicking on "Notify Me" will allow you to express your interest.

For dates, times, and location customization of this course, get in touch with us.

You can also speak with a learning consultant by calling 800-961-0337.

What you will learn

  • Utilize calculated files to improve reports in advance formatting.
  • Utilize controls and advance formatting fields for improving reports.
  • Utilize controls and advance formatting for improving presentation.
  • Summarize data and create advanced queries for joining.
  • Improving the usability of Access tables
  • Organizing a database for effectiveness and presentation, and to retain data integrity.


  • Restrict Data Input Through Field Validation
  • Restrict Data Input Through Forms and Record Validation
  • Data Normalization
  • Associate Unrelated Tables
  • Enforce Referential Integrity
  • Create Lookups Within a Table
  • Work with Subdatasheets
  • Create Query Joins
  • Create Subqueries
  • Summarize Data
  • Apply Conditional Formatting
  • Create Tab Pages with Subforms and Other Controls
  • Apply Advanced Formatting to a Report
  • Add a Calculated Field to a Report
  • Control Pagination and Print Quality
  • Add a Chart to a Report
  • With Microtek Learning, you’ll receive:

    • Certified Instructor-led training
    • Industry Best Trainers
    • Official Training Course Student Handbook
    • Pre and Post assessments/evaluations
    • Collaboration with classmates (not available for a self-paced course)
    • Real-world knowledge activities and scenarios
    • Exam scheduling support*
    • Learn and earn program*
    • Practice Tests
    • Knowledge acquisition and exam-oriented
    • Interactive online course.
    • Support from an approved expert
    • For Government and Private pricing*

    * For more details call: +1-800-961-0337 or Email: [email protected]

    Request Call

    Our Clients

    For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.

    • 300+ enterprise clients
    • 100,000+ professionals trained
    • Service 70 of the Fortune 100
    • 96% of our clients would recommend us
    our clients

    Our Awards

    our awards
    why choose us
    Accredited By

    Course Details

    • Duration: 1 Day
    • Enrolled: 1542
    • Price: $275
    side post side mode

    Talk to Learning Advisor