If you find your database needs more than 4 or 5 tables or you're queries aren't as easy to create as you think they should be, then you will benefit from this course.
It is a natural progression from our Access Introduction course, but this is not a prerequisite if you have existing knowledge and experience of Access.
Course Introduction
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
- Split forms
- Creating forms with sub forms
- 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
The course runs from 9:30am through to 4:30pm. Refreshments are available from 9am.
We provide:
- Full course material
- Certificate of attendance
- 90 days post course support
- Note pad and pen
- Polos!
Also includes:
Our Norwich on-site parking (NR3 1UB) is free and situated 5 minutes walk along the river to our training centre at St James Mill. If you arrive by train it is about 20 minutes on the Riverside walk or a short taxi ride to get to us. View full directions for Norwich and all our other venues.
You will learn in a relaxed environment with a small group of up to 8 people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.
Download the full course profile: Access Intermediate 