Access Intermediate – Standard – Full Day

$ 285.00

Class Duration: 7 Hours

Class Agenda

Morning Session 3 Hours
Lunch 1 Hour
Afternoon Session 3 Hours
Other Breaks Prescribed by Instructor

In our Access training courses, students will learn how to take control of their data. This course will teach the intermediate features of Access.

  • 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 
  • Creating Relationships Between Tables
  • Add Relationship Security
  • How Relationships Affect Query Results
  • Using Join-Types to Affect Query Results
  • Applying Wildcards
  • Using And / Or Conditions
  • Create Custom Fields with Calculations 
  • Summarize Data with Grouping 
  • Creating Automated Requests for Criteria
  • Using Wildcards in Parameter Queries
  • Using Range Operators in Parameter Queries 
  • Getting Non-Matching Records with the Un-Matched Query Wizard
  • Finding Duplicate Records with the Duplicate Query Wizard
  • 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
  • Understanding Report Control Types
  • Grouping Report Data
  • Summarizing Report Data
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

The ability to work with and analyze data is critical to the success of your organization. For decades, Microsoft Excel has been the go-to application for doing so. Begin adding it to your professional skill set with our foundational Excel course. You will learn to navigate the application confidently while creating and developing worksheets and workbooks that employ the most popular features Excel has to offer.

DETAILED COURSE OUTLINE

Getting Started with Access

Working with Table Data

Querying a Database

Using Forms

Generating Reports

“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

Event Details

Phone: (602)252-3955

Email: registration@trainingtoyou.com

Scroll to Top