Course not currently available

Microsoft Access 2000 Intermediate

5.0
1 review
  • The course was good but it made all very disappointing that trainer was very late.
    |

Short course

In Slough ()

Price on request

Description

  • Type

    Short course

  • Duration

    1 Day

This intensive training course is designed to give existing Microsoft Access 2000 users additional skills and knowledge on using the many features and functions of the software to make them more efficient and effective when processing data with Microsoft Access. This entirely 'hands on' course will give participants experience in producing database applications and the ability to. Suitable for: Existing users of Microsoft Access 2000 who want to get grips with some of the more advanced features of this database package.Note: A basic working knowledge of Microsoft Access 2000 is required.

Questions & Answers

Add your question

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

Fill in your details to get a reply

We will only publish your name and question

Reviews

5.0
  • The course was good but it made all very disappointing that trainer was very late.
    |
100%
4.6
excellent

Course rating

Recommended

Centre rating

Denise Rowe

5.0
30/01/2018
What I would highlight: The course was good but it made all very disappointing that trainer was very late.
What could be improved: Nothing
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2018

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 15 years

Subjects

  • Access
  • Database
  • Database training
  • Microsoft Access XP
  • Microsoft Access

Course programme

Course Aims
This intensive training course is designed to give existing Microsoft Access 2000 users additional skills and knowledge on using the many features and functions of the software to make them more efficient and effective when processing data with Microsoft Access. This entirely 'hands on' course will give participants experience in producing database applications and the ability to create a variety of data views, queries and reports.
Who Should Attend?
Existing users of Microsoft Access 2000 who want to get grips with some of the more advanced features of this database package. Note : A basic working knowledge of Microsoft Access 2000 is required.
Course Outline: Microsoft Access 2000 Intermediate
Database Design
· What is a Relational Database? · Primary and Foreign Keys · Relationships
Using Field Properties for Protection
· Objectives · Required · Default Value · Input Mask · Validation Rule and Validation Text · Lookups
Table Relationships
· What is a Relationship? · Relationship Types · Creating and Editing Relationships · Using Lookups for Referential Integrity · Multi-table Datasheet View
Queries
· Multi-table Queries · Calculated Fields · Adding a Calculated Field to a Query · The Expression Builder · Calculating Summary Information · Crosstab Queries · General Query Properties · Checking Referential Integrity
Forms
· Creating a Form · Filling in a Form
Reports
· Using Report Wizards as the Basis for Reports · Report Sections · Report Controls · Report Control Layout · Using Specific Controls · Publishing Datasheet Views on the Internet · Adding Hyperlinks to Datasheet Views · Adding Hyperlinks to HTML Pages

Microsoft Access 2000 Intermediate

Price on request