Information Technology
 
Access Advanced

>>DESIGNED FOR
This two day course is for those who have used Access before to create a simple one to
many relational database and need to create a database for others to use.

>>AIM
By the end of the course, delegates will be confident in creating a user friendly and
automated database.

>>OBJECTIVES
By the end of the course, delegates 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
  • Creating Macros for Command Buttons; Creating Macros for Forms
  • Creating a Report that Selects its Criteria from a Drop Down List; Creating a Report that Selects its Criteria from two Text Boxes
  • Creating a User Interface; Starting your Database at an Opening Screen
  • Compact & Repair; Data Separation; Setting a Password for your Database

>>PARTICIPANT NUMBERS

This course is run for a maximum of six delegates.

>>TIME TABLE SESSIONS

  1. Planning your Database; Recap on One to Many Relationship; Recap on Primary and Foreign Keys; Creating a Many to Many Relationship and Query
  2. Hierarchy of Objects in an Access Database; Creating Main and Sub Forms for use with Many to Many Relationships – from both sides
  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
  4. Creating a Tab Control; Adding Pages; Changing Page Names; Moving Pages; Moving and Resizing Tab Controls; Changing the Style
  5. Creating Macros for Command Buttons; Creating Macros for Forms
  6. Creating Macros for Command Buttons; Creating Macros for Forms Session 6 Creating a Report that Selects its Criteria from a Drop Down List; Creating a Report that Selects its Criteria from two Text Boxes
  7. Creating a User Interface; Starting your Database at an Opening Screen
  8. Compact & Repair; Data Separation; Setting a Password for your Database
>>REQUIREMENTS
Delegates must be confident in using Access to at least our essentials level. For
example, creating tables, creating a one to many relationship, creating queries,
reports and forms that view information across more than one table (see our Access
Essentials outline).
Back to courses  
Access Advanced