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.
Two days: 9.30am to 4.30pm
The Access Advanced course introduces many of the more advanced tools available in Microsoft Access. It has been designed for users who are proficient in the functionality of Microsoft Access to help them realise the full potential of the database tool.
The course covers various new topics including the use of macros, advanced queries, formulas in reports, linking tables, forms and sub forms. It also covers some of the functions available within Access.
Attendance on Access course or extensive knowledge of Access.
Check points:
Exercise | Details |
---|---|
Exercise 1 | Modifying data types
|
Exercise 2 | Modifying data types
|
Exercise 3 | Linking tables
|
Exercise 4 | Select queries
|
Exercise 5 |
Select queries
|
Exercise 6 |
Creating subtotals within queries
|
Exercise 7 |
Identify key values using queries
|
Exercise 8 |
Using the Crosstab Query
|
Exercise 9 |
Using wildcards within queries. |
​Exercise 10 |
Using parameters within queries. |
Exercise 11 | Combining wildcards and parameters within the same query. |
Exercise 12 | Using Null in queries
|
Exercise 13 | Using Not in queries
|
Exercise 14 | Using Not or Null in queries
|
Exercise 15 | Using Arithmetic Expressions within queries
|
Exercise 16 |
Find duplicates query
|
Exercise 17 | Show Unmatched Values Query
|
Exercise 18 | Update Query
|
Exercise 19 | Delete Query
|
Exercise 20 | Make Table Query
|
Exercise 21 | Make Table Query
|
Exercise 22 | Append Query
|
Exercise 23 | Join Properties
|
Exercise 24 | Join Properties
|
Exercise 25 | Join Properties
|
Exercise 26 | Creating Forms
|
Exercise 27 | Changing controls within forms Modifying controls within a form. |
Exercise 28 | Adding controls within a form
|
Exercise 29 | Adding Controls within a form
|
Exercise 30 | Using Formulas in forms
|
Exercise 31 | Using formulas in forms
|
Exercise 32 |
Creating a subform
|
Exercise 33 |
Embedding a Subform
|
Exercise 34 |
Tab Order on Forms
|
Exercise 35 |
Creating a Report
|
Exercise 36 |
Using Arithmetic Formulas in reports
|
Exercise 37 |
Using Formulas in Reports
|
Exercise 38 |
Using Functions in Reports
|
Exercise 39 |
Using percentages in reports
|
Exercise 40 |
Using Functions in reports
|
Exercise 41 |
Using Running Totals in reports
|
Exercise 42 |
Formulas in Reports
|
Exercise 43 |
Creating an opening screen
|
Exercise 44 |
Creating macros
|
Exercise 45 |
Using macros in forms
|
Exercise 46 | Using macros in forms
|
Exercise 47 |
Creating buttons using the wizard
|
Exercise 48 | Using the maximize macro in a form
|
Exercise 49 | Exporting and importing data
|
After reading this manual you will be able to:
You will complete all of these using Microsoft Access.
External attendees: £170 plus VAT per candidate.