|
 Overview
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
What some delegates have said about this course
”I never realised Access could do so much.” - BH (Communities and Local Government)
“The trainer was great at making what seemed complicated very understandable and easy to apply.” - NO (Department for Transport)
“Perfect - just what I needed.” - PM (Department for Environment and Rural Affairs)
|
