Microsoft Courses:
Microsoft Access 2000 Level 3 Advanced Training Course

Access 2000: Advanced (Level 3) is a hands-on course that will introduce you to advanced techniques in Access 2000. You will learn how to perform complex queries, create efficient forms and reports, create and use macros, use Internet-related Web tools, and carry out data integration procedures.

Delegates enrolling on this course should be able to work with Access at an intermediate level and understand Access terminology.

To ensure your success with this course, we recommend that you first take the following PTR courses or have equivalent knowledge:

Access 2000: Level 1

Access 2000: Level 2



What’s Next: : Access 2000: Introduction to Application Development, the next course in this series, teaches students how to develop custom applications by using Access.

Topics covered on the 1 day Microsoft Access 2000 Level 3 Advanced course

Parameter and Action Queries

Creating Parameter Queries

Creating Action Queries

Query Joins and Crosstab Queries

Joining Tables and Working with Join Properties

Creating Crosstab Queries

Editing Limitations in Query Datasheets

Using Advanced Form Techniques

Organizing Field Placement

Using Functions to Control Data Entry

Adding an Option Group to a Form

Using a Form as the User Interface

Creating a Form that Contains a Subform

Creating Basic Macros to Automate Forms

Macro Basics

Attaching a Macro to a Command Button

Revising a Macro

Using Macros to Provide User Interaction and Automate Tasks

Using a Macro to Provide User Interaction

Using Macros to Automate Data Entry

AutoKeys and AutoExec Macros

Using Advanced Report Techniques

Customizing the Appearance and Functionality of a Report

Web Capabilities and Data Integration

Creating and Using Hyperlinks

Data Integration

Appendix A: Replicating Databases

Using Simple Replication

Appendix B: Encrypting Databases

Encrypting and Decrypting a Database

Appendix C: Mailing Labels

The Mailing Label Report Wizard

   (excl.VAT)

PTR Associates Limited

21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk