MS Access Level 2

Course: 9002

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.

Download PDF
  • Duration: 2 days
  • Price: $795.00
Get This Course $795.00
December 12 - 13

9:00 AM – 4:00 PM CST

January 16 - 17

9:00 AM – 4:00 PM CST

February 13 - 14

9:00 AM – 4:00 PM CST

March 13 - 14

9:00 AM – 4:00 PM CST

Scroll to view additional course dates

Reserve Your Seat

  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • You can use your Purchase Card and checkout
  • The GSA Contract Number: 47QTCA20D000D
  • Call 800-453-5961 for details
  • Customize your class
  • Delivery Onsite or Online for your organization
  • Choice of Dates when and where you want
  • Guidance in choosing and customizing your class

Question About this Course?

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

Question About this Course?

Need help picking the right course?

Contact Us

Call Now

Call Now800-453-5961