Access 2000 Intermediate Author:Scott Palmer Access 2000: Intermediate Access is a powerful database management system for microcomputers. ActiveEducation's course, Access 2000: Intermediate, presents methods for enhancing the database management skills acquired in Access 2000: Introduction. A basic knowledge of Access 2000: Introduction, or at least a working knowledge of database oper... more »ations is required. Course Objectives ? Manipulate database objects ? Create queries that do calculations and perform actions ? Create queries that prompt users for input ? Explain the use of SQL, the standard database language ? Customize forms with controls and subforms ? Create reports that group and sort data ? Use Access with the Web and intranets ? Use field formats and input masks ? Validate data entry ? Compact and repair a database ? Enforce referential integrity Lesson Topics Lesson 1:Creating Advanced Queries Using Parameter Queries Prompting for Multiple Criteria Creating Crosstab Queries Viewing SQL Statements Lesson 2:Creating Customized Queries Doing Calculations in Queries Adding Criteria to a Totals Query Using Calculations in a Totals Query Designing Action Queries Automatically Updating a Table Lesson 3:Customizing Forms Creating Custom Forms Adding List Controls to Forms Enhancing the Form Creating and Using Subforms Lesson 4:Customizing Reports Creating Custom Reports Grouping and Sorting Report Data Enhancing Reports Creating Subreports Lesson 5:Using Access with the Web and Intranets Adding Hyperlinks to Tables Exporting Data to Web Pages Creating Data Access Pages Lesson 6:Additional MOUS Skills Using Field Formats Using Input Masks Validating Data Entry Compacting and Repairing Databases Enforcing Referential Integrity« less