Microsoft Access Training Course

Access 2010 Advanced 

This course is for anyone who has used Access before to create a simple one to many relational database. (This course does not cover programming). Delegates must be confident in using Access to at least our essentials level. For example, creating tables, creating and making a one to many relationship, creating queries, reports and forms that view information across more than one table. By the end of the course, you will be confident in creating a more user friendly and automated database.

Available for Private and Tailored group events

This course is run privately for groups or 1-2-1 Coaching sessions

Book a 1-2-1 Session or Group Event

Course Location

Happy London, Aldgate or at your premises.

Course Requirements

Delegates must be confident in using Access to at least our essentials level.

What You Will Learn

In particular you will be able to:

  • Create a many to many relationship
  • Create a user friendly form based on a many to many relationship
  • Create a list of choices for keying and viewing information
  • Create a form with tabs on to view lots of information easily
  • Use features like command buttons and macros to automate your forms
  • Create automated forms to run reports and queries
  • Create a menu system for your database to make it more user friendly
Enquire now

Timetable

Day 1

Session 1

Planning your Database; Recap on One to Many Relationship; Introduction to Many to Many Relationship; Recap on Primary and Foreign Keys; Creating a Many to Many Relationship and Query.

Session 2

Hierarchy of Objects in an Access Database; Creating Main and Sub Forms for use with Many to Many Relationships – from both sides.

Session 3

Combo Boxes; Field Properties; Combo Boxes using more than one Field; Combo Boxes to Find Records; Command Buttons to View one Record in a Form.

Session 4

Creating a Tab Control; Adding Pages; Changing Page Names; Moving Pages; Moving and Resizing Tab Controls; Changing the Style.

Day 2

Session 1

Creating Macros for Command Buttons; Creating Macros for Forms.

Session 2

Creating a Report that Selects its Criteria from a Drop Down List; Creating a Report that Selects its Criteria from two Text Boxes.

Session 3

Creating a User Interface; Starting your Database at an Opening Screen.

Session 4

Compact & Repair; Data Separation; Setting a Password for your Database.


SMALL PRINT

The course will run from 10am to 4:45pm (light cold buffet 1pm to 1:45pm). Please be careful to arrive by 9.45am for registration and refreshments. The course will start precisely on time and it may not be possible to go back over material missed by late arrivals. If you arrive over 30 minutes late you may be asked to leave and attend another day.

Your Course Trainers

Darren Andrews

Darren Andrews

Darren manages the IT helpline, as well as training almost every IT course on the Happy computers programme. He has been with Happy for nearly 9 years.

Ed Lepre

Ed Lepre

Ed has been an IT trainer with Happy for nearly 11 years. His favourite package is Excel - which he trains to advanced level. He is also the new IT Helpline Manager (when he's not training).