MS Access 2002 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 similar 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.


Access 2002 Intermediate Training CourseAccess 2002 Intermediate Training Course

Audience: This course is designed for existing Access users with sound basic skills. The course will focus more on Queries, Forms and reports. We also cover more advanced relationships.

Access 2002 Intermediate Course Objectives: After the course, you will be able to:

Requirements: You must have sound Access skills and understand key concepts of a database, equivalent to our intermediate course contents

Course Duration

This is a 1 day Access 2002 training course. The course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This Access 2002 Intermediate course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Access 2002 Intermediate Training Course Contents

Relationships

  • Why create relationships between tables?
  • Different types of relationships
  • Conditions for setting up a relationship
  • Referential Integrity
  • Cascade Update
  • Cascade Delete

Advanced Queries

  • Calculated fields
  • Parameter Queries
  • Summary Queries
  • Crosstab Query Wizard
  • Editing a Crosstab Query manually
  • Top Values Query
  • Make Table Query
  • 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
  • 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
  • Report Templates
  • The Keep Together property
  • Group on and group interval properties
  • Advanced Grouping techniques
  • Page setup

Charts and Pivots

  • Formatting a chart
  • Changing the type of chart
  • Parameter chart Charting based on individual record
  • Creating Pivots

 

Evening Courses More 2002 Courses

What can I expect?

Training Course FormatsFormats / Locations

Course BookingHow to book your course

Course Cost Explained

Ms Office Courses are charged at a flat rate per day.

One to One - Charged at £450 per day

Group Onsite Training - Charged at £695 per day

Training at our training centre - Charged at £695 per day

MS Office Only

Technical Applications POA

Tips & Tricks

 

Get usefull tips and tricks with your favourite RSS Feed

 

Let us contact you. Simply select the button below and a member of our team will contact you back.

 

 


www Mouse