MS Office Training Course Provider
 
Go to Mouse Training Home Page All Software,  Computer and IT Training Courses in London and the UK Personal Development and Management Training Courses Bespoke System Training Experts in London MS Office - Excel, Access, Word and PowerPoint Consultancy in London All Mouse Training Services About Mouse Training - The Best London Training Course Provider Contact the Experts - Mouse Training!

London Training Courses

Microsoft Courses

IT Training Courses

Mac Office Courses

IT Training Courses

Adobe Courses

IT Training Courses

More Courses

IT Training Courses

Google Docs Courses

IT Training Courses

Get Expert Tailored Training Solutions

 
MS Office Training Provider

MS Access 2000 Intermediate  Training in LondonMS Access 2002 Intermediate Training Course in London

Our MS Access 2002 Intermediate course will provide users that have existing introduction level skills in Access to build on their knowledge. The intermediate course will focus on building more complex queries, better forms and reports. You will also cover more on table relationships and query joins for your relational database.

To maximize the gain you receive from our MS Access 97 Intermediate training course, it is recommended that you have attended our MS Access Introduction course or that you are at a similiar level

Unlike training companies offering scheduled courses, we offer the alternative of your Microsoft Access Training Course delivered in central London on a date of your choice, either onsite or at our offices near Moorgate, Bank or Liverpool Street either 1 to 1 or as part of a group.


If this sounds like the training course you require, then please contact us on 020 7920 9500 or click the Contact Me Now button below. A member of our team will get back to you asap.

 
 

MS Access Logo Microsoft Access 2002 Intermediate

 

Microsoft Access Intermediate Training Course

Duration - This is a 1 day course starting at 09:30 until 16:30 each day
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
 
MS Access Training Courses - All versions and Levels
 
Access 2007 Introduction
Access 2007 Intermediate
Access 2007 Adavanced
Access 2007 VBA
 
Access 2003 Introduction
Access 2003 Intermediate
Access 2003 Advanced
Access 2003 VBA
 
Access 2002 Introduction
Access 2002 Intermediate
Access 2002 Advanced
Access 2002 VBA
 
Access 2000 Introduction
Access 2000 Intermediate
Access 2000 Advanced
Access 2000 VBA
 
Access 97 Introduction
Access 97 Intermediate
Access 97 Advanced
Access 97 VBA
 
How to book your course

How to book

  • Contact us via email or call us on 020 7920 9500
  • We agree a date and course outline with you
  • Confirmation takes place by email or phone
  • That's it!

Contact Us for Training course advice and tailoring

Training Course Costs On-Site

Training Course Info

You can also download our MS Office Training Manuals for Microsoft Office 2000, 2002(XP) and 2003

Training Course Costs On-Site

Course Costs

1-to-1 training courses are charged at £450 per day. (Our offices or your venue)

All IT training courses at our offices are charged at a daily rate of £695 per day, for 2 to 8 delegates.

We also offer training at your venue for £595 per day. If required, laptops are available at an additional £150 per day.

For courses outside the M25, trainer travel and accomodation expenses are not included in the above prices but are charged at cost.
Get an Instant Quote for your training course

On-site Training Course Quote

Build your course

With our course builder form, you can choose your own topics and build a course that suits your needs and your time scale. Select a application below to go to the Course Builder page

Custom Course Builder

Tailored Access  Training Courses Access
Tailored Excel Training Courses Excel
Tailored PowerPoint  Custom Training Courses PowerPoint
Tailored Word Custom Training Courses Word
Tailored Project Custom Training Course Project
Outlook Custom Training Course Outlook
Visio Custom Training Course Visio
Publisher Custom Training Course Publisher
Home | Software Training | Soft skills Training | Bespoke Training | Consultancy | Services | About Us | Contact Us | Privacy Statement | Links | Sitemap © 2007 MTC All rights reserved