Advanced Microsoft Access

Who is this course for?

This course is designed to provide you with an understanding of the data analysis and reporting functionality within Microsoft Access. It will benefit you if you are familiar with Access and would like to expand your knowledge.

What are the benefits

On completion of this course, you will be able to create, select, multi table, calculative, crosstab and action queries. You will know how to turn your data into Pivot Tables and Pivot Charts. You will learn how to present data by designing professional reports and forms and create macros to automate actions.t

Enquire about this course

Course Enquiry

Please type your full name.
Invalid email address.
Invalid email address.
Invalid Input

Course Duration

1 Day

Course Content

Recap of Essential Skills

Relationships and Specialist Queries

  • Relational database design
  • One to many relationships
  • Many to many relationships
  • Joins in queries
  • Understanding inner and outer joins

Advanced Queries

  • Parameter queries
  • Summary queries
  • Calculated queries
  • Crosstab queries

Action Queries

  • Make table queries
  • Delete queries
  • Append queries
  • Update queries
  • Cross tab queries

Form and Report Design

  • Features of forms & reports
  • Creating sections
  • Moving, resizing and deleting controls Adding controls
  • Controlling Properties
  • Unbound and bound controls
  • Sub forms and Sub reports
  • Command buttons

Pivot Tables and Pivot Charts

  • Creating Pivot Tables
  • Modifying Pivot Tables
  • Pivot Charts

Macros

  • AutoExec Macros
  • Adding Macros to command buttons
  • Creating a switchboard
  • Switchboard display options
  • Hyperlinks

What our users say

 

  • A very good course, trainer had good knowledge and delivered well
  • I like the fact that you have selected topics/functions on the basis of their interest/possible use - course is much more than pertinent and a better use of time
  • Very friendly and helpful trainer
  • Ray is the only IT Trainer who has ever inspired me with enough confidence to learn effectively
  • It was very good, I really enjoyed it and learnt a lot
  • I will definitely use the Pivot Tables at work in the future! Thank you for such a great training day!
  • Will ensure my team all attend (they all work remotely)
  • Exactly what I was hoping to learn, thanks

  • Contact Us
  • 44 (0) 208 681 1485
  • 44 (0) 7794 0689 6985

E Mail Us