Microsoft Courses > Microsoft Access 2000 Level 3 Advanced Training Course
Course Fee = £250 (excl.VAT)
Microsoft Access 2000 Level 3 Advanced Course Outline
Course Description
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.
Course pre-requisites:
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
This is an instructor led training course taught in a classroom based environment.
Course Classification:
Course Fee = £250 (excl.VAT)
Scheduled course dates
| July 2009 |
August 2009 |
September 2009 |
October 2009 |
November 2009 |
If you want to attend the course but can't make the dates published, then please get in touch as we may well be able to add additional dates to those published or to re-arrange the course. Additionally, you could take advantage of one-to-one training with our SoloIT Training packages that also enables you to attend this course on dates that suit.
Access 2003 Training SAVE IT Scheme
|