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.

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."

Microsoft Access 2000 Training Course Intermediate

Students will learn how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports. Additionally, students learn how to create data access pages to share data over an intranet or the Internet.

Course Duration: 1 Day

Course Outline

Principles of table design in Microsoft Access 2000

  • Normalizing data
  • Normalizing data for fourth and fifth normal forms

Principles of table relationships

  • Analyzing table relationships
  • Establishing and testing referential integrity

Table design techniques in Access 2000

  • Data validation techniques
  • Indexing techniques

Designing select queries in Access 2000

  • Using calculated fields in queries
  • Creating multiple-table queries

Customizing form designs in Access 2000

  • Customizing the form design
  • Performing calculations on a form
  • Adding combo boxes to a form
  • Adding unbound controls

Working with data access 2000 pages

  • Creating data access pages

Customizing reports using Access 2000

  • Customizing a report created by the Report Wizard
  • Working with subreports

Intermediate 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.



Microsoft Access 2000 Training Course Intermediate