MS Access 2003 Intermediate

Mouse Training

Training

In London

Price on request

The best Access courses

See all

See all

Description

  • Type

    Training

  • Level

    Intermediate

  • Location

    London

  • Duration

    1 Day

This 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. Suitable for: Existing Access users.

Facilities

Location

Start date

London
See map
7th Floor Crystal Gate 28-30 Worship Street, EC2A 2AH

Start date

On request

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course Contents

Relationsips

  • 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
Time: The course starts at 09:30 and runs until 16:30.

The course is run on a date that suits you! We do not run public scheduled courses.

Additional information

Payment options: All our courses are charged at a flat rate per day. One to One - Charged at £450 per day Training our Training centre - Charged at £695 per day All prices are excluding VAT and per day. Travel cost outside the M25 applies.

See related categories

MS Access 2003 Intermediate

Price on request

The best Access courses

See all

See all