The tools, tips & techniques for enhancing your existing database

This one day intensive course is designed to give existing users of Access an insight into some of the more advanced features in Access. This entirely 'hands on' course will give participants a further understanding of database design principles, advanced forms, reports and query design, including using calculations. It will also show customisation of the database through command buttons, macros and customised menus, and Internet publishing.

What you will gain

You will gain the ability to develop your database further and enhance your database development skills using the advanced features of Access to create an automated, interactive database system.

Who should attend this course?

You should attend this course if you are currently using an Access database and wish to enhance it with Access advanced features. It is expected that anyone attending this course will have completed an Access Intermediate course or has sufficient knowledge of Access through regular use.

Course Objectives

This course covers the following key topics: -

  • Advanced Database Elements
  • Designing a Relational Database
  • Setting Table Relationships
  • Using Lookup Fields
  • Creating Relational Queries
  • Summary and Crosstab Queries
  • Advanced Forms Features
  • Customising Reports
  • Importing, Exporting and Linking Data
  • Customising Access Menus and Toolbars
  • Macros and Command Buttons
  • Hyperlinks and Internet Publishing
  • Database Management Tools
  • Multi-User Databases

 Booking Form 

Duration:
Course Code:
Delegate Cost:
1 day
MA3
£210 + VAT
Other courses you may like:

Microsoft Access Introduction 
Microsoft Access Intermediate 

Book this course for in-house delivery
 Request Now 
What others said about this course  
Very good trainer, easy going & informative. SS (DCLG)
Just what I needed to help me create my own database. Thanks. IH (Department for Transport)
Very impressed with the attention from the trainer and the fact that we can still contact Alpha after the course if we have any problems. JG (Cabinet Office)

Course Finder 

Call us now for further information

0844 33 505 87


Course Finder


Copyright © 2014 Alpha Consolidated Training Limited. All Rights Reserved.