Microsoft 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 class if you need a refresher within 6 months
  • Lunch & Learn session – choose from different topics to learn something new in the future
  • Hard copy training manual – to take notes and take with you for future reference
  • Just Tips Newsletter subscription – for ongoing monthly tips to help you learn even more!

So, you’ve built a database, but now you want to do more with the information you’ve gathered.  This Intermediate Access class 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.

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. Our courses are designed specifically for companies and their employees.

Request More Information

  • Class Retakes

    If you need to retake a class you've already attended, you're welcome to take it for free up to 6 months later......Read more

  • Hands-on Learning

    We take pride in making our classes engaging and interactive because we feel hands-on learning......Read more

  • Customized Training

    When we train privately, materials may be developed to fit better the company, organization, or students......Read more

  • Individual Attention

    Because we limit our computer training classes to only 12 students and average around half......Read more

  • Live Training

    Get the most from your training investment by working with a live training instructor......Read more

  • Small Class Sizes

    Our computer training center holds only 12 students, and that’s how we like it......Read more