Microsoft Access Course - Intermediate

Intermedia Access Class

In this intermediate Microsoft Access course, you can take your Access skills to the next level and improve your efficiency with Access and relational databases. You will learn to design better relational databases, join tables, improve data structure, validate data, conduct advanced queries, organize data, and create more advanced reports. Participants will create their own relational database as part of the course.

Intermediate Microsoft Access: key topics

  • Designing a relational database
  • Joining Tables
  • Validating Data
  • Using Advanced Queries
  • Improving Data Organization
  • Understanding Advanced Reporting Options

Questions about this intermediate Microsoft Access class? Interested in a private or customized training? Call to speak with a training consultant: 781-376-6044.

Ways to attend this Microsoft Access Course

  • Live Online classes from your office or home as a regularly scheduled small group class.
  • Live, in-person regularly scheduled Microsoft Access classes in Boston or Philadelphia with a live instructor in the same classroom.
  • Private training customized to your specific needs delivered in-person or online. Call 781-376-6044 or complete the Private Microsoft Access Training form for more information.

Why Microsoft Access classes at AGI are the best option for you

  • Hands-on learning: Learn Microsoft Access quickly with our proven teaching methods.
  • Exceptional curriculum: AGI has delivered Microsoft Access training to thousands over 25 years.
  • Expert instructors: Our instructors are Microsoft Access experts and skilled educators.
  • Small class sizes: Receive personalized attention with 10 or fewer participants per class.
  • Repeat for Free: If you need a refresher or miss a class day, retake the Microsoft Access class at no cost.
Instructor working with student in Microsoft Access class.
All Microsoft Access classes include

free retakes of courses Free retake

Curriculum provided Detailed curriculum

Live instructor Live instructor

flexible rescheduling Flexible rescheduling

flexible rescheduling Certificate of Completion

small class Small class sizes

course recording Course recording

Please call 800-851-9237 or 781-376-6044 to schedule a course.

Contact AGI to request course dates.

Intermediate Microsoft Access Course: complete class topics

Designing Relational Databases

  • Fundamentals of Relational Database Design
  • Creating Tables
  • Creating Table Relationships

Joining Tables in Access

  • Creating Query Joins
  • Relating Data Within a Table
  • Working with Subdata sheets

Using Access Data Validation

  • Validating Fields
  • Using options for Form and Record Validation

Creating Advanced Queries in Access

  • Creating Parameter Queries
  • Summarizing Data
  • Creating Subqueries
  • Creating Action Queries
  • Creating Unmatched and Duplicate Queries

Organizing an Access Database for Efficiency

  • Data Normalization
  • Create Junction Tables
  • Improving Table Structure

Using Advanced Reporting Techniques in Access

  • Including Control Formatting in Reports
  • Adding Calculated Fields to Reports
  • Add a Subreport to Existing Reports

Microsoft Access course instructors

AGI instructors are Microsoft Access professionals and skilled teachers. You'll learn from a live Microsoft Access professional that brings years of experience that will help you learn Microsoft Access quickly and easily.

Grace
Grace

MS, Information Design

BA, Digital Communications

Adjunct Professor, St. Olaf

Elizabeth
Elizabeth

BS, Finance

Teaching Assistant, Virginia Tech

Accounting & Finance Roles

Carol
Carol

BBA, Technology

Microsoft Certified

Custom and private Microsoft Access classes

This Microsoft Access course is available as a private class. Curriculum can be customized for your specific needs. Microsoft Access classes can be delivered at your location, online, or in our classrooms. For more information, call 781-376-6044 to speak with a training consultant or contact us.

We recommend that you have Microsoft Access installed on your computer before starting this class.

You will receive a comprehensive course manual for this Intermediate Access class developed by the instructors at AGI. AGI instructors have created many of the official training guides and books for Microsoft.

Available Delivery Methods For This Class

CLASSROOM
LIVE ONLINE
PRIVATE
MY LOCATION