Microtek Learning Logo

55280: Advanced Microsoft Access 2019 Training

4.5
(4.5)

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.

  • Accredited By : Microsoft Partner Logo
  • Category : MS Office

Course Price : $799 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.

 

Training Exclusives

  • Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
  • Access to Microsoft Official Courseware (MOC).
  • Real-time Virtual Lab Environment.
  • Experience 24*7 Learner Support.
  • Self-paced learning and flexible schedules.
Microsoft Course Microsoft Course
500+

Courses

experience experience
20+

Years of Experience

learners learners
95K+

Global Learners

What you will learn

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

Prerequisites

  • 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 Learning 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

  • Dec 14, 2023
  • 9:00 am - 5:00 pm EST
  • online

Can’t Find The Batch You’re Looking For?

Request a Batch

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.
  • Course Details

    • enroll enroll-green
      Enrolled: 1324
    • duration duration green
      Duration: 2 Days

    Talk to Learning Advisor