 |
MS Access Training |
|
| |
MS Excel Training |
|
 |
MS Word Training |
|
|
MS PowerPoint Training |
|
|
MS Project Training |
|
|
MS Visio Training |
|
|
MS Outlook Training |
|
|
|
| |
|
|
|
 |
 |
 Microsoft Access Advanced Training Course in London and UK
Let our MS Access Advanced training course will help you build better databases and also understand existing databases better. The training courses will cover more relational work, more advanced queries and advanced form and report building.
|
|
Access Advanced Course Information |
| The duration of this course is 1 Day. Training usually starts at 09:30 and lasts until 16:30 - 17:00. You will receive a Training Manual CD, course exercises and after course support all included in the cost. We offer fantastic refreshment throughout the day, like hot drinks, snacks and a selection of bottled water and soft drinks. |
|
| Select the Contact Me Now!!! button below to have a member of our team contact you regarding this course, or contact us |
|
| |
|
| |
| |
MS Access Advanced Training Course Contents |
| |
Access Advanced Training Course Contents |
| Course Objectives - To build on previous knowledge and explore advanced functionality within Access, giving delegates a greater understanding of advanced queries, forms and reports to retrieve the information required. |
Relationships |
- Why create relationships between tables?
- Different types of relationships
- Conditions for setting up a relationship
- Referential Integrity
- Cascade Update
- Cascade Delete
|
| |
More on Queries |
- Calculated fields
- Parameter Queries
- Summary Queries
- Crosstab Query Wizard
- Editing a Crosstab Query manually
- Top Values Query
|
| |
| Action Queries |
- Make Table
- Append Query
- Delete Query
- Update Query
|
| |
| Advanced Forms |
- Composite Forms including Main Form and sub forms
- Displaying Yes/No values
- Option groups
- Command buttons
- Setting form properties
|
| |
|
 |
| Advanced Forms Continues |
- Calculations within Forms
- Combining Text Values
- Changing the data source
- Keyboard Short Cuts for Fields
- Tab Order
- Adding and Removing Filters(Selection and Forms)
- Defining Validation Rules
- Template Forms
|
| |
Advanced Reports |
- Using Expressions
- Adding Sub Reports
- Parameter reports
- Rreport Templates
- The Keep Together property
- Group on and group
- nterval properties
- Advanced Grouping techniques
- Page setup
|
| |
Charts |
- Formatting a chart
- Changing the type of chart
- Parameter chart Charting based on individual record
|
|
|
|
| |
| |
| |
|
|
|
|
|
 |
Course Costs |
| 1 to 1 Training |
1 to 1 training is charged at £450 per day.This means you will have the best training possible and only focus on topics you will use and actually benifit from. Read more about the benifits of 1 to 1 training here
All our courses are closed to you. |
| |
| Groups of 2-8 |
If you need to have more than 1 person trained, then our group pricing cannot be beaten.
For 2 Delegates = £475 per day. That's less than £200 per day per delegate
For 3 Delegates = £495 per day. Thats less than £170 per day per delegate
For 4 Delegates = £595 per day. Thats less than £150 per day per delegate
For 5 to 8 delegates = £695 per day. That could be as little as £90 per day per delegate.
All prices are excluding VAT |
| |
All our courses are closed to you and your company. |
|
How to book |
Simply call us on 020 7920 9500
or
Email Us
or
use our Contact Us form
We will then confirm the course and dates with you and send joining instructions
Thats it.
Remember that you do not pay until your course has run. This ensures that you are 100% satisfied with your course. If not, we run it free or you simply do not pay.
|
 |
|
|
|
