Access 2019 Level 2 – Intermediate.

Course 100002

Access 2019 Level 2 – Intermediate.


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

Access 2019 Level 2

Access 2019 Level 2 – Intermediate

Access 2019 Level 2 – Intermediate. Versions 2013, 2016, 2019, Office 365, & Online are also available. This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access 2019.

Course Outline

Lesson 1 – Database Relationships

  • a Look at Relationships
  • Creating a One-To-One Relationship
  • Creating a One-To-Many Relationship
  • How to 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
  • How to create a Value List
  • Modifying a Value List
  • Creating Calculated Fields
  • Creating Multiple Primary Keys
  • Create 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
  • Create 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
  • How to Change 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

 

Do not hesitate to Contact Us or Live Chat if you have questions or concerns about Access 2019 Level 2 – Intermediate.

Additional information

dates

05/03/2021 (Live Virtual) $795, 06/07/2021 (Live Virtual) $795, 07/12/2021 (Live Virtual) $795, 08/09/2021 (Live Virtual) $795, 09/06/2021 (Live Virtual) $795, 10/04/2021 (Live Virtual) $795, 11/08/2021 (Live Virtual) $795, 12/13/2021 (Live Virtual) $795

Train Your Team

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 - Choose Date


$795.00

Clear
Number of Seats: