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

Purchase

Price: $795   Duration: 2 days
- EST
Select Date:
Number of Seats:

Course 100002

Price: $795, Length: 2 days

Access 2019 Level 2 - Intermediate. Versions 2013, 2016, Office 365, & Online are available

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

Access 2016, Level 2 - Intermediate

Versions 2013, 2016, 2019, Office 365, & Online are also available.

Course Outline

Lesson 1 - Database Relationships

  • a Look at Relationships
  • Creating a One-To-One Relationship
  • Creating a One-To-Many Relationship
  • Creating a Many-To-Many Relationship
  • Enforcing Referential Integrity
  • Cascade Update Related Fields
  • Cascade Delete Related Records
  • Creating & Printing a Relationship Report

Lesson 2 - Working with Tables

  • Setting Validation Rules
  • Formatting Fields
  • Indexing Fields
  • Requiring Data Entry
  • Creating an Input Mask
  • Creating a Lookup Field
  • Creating a Value List
  • Modifying a Value List
  • Creating Calculated Fields
  • Creating Multiple Primary Keys
  • Creating Multiple Field Values

Lesson 3 - Working with Queries

  • Creating Multi-Table Queries
  • Using Calculations in Queries
  • Changing Query Properties
  • Working with the Expression Builder
  • Creating a Totals Query
  • Creating a Parameter Query
  • Creating a Find Duplicates Query
  • Creating a Find Unmatched Records Query
  • Modifying Query Joins

Lesson 4 - Working with Forms

  • Adding Headers and Footers
  • Adding Controls to a Form
  • Moving and Sizing Controls
  • Creating a Calculated Control
  • Changing Control Properties
  • Changing Form Properties
  • Changing the Tab Order
  • Adding a Lookup Control
  • Inserting Graphics
  • Creating a SubForm

Lesson 5 - Working with Reports

  • Working with Report Sections
  • Adding Controls to a Report
  • Changing Control Properties
  • Creating a Calculated Control
  • Changing a Control’s Data Source
  • Changing a Report’s Data Source
  • Sorting and Grouping Data
  • Changing Report Section Properties
  • Inserting Graphics
  • Applying a Theme to a Report
  • Applying Conditional Formatting

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.


100002Access 2019 Level 2 - Intermediate. Versions 2013, 2016, Office 365, & Online are available