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.

Database Relationships

  • A Look At Relationships
  • Creating A One-to-One Relationship
  • Creating A One-to-Many Relationship
  • Creating A Many-to-Many Relationship
  • Enforcing Referential Integrity
  • Cascade Update Related Fields
  • Cascade Delete Related Records
  • Creating And Printing A Relationship Report

Working With Tables

  • Setting Validation Rules
  • Formatting Fields
  • Indexing Fields
  • Requiring Data Entry
  • Creating An Input Mask
  • Creating A Lookup Field
  • Creating A Value List
  • Modifying A Value List
  • Creating Calculated Fields
  • Creating Multiple Primary Keys
  • Creating Multiple Field Values

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
  • Creating A Find Duplicates Query
  • Creating A Find Unmatched Records Query
  • Modifying Query Joins

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 Properites
  • Changing The Tab Order
  • Adding A Lookup Control
  • Inserting Graphics
  • Creating A Subform

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 Reports's Data Source
  • Sorting And Grouping Data
  • Changing Report Section Properties
  • Inserting Graphics
  • Applying A Theme To A Report
  • Applying Conditional Formatting

Prerequisites:

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

Access classes are offered at four locations: