Microsoft Access 2000 Advanced

It is intended for participants who have a basic understanding of Windows 98 and Microsoft Access 2000. This is the third in the PBTSystem series of books covering Microsoft Access 2000. This one-day class covers the basics of using Access, including creating action queries, calculating numbers in queries and reports, and enhancing report design.

Course Prerequisites:   Access 2000 Fundamentals Operating System Windows 98

Course Length:   1 day

Performance Objectives:  Create new tables; append data; make deletions; build expressions and evaluate data with Action and Update queries.  Create concise summaries of large quantities of data and view and analyze data in spreadsheet format.  Use joins to view recordsets in different ways and create parameter queries to prompt for data.  Create SQL statements in advanced queries and use query results to optimize performance. Enhance readability through design modification and add grouping and sorting levels to meet changing needs.  Enhance appearance of reports and prepare reports for publication on the Internet or a corporate intranet.  Present additional information and embed charts that enhance the scope of your reports.  Use mathematical functions and build more dynamic reports based on parameter queries.

Course Content:

Module 1:
Performing Actions with Queries; Build Your Skills; Creating Action Queries; Creating a Make-Table Query; Creating an Append Query; Creating a Delete Query Using Calculations; Creating an Update Query; Creating a Calculated Field; Creating Summary Calculations; Summarizing and Grouping Values in a Query; Creating Crosstab Queries.

Module 2:
Designing Advanced Queries; Building Your Skills; Using Inner and Outer Joins in a Query; Creating a Parameter Query; Modifying an Existing Select Query Using Wildcard Characters in a Parameter Query; Working with the Structured Query Language (SQL); Using SQL in Query Design; Writing a Union Query with SQL; Building Queries Using Queries and Subqueries; Querying Queries Using Subqueries.