Categories:
Microsoft Access
£290 per delegate. This may be less for special offers on specific course dates and in-company training courses
Duration: 1 day
Trainer: WC315P
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...
Course Aims:
This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced tools and concepts in Access in order to increase their knowledge and productivity.
Who Should Attend?
Users with a good understanding of Microsoft Office Access who want to expand on their capabilities in a short space of time. TSome of the lessons are quite technical and delegates must have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
Course Outline:
Advanced Data Management
- Referential Integrity
- Table Relationships
- An Introduction to SQL
- Modal Dialog Boxes
Advanced Form Tasks
- Using Subforms
- Creating a Navigation Form
- Advanced Form Controls
- Exporting a Form
- Other Form Tasks
Pivoting Data
- Creating a PivotTable
- Using PivotTables
- Advanced PivotTable Tasks
- Creating a PivotChart
- More on PivotCharts
SQL and Microsoft Access
- Understanding SQL
- Using the SELECT Statement
- Using Subqueries
- Using SQL Joins
This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced tools and concepts in Access in order to increase their knowledge and productivity.
Who Should Attend?
Users with a good understanding of Microsoft Office Access who want to expand on their capabilities in a short space of time. TSome of the lessons are quite technical and delegates must have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
Course Outline:
Advanced Data Management
- Referential Integrity
- Table Relationships
- An Introduction to SQL
- Modal Dialog Boxes
Advanced Form Tasks
- Using Subforms
- Creating a Navigation Form
- Advanced Form Controls
- Exporting a Form
- Other Form Tasks
Pivoting Data
- Creating a PivotTable
- Using PivotTables
- Advanced PivotTable Tasks
- Creating a PivotChart
- More on PivotCharts
SQL and Microsoft Access
- Understanding SQL
- Using the SELECT Statement
- Using Subqueries
- Using SQL Joins
Additional Information:
Please note that this training can focus on either Microsoft versions 2007, 2010 or 2013 - please state at the time of enquiry which version you would like this training to be held on.
Delegates can also bring their own device to take the training on - please state that you wish to do this at the time of booking so that we can inform the training provider.
This course can be offered both as an open course and as a one-to-one private session with the trainer.
| Location | Region | Start Date | Days | Price ex. VAT | ||
|---|---|---|---|---|---|---|
| Milton Keynes | East Anglia, Midlands, South Central England | Thu 25 Oct 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Portsmouth | South Central England, South East | Thu 25 Oct 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Southend-on-Sea | East Anglia, London All Areas, London East, London North, South East | Thu 25 Oct 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Trafalgar Square | London, London All Areas, London West, South East | Thu 25 Oct 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Milton Keynes | East Anglia, Midlands, South Central England | Thu 1 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Portsmouth | South Central England, South East | Thu 1 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Southend-on-Sea | East Anglia, London All Areas, London East, London North, South East | Thu 1 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Trafalgar Square | London, London All Areas, London West, South East | Thu 1 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Milton Keynes | East Anglia, Midlands, South Central England | Thu 8 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Portsmouth | South Central England, South East | Thu 8 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Southend-on-Sea | East Anglia, London All Areas, London East, London North, South East | Thu 8 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Trafalgar Square | London, London All Areas, London West, South East | Thu 8 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Milton Keynes | East Anglia, Midlands, South Central England | Thu 15 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Portsmouth | South Central England, South East | Thu 15 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Southend-on-Sea | East Anglia, London All Areas, London East, London North, South East | Thu 15 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Trafalgar Square | London, London All Areas, London West, South East | Thu 15 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Milton Keynes | East Anglia, Midlands, South Central England | Thu 22 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Portsmouth | South Central England, South East | Thu 22 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Southend-on-Sea | East Anglia, London All Areas, London East, London North, South East | Thu 22 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Trafalgar Square | London, London All Areas, London West, South East | Thu 22 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Milton Keynes | East Anglia, Midlands, South Central England | Thu 29 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Portsmouth | South Central England, South East | Thu 29 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Southend-on-Sea | East Anglia, London All Areas, London East, London North, South East | Thu 29 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Trafalgar Square | London, London All Areas, London West, South East | Thu 29 Nov 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Milton Keynes | East Anglia, Midlands, South Central England | Thu 6 Dec 18 Single day duration, date as indicated. | 1 | £290 + VAT | BOOK | ENQUIRE |
| Courses found 1 to 25 of 36 | 1 2 Next | |||||
Click location to see venue
|
Move cursor over calendar icon to see course dates
|
|||||
Telephone Hotline
01933 233884
(Monday to Friday - 8:00am to 5:30pm).
