Display & Accessibility Options
Access Intermediate
Microsoft Office 2000, 2002, 2003
 Next available Norwich date: 23 September 2010   |
Course Aims:
This course is designed to provide delegates with the knowledge and skills needed to handle the intermediate features of Access.
In particular, delegates will learn how to work with relational tables and how to manipulate the advanced features of forms, reports and queries.
Assumed Knowledge:
Delegates must have a good working knowledge of Access. They must be regular users who have built Access databases. They must be able to create and maintain basic tables, forms, queries and reports. It is an advantage to have attended the Jarrold Training Access Introduction course.
Version:
Microsoft Office 2000, 2002 or 2003
What people say:
Well designed course, with plenty of interaction that ensured concentration levels remained high and that the course was enjoyable.
Royal Bank of Scotland - Jan 2010
Special Offer
Book one person onto the Access Intermediate and Access Advanced course and receive £30 off the total price.
Profile Outline:
Course Introduction
- Revision exercise
Advanced Table Design
- Advanced field properties including Input Masks
- Multiple field primary keys
- Multiple field indexes
- Documenting indexes
- Using the Access Documenter
Relational Concepts
- Relational concepts & rules
- Data structure principles
- Types of relationship
- Referential integrity
- Relating tables
Multiple Tables and Forms
- Using a combo box in forms
- Combo box properties
- LookUp fields in tables
- LookUp properties
- Creating forms with subforms
- Editing subforms
- Embedding subforms using drag & drop
Advanced Select Queries
- Working with multiple tables
- Calculations in queries
- Using wildcards & parameters
- Understanding query join types
Advanced Reports
- Working with multiple tables
- Concatenating fields
- Date & time functions
- String functions
DO NOT DELETE THIS TEXT
Profile Details:
-
Price: £165.00 
Duration: 1 day
Norwich Dates:
-
23 September 2010
Links:
People who attended this course, also booked:
Information & print:
