Access Intermediate Class

Microsoft Access is a powerful data management tool in which one can consolidate and track various types of inter-related information, and generate reports to analyze the data in order to make better business decisions. AcademyX's Access Intermediate class will take you beyond the basics, giving you experience with Access's more advanced capabilities. Upon completing this course, you will be thoroughly versed in the precepts of data normalization and effective database design, so that you can quickly author sophisticated queries to seek exactly the necessary data to answer complex business problems. Students will also learn to create forms which are well-suited to the users' perspectives and needs, and create charts and graphs which express the data with visual impact and clarity. Our instructors will share their broad base of Access experience, in order to help you attain the practical knowledge and skills necessary to put the advanced functionality of this data management system to work for you.

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

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


  • A solid understanding of Windows file management, the concepts of right-clicking and selecting object properties
  • Successful completion of Access Introduction class or equivalent experience providing a basic understanding of tables, queries, forms and reports

Access classes are offered at these locations and online: