Access 2000 Intermediate

This intensive course is designed to give existing Access 2000 users additional skills and knowledge on using the many features and functions of this software to make them more efficient and effective when processing data with 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.

Target audience

Existing users of Access 2000 who want to get grips with some of the more advanced features of this package as quickly as possible. A basic understanding of PCs, Windows 95/98/NT/2000 and Access 2000 is required, gained from previous experience or by attendance on an "Access 2000 Introduction" training course.

Course content

Access 2000 Intermediate Year 2000 Best Practice

Database design What is a relational database? . Primary and foreign keys . Relationships

Using field properties for protection 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 What is a form? . Form sections . Form controls . Form control layout . Using form controls . Control properties . Control Wizards . Multiple table forms

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

Access tools Importing from other data sources . Importing data using Drag-and-Drop . Backing up and restoring a database . Compacting and repairing a database

About Courseware Company:: Instructor-led training courseware :: Self-study solutions :: Buy online today