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.
You will learn in a relaxed environment with a small group of people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.
Included with your course
We provide the following with online and training centre delivered courses.
- Course notes
- Certificate of attendance
- 90 days post course support
Online Delivery
A link to the online training platform will be sent before the course, simply click the link and follow the instructions.
- See Virtual / Remote training information for more details
- Contact us if you'd like to test the platform before the morning of the course
- You can be located anywhere in the world with an internet connection and your computer
Our Training Centres
For training courses run at one of our training centres we include.
- Free onsite parking
- Lunch and refreshments
- Notepad, pen and Polos
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.