Access Intermediate

Who should attend

IT professionals, data analysts, database users and coordinators, managers and directors, and anyone who uses Access! Access Introduction level training is recommended.

Team Pass by Learnit

Access Intermediate

From $0
Two, 2-hour Modules (9am - 11:30am PT)

In our Access training courses, students will learn how to take control of their data with software training at Learnit. Our courses will teach you basic to advanced features of Access.

Whether you are new to Access or an advanced user, our Access training courses will cover what you need to know as efficiently as possible. Learnit offers world-class training for several versions, including 2016, 2013, 2010, 2007 and earlier.

Outcomes: 

  • How Table Relationships Affect Queries 
  • Controlling Query Results with Join Types 
  • Creating Complex Queries with Multiple Criteria 
  • Calculating Data with Queries 
  • Automating Queries with Parameters 
  • Using Query Wizards 
  • Exploring Action Queries 
  • Advanced Report Design Techniques 
Course ID
ACCESSf1Po
Upcoming Available public classes
No Upcoming public classes
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am

Interested in a private
workshop for your company?

Course Outline

Module 3

How Table Relationships Affect Queries

  • Creating Relationships Between Tables
  • Add Relationship Security

Controlling Query Results with Join Types

  • How Relationships Affect Query Results
  • Using Join-Types to Affect Query Results

Creating Complex Queries with Multiple Criteria

  • Applying Wildcards
  • Using And / Or Conditions

Calculating Data with Queries

  • Create Custom Fields with Calculations 
  • Summarize Data with Grouping 

Module 4

Automating Queries with Parameters

  • Creating Automated Requests for Criteria
  • Using Wildcards in Parameter Queries
  • Using Range Operators in Parameter Queries 

Using Query Wizards

  • Getting Non-Matching Records with the Un-Matched Query Wizard
  • Finding Duplicate Records with the Duplicate Query Wizard

Exploring Action Queries

  • Create Tables with a Make-Table Query
  • Add Records to a Table with an Append Query
  • Change Data with an Update Query
  • Delete Data with a Delete Query

Advanced Report Design Techniques

  • Understanding Report Control Types
  • Grouping Report Data
  • Summarizing Report Data

Skills covered

No items found.

Access Intermediate

Reviews

Coming soon