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 PartnerMicrosoft 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

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.

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