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

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

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: $795   Duration: 2 days

- EST

Select Date: