55280: Advanced Microsoft Access 2019 Training

Category

MS Office

Rating
4.5
(4.5)
Price

$499
Per Participant

Course Description

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 2019 training course.

Prerequisites for this training

  • Microsoft Access knowledge and proficiency at the beginner level.

Who should attend this course?

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

Microsoft 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).

Schedules

GTR

Mar 30, 2023

9:00 am - 5:30 pm EST
Online

Apr 13, 2023

9:00 am - 5:30 pm EST
Online
GTR

Apr 27, 2023

9:00 am - 5:30 pm EST
Online

May 11, 2023

9:00 am - 5:30 pm EST
Online
GTR

May 25, 2023

9:00 am - 5:30 pm EST
Online

Jun 08, 2023

9:00 am - 5:30 pm EST
Online

Jun 22, 2023

9:00 am - 5:30 pm EST
Online
Request Batch

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.

Curriculum

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.
  • 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: info@microteklearning.com

    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

    REVIEWS ON OUR POPULAR COURSES

    male

    I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.

    MARTIN

    TORONTO, CANADA

    • (5)
    male

    I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.

    Prince N.

    Texas

    • (5)
    male

    I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.

    Marsh George

    Texas

    • (5)
    Accredited By

    Course Details

    • Start Date: Mar 30, 2023
    • Duration: 2 Days
    • Enrolled: 1324
    • Price: $499
    side post side mode

    Talk to Learning Advisor