Computer Tutoring Logo
Est. 2002
Menu Button

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.
I would like to receive training special offer emails
I would like to be notified about free software hints and tips

Testimonials

3D Entertainment Group

"Really well delivered, able to answer all questions."

"Thorough but not too complicated that couldn't follow along."

"Very well presented and broken down into easy to manage sections bearing in mind such a complicated application."

SELEX Sensors & Airborne Systems

"I felt that the one zone nature of the course enabled the trainer to answer questions and use examples specific to my needs."

CMG Rescue Services

"Professional whilst enjoyable."

"Excellent value for money."

National Police Improvement Agency

"Very comprehensive, all queries answered. Came away feeling confident."

"Very well explained, by a very enthusiastic trainer."

"Easy to understand, relaxed and informative."

Adobe
Macromedia
Microsoft
Google
General
Web Design
Handling Information
Print & Desktop Publishing
Apple
Presentation

Locations

Microsoft Access 2000 Training Course Advanced

Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar.

Course Duration: 1 Day

Course Outline

Parameter and action queries in Microsoft Access 2000

  • Creating parameter queries
  • Creating action queries

Query joins and crosstab queries in Access 2000

  • Joining tables and working with join properties
  • Creating crosstab queries
  • Editing limitations in query datasheets

Using advanced form techniques in Access 2000

  • Organizing field placement
  • Using functions to control data entry
  • Adding an option group to a form
  • Using a form as the user interface
  • Creating a form that contains a subform

Creating basic macros to automate forms in Access

  • Macro basics
  • Attaching a macro to a command button
  • Revising a macro
  • Attaching a macro to an event in a form

Using macros to provide user interaction and automate tasks in Access 2000

  • Using a macro to provide user interaction
  • Using macros to automate data entry
  • AutoKeys and AutoExec macros

Using advanced report techniques in Access

  • Customizing the appearance and functionality of a report
  • Mailing and other types of labels

Access 2000 and the Internet

  • Using hyperlinks
  • Access tools for working on the Internet

Advanced Access Prices from:

If you are interested in this course but want to know the price beforehand then use the the following form to calculate how much.

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

No. Students:

First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.
I would like to receive training special offer emails
I would like to be notified about free software hints and tips



You may also be interested in these other Access training courses:

Microsoft Access 2016 training course beginners

Microsoft Access 2016 training course intermediate

Microsoft Access 2016 training course advanced

Organising data training course beginners

Microsoft Access 2000 Training Course- Intermediate

Microsoft Access 2002 Training Course- Intermediate

Microsoft Access 2002 Training Course- Intermediate

Microsoft Access 2002 Training Course- Beginners

Microsoft Access 2007 Training Course- Beginners

Microsoft Access 2007 Training Course- Beginners

Microsoft Access 2007 Training Course- Intermediate

Microsoft Access 2010 Training Course- Beginners

Microsoft Access 2010 Training Course- Intermediate

Microsoft Access 2010 Training Course- Intermediate

Microsoft Access 2003 Training Course- Beginners

Microsoft Access 2003 Training Course- Advanced



Microsoft Access 2000 Training Course Advanced