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

Pepsico

"Only a small group so really great training interaction. Well prepared and friendly, made what could of been a slightly dull topic enjoyable."

"Very good. I have never used Access before but feel confident that I will be able to set up and manage databases going forward."

Ansaldo NES

"Very Informative and great fun! Would Recommend to others"

"Short, intense, but very productive"

"Very informative and interesting. A lot of details and facts, looking forward to using the database"

Hewden

"Excellent!"

Walker Greenbank Distribution

"Very interesting... a lot of new tricks and options... highly recommended"

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