Banner rating d5dfd02e10e7bea369b370d45102dadcf6d70e41b6bfce1ee178127969f7852a
Dynamics Edge
4.67 out of 50 stars, based on 80 reviews*

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!

Request Group Quote

Register

Price: $1390   Duration: 2 days
- EST

Course 55280

Price: $1390, Length: 2 days

55280 Advanced Microsoft Access 2019

To customize this class, call 800-453-5961 or click here to contact us

About this Course

 This Advanced Access 2019 training class is for students who intend to design databases at an advanced level and/or want to improve existing Access 2019 or Access 365 databases.

Audience profile

This course is intended for students who have basic skills with Microsoft Access 2019 who want to learn advanced-level skills or students who want to learn the topics covered in this course in the 2019 interface.

Skills gained

  • Understand database relationships.
  • Work with table relationships.
  • Work with queries at an advanced level.
  • Work with forms at an advanced level.
  • Work with reports at an advanced level.
  • Work with macros.
  • Complete the desktop application with the navigation form.

Prerequisites

  • Introductory-level knowledge and skills working with Microsoft Access.

Course outline

Module 1: Relationships

This module explains how to work with relationships in Microsoft Access.

Lessons

  • Review
  • Referential Integrity
  • Relationships
  • A Few Words about Naming Conventions

Lab : Installing and Configuring Windows 7

After completing this module, students will be able to:

  • Understand referential integrity.
  • Establish relationships between tables.

Module 2: Queries

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 : 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 table, append, update, and delete queries.

Module 3: Table Functions

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

Module 4: Forms

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

Module 5: Reports

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

Module 6: Macros

This module explains how to work with macros in Microsft Access.

Lessons

  • Macro Basics
  • Running a Macro

Lab : Creating Simple Macros

After completing this module, students will be able to:

  • Create several simple macros.
  • Run macros.

Module 7: Completing the Desktop Application

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

"We look forward to your success!!!"

*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular course offered on this page.


5528055280 Advanced Microsoft Access 2019