600 Maryland Avenue, S.W.,
Washington, DC 20024-2520



Or find a course by:

Microsoft Access 2010: Intermediate

Home / Course Details

  • ORegistration open
  • FClass full
  • GGuaranteed to Go
  • RRemote Classroom
Multiple Registrations?
Session Schedule Location Tuition Status
Contract to bring this course to your location

Click here for more information

Course overview

This course covers intermediate functions of Access 2010. The students learn how to create table relationships and then apply normalization principles to the tables to ensure the data is divided into the proper fields. Students will then process data by using multiple tables in other Access objects. They also will be introduced to Lookup tables, Query Joins, Sub datasheets, Sub forms, and Sub reports.

Who should attend?

Individuals with a basic understanding of Microsoft Access 2010 who would like to expand their knowledge.

Learning outcomes

  • Explore database normalization and create table relationships
  • Use sub datasheets to enter data in multiple tables simultaneously
  • Create calculated fields and summarize and group values in queries
  • Adding calculated values and combo boxes to a form
  • Examine advanced form types such as multiple items, split forms, and datasheet forms
  • Create charts in forms and reports
  • Understand how to creating and modifying PivotTables and Pivot Charts

Chat Now