Access Intermediate

Course Description

Access Intermediate Training in Denver & Phoenix

 

So, you’ve built a database, but now you want to do more with the information you’ve gathered.  This Intermediate Access training in Denver & Phoenix builds on the concepts taught in Access Basic and covers more advanced features. You will be able to build more customized forms and employ more complex queries.  This class will also teach you how to display the information generated in reports in more visually dynamic charts, as well as explore data relationships with pivot tables.  You will get plenty of interactive experience to ensure you have mastered each lesson, and our instructors will be there lead you to a full understanding of the material and answer all of your questions.

Class Price: $410

Access Intermediate Training Class Goal

Students who complete this Intermediate Access training class will be able to develop more advanced Access databases, as well as extract advanced reports from their databases. This course will enable students to explore the complex relationships between data sets.  Relational databases are introduced. Students will learn to use graphics, PivotTables and charts to give their data visual impact.  This Intermediate Access course will give the student a confident proficiency of this database application.

Prerequisites

Students should enter this Intermediate Access training course with Basic Access skills including navigation, creating and using databases in both design and datasheet view,  and creating basic reports, queries, and forms.

Topic 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 Pivot Chart

Mission Critical’s Intermediate Microsoft Access training class will empower you to get more out of your databases with this powerful application.

Upcoming Classes

Access Intermediate
Mar 1 8:00 am - 4:00 pm Access Intermediate Phoenix Access Intermediate Access Intermediate Training in Denver & Phoenix   So, you’ve built a database, but now you want to do more with the information you’ve gathered.  This Intermediate Access training in... Mission Critical Systems 01-03-2018T08:00 01-03-2018T16:00 Active
Active 01-03-2018 Active 410.00 01-03-2018
Register Now
Access Intermediate
Apr 17 8:00 am - 4:00 pm Access Intermediate Tech Center Access Intermediate Access Intermediate Training in Denver & Phoenix   So, you’ve built a database, but now you want to do more with the information you’ve gathered.  This Intermediate Access training in... Mission Critical Systems 17-04-2018T08:00 17-04-2018T16:00 Active
Active 17-04-2018 Active 410.00 17-04-2018
Register Now
Access Intermediate
Jun 1 8:00 am - 4:00 pm Access Intermediate Tech Center Access Intermediate Access Intermediate Training in Denver & Phoenix   So, you’ve built a database, but now you want to do more with the information you’ve gathered.  This Intermediate Access training in... Mission Critical Systems 01-06-2018T08:00 01-06-2018T16:00 Active
Active 01-06-2018 Active 410.00 01-06-2018
Register Now
Access Intermediate
Jun 5 8:00 am - 4:00 pm Access Intermediate Phoenix Access Intermediate Access Intermediate Training in Denver & Phoenix   So, you’ve built a database, but now you want to do more with the information you’ve gathered.  This Intermediate Access training in... Mission Critical Systems 05-06-2018T08:00 05-06-2018T16:00 Active
Active 05-06-2018 Active 410.00 05-06-2018
Register Now
Access Intermediate
Aug 27 8:00 am - 4:00 pm Access Intermediate Westminster Access Intermediate Access Intermediate Training in Denver & Phoenix   So, you’ve built a database, but now you want to do more with the information you’ve gathered. This Intermediate Access training in Denver... Mission Critical Systems 27-08-2018T08:00 27-08-2018T16:00 Active
Active 27-08-2018 Active 410.00 27-08-2018
Register Now
Access Intermediate
Sep 18 8:00 am - 4:00 pm Access Intermediate Phoenix Access Intermediate Access Intermediate Training in Denver & Phoenix   So, you’ve built a database, but now you want to do more with the information you’ve gathered.  This Intermediate Access training in... Mission Critical Systems 18-09-2018T08:00 18-09-2018T16:00 Active
Active 18-09-2018 Active 410.00 18-09-2018
Register Now
Access Intermediate
Oct 4 8:00 am - 4:00 pm Access Intermediate Westminster Access Intermediate Access Intermediate Training in Denver & Phoenix   So, you’ve built a database, but now you want to do more with the information you’ve gathered. This Intermediate Access training in Denver... 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   So, you’ve built a database, but now you want to do more with the information you’ve gathered.  This Intermediate Access training in... Mission Critical Systems 03-12-2018T08:00 03-12-2018T16:00 Active
Active 03-12-2018 Active 410.00 03-12-2018
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.