Access 2000 Advanced

This one-day intensive course is designed to give existing users an insight into some of the more advanced features in Access. This entirely 'hands on' course will give participants a further understanding of database design principles, advanced forms, reports and query design, including using calculations.

Target audience

Existing users of Access for windows who want to customize forms, queries and reports. A basic knowledge of Access gained through use of the product or by attending an "Access 2000 Intermediate" course.

Course content

Access 2000 Advanced Year 2000 Best Practice

Database design Theory of normal forms . De-normalisation . Naming conventions

Access 2000 performance issues Indexes . Data validation . Table level validation . Relationships and referential integrity . Relationships . Field types . Referential integrity options . Join types . Using Lookups for referential integrity . Multi-table datasheet view

Building and modifying forms Using advanced forms features . The form worksurface . Creating a calculated control . Adding a graphic to a form . Multi-table forms . Using the Subform control . Switchboard forms

Access and the Internet Using hyperlinks . Using hyperlinks in forms . Exporting datasheet views to HTML . Data access pages

Advanced queries Filtering query results . Parameter queries . Creating summary queries . Formatting query output . Query join types . Self joins and aliases . Cross joins

Action queries What is an action query? . Planning an action query . Make table queries . Append queries . Delete queries . Update queries

Producing reports Applying sorting and grouping to reports . Performing calculations on reports . Adding a graphic to a report . Using the subreport control . Modifying section properties . Using the Chart Wizard

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