Access Intermediate

Course Description

icon_accessThis class builds on the concepts taught in Access Basic and covers more advanced features.

Training Class Goal

Students coming from this class will have skills for developing more advanced Access databases and extracting advanced reports from their databases.

PreRequisites

Basic Access skills including: navigation, creating and using databases in both design and datasheet view, creating basic reports, queries and forms.

Topics Covered

  • Relational databases
  • Database normalization
  • Table Relationships
  • Referential integrity
  • Creating lookup fields
  • Sub-datasheets
  • Complex queries
  • Joining tables in a query
  • Using calculated fields
  • Summarizing and grouping values
  • Advanced form design
  • Adding unbound controls
  • Graphics
  • Adding combo boxes
  • Reports and printing
  • Customized headers and footers
  • Calculated values
  • Labels
  • Charts in forms and reports
  • PivotTables and PivotCharts

Upcoming Classes

Access Intermediate
Oct 4 8:00 am - 4:00 pm Access Intermediate Westminster Access Intermediate Access Intermediate Training in Denver & Phoenix   Class Price: $410 What’s included – a $900 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 04-10-2018T08:00 04-10-2018T16:00 Active
Active 04-10-2018 Active 410.00 04-10-2018
Register Now
Access Intermediate
Dec 3 8:00 am - 4:00 pm Access Intermediate Phoenix Access Intermediate Access Intermediate Training in Denver & Phoenix   Class Price: $410 What’s included – a $900 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 03-12-2018T08:00 03-12-2018T16:00 Active
Active 03-12-2018 Active 410.00 03-12-2018
Register Now
Access Intermediate
Jan 16 8:00 am - 4:00 pm Access Intermediate Tech Center Access Intermediate Access Intermediate Training in Denver & Phoenix   Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 16-01-2019T08:00 16-01-2019T16:00 Active
Active 16-01-2019 Active 450.00 16-01-2019
Register Now
Access Intermediate
Mar 5 8:00 am - 4:00 pm Access Intermediate Phoenix Access Intermediate Access Intermediate Training in Denver & Phoenix   Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 05-03-2019T08:00 05-03-2019T16:00 Active
Active 05-03-2019 Active 450.00 05-03-2019
Register Now
Access Intermediate
Apr 11 8:00 am - 4:00 pm Access Intermediate Westminster Access Intermediate Access Intermediate Training in Denver & Phoenix   Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 11-04-2019T08:00 11-04-2019T16:00 Active
Active 11-04-2019 Active 450.00 11-04-2019
Register Now
Access Intermediate
Jul 10 8:00 am - 4:00 pm Access Intermediate Tech Center Access Intermediate Access Intermediate Training in Denver & Phoenix   Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 10-07-2019T08:00 10-07-2019T16:00 Active
Active 10-07-2019 Active 450.00 10-07-2019
Register Now
Access Intermediate
Aug 12 8:00 am - 4:00 pm Access Intermediate Phoenix Access Intermediate Access Intermediate Training in Denver & Phoenix   Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 12-08-2019T08:00 12-08-2019T16:00 Active
Active 12-08-2019 Active 450.00 12-08-2019
Register Now
Access Intermediate
Oct 24 8:00 am - 4:00 pm Access Intermediate Westminster Access Intermediate Access Intermediate Training in Denver & Phoenix   Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 24-10-2019T08:00 24-10-2019T16:00 Active
Active 24-10-2019 Active 450.00 24-10-2019
Register Now
Access Intermediate
Dec 2 8:00 am - 4:00 pm Access Intermediate Phoenix Access Intermediate Access Intermediate Training in Denver & Phoenix   Class Price: $450 What’s included – a $980 value with: Face-to-face, live interactive class Retake – allows you to retake the entire... Mission Critical Systems 02-12-2019T08:00 02-12-2019T16:00 Active
Active 02-12-2019 Active 450.00 02-12-2019
Register Now

Bookings are closed for this class.

Live & In-Person

All of the classes on this page are taught by live instructors who are present in the classroom.