Course not currently available
Microsoft Access 2000 Intermediate
Short course
In Slough ()
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.
Reviews
-
The course was good but it made all very disappointing that trainer was very late.
← | →
Course rating
Recommended
Centre rating
Denise Rowe
This centre's achievements
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
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