Display & Accessibility Options
Access 2007 Intermediate
Microsoft Office 2007
 Next available Norwich date: 26 April 2012   |
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 2007
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
- Attachment fields
- Multiple value fields
- Lookup fields
- Advanced field properties including Input Masks
- Multiple field primary keys
- Multiple field 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 properties
- Creating forms with subforms
- Editing sub forms
- Tabbed sub forms
- Embedding sub forms using drag & drop
Advanced Select Queries
- Filter by form
- Advanced Filter/Sort
- Convert filter to select query
- Duplicate records query
- Unmatched records query
- Working with multiple tables
- Understanding query join types
- Concatenating fields
- Calculations in queries
- Using string functions
- Using date functions
- Using the immediate if function
- Using wildcards & parameters
Advanced Reports
- Working with multiple tables
- Concatenating fields
- Date & time functions
- String functions
- Custom styles / themes
DO NOT DELETE THIS TEXT
People who attended this course, also booked:
Information & print:
