It looks like you're using IE11...
This browser offers limited functionality on our website. We recommend you use the latest version of Chrome, Safari, Edge and Firefox.
One day: 9.30am to 4.30pm
Microsoft Access is a database software application. It is a tool for storing information which can then be retrieved using reports and queries.
The Intermediate Access course introduces the user to some of the more complex functionality of Access. The properties of the fields in a table are formatted so to restrict the data that can be entered. Sub Forms are created to enter information. Queries are produced using prompts and wildcards and reports created to summarise information.
Attendance at a Basic Access course or an understanding of creating tables and queries within Access.
Exercise | Details |
---|---|
Exercise 1 | Creating an Access database
|
Exercise 2 | Amending the design of the table
|
Exercise 3 | Creating tables
|
Exercise 4 | Importing a table
|
Exercise 5 |
Creating relationships
|
Exercise 6 |
Adding data to tables
|
Exercise 7 |
Creating simple forms
|
Exercise 8 |
Creating subforms
|
Exercise 9 |
Creating queries in design view
|
​Exercise 10 |
Creating queries using multiple tables
|
Exercise 11 | Using parameter queries and wildcards
|
Exercise 12 | Creating reports (grouping and summarising data)
|
Exercise 13 | Grouping and summarising using the report wizard
|
After completing this course you will be able to:
You will complete all of these using Microsoft Access.
External attendees: £110 plus VAT per candidate.