Access 2000: Advanced
Course Specifications
Course number: 076402
Course length: 1 day
Software: Access 2000 9.0
Certification: Microsoft Office Specialist
Course Description
Access 2000: Advanced is a hands-on instruction book 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. 

Target Student:  Students enrolling in this course should be able to work with Access at an intermediate level and understand Access terminology.

Prerequisites:   To ensure your success with this course, we recommend that you first take the following Element K Content courses or have equivalent knowledge: 
•	Access 2000: Level 1 
•	Access 2000: Level 2 
Delivery Method:  Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits:  Students will learn how to analyze data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros, and become familiar with Internet-related Access tools.

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.
Certification
Access 2000: Advanced is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.
Hardware/Software Requirements
This course was developed using the Windows 98 platform; however, the manufacturer’s documentation states that Office 2000 can also run on Windows 95 or Windows NT 4.0 with Service Pack 3 or higher installed, though some of the screen displays might be slightly different. 
•	A Pentium 75 PC with 16 MB of RAM. (We recommend a Pentium 133 or faster with 32 MB or more.) 
•	600 MB of free hard-disk space. For optimal performance, we recommend an additional 100 MB of free hard-disk space for user graphics and temporary image caches. 
•	Either a local CD-ROM drive or access to a networked CD-ROM drive for installation purposes. 
•	A 3.5"-disk drive. 
•	A two-button mouse, an IntelliMouse, or compatible pointing device. 
•	VGA or higher-resolution monitor; Super VGA is recommended. (The EGA display adapter is not supported.) 
•	An installed printer driver. (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.) 
•	An Internet connection with access to the World Wide Web. The connection is necessary to complete some tasks and Web tips throughout the book. (Note: Internet access may require payment of a separate fee to a service provider.) 
•	Microsoft Windows 95 (or later) operating system, Microsoft Windows 2000 operating system, Microsoft Windows NT Workstation operating system version 4.0 Service Pack 3 (or later). If you are running Windows NT, make sure that you have at least 4 MB of free Registry space. 
•	A custom installation of Microsoft Office 2000 Premium Edition—see the following section, Class Requirements, for additional instructions. 

Performance-Based Objectives
•	Make select queries more versatile and useful by using parameters; and use action queries to update data values and add or delete records. 
•	Generate different query types by creating various types of joins between tables; and use crosstab queries to summarize data. 
•	Use advanced form features including properties, functions, and design tools to facilitate data entry and improve accuracy in forms; and display table information that has a one-to-many relationship by creating forms that contain subforms. 
•	Automate tasks by creating macros to open forms and control form properties. 
•	Make forms more functional by using macros to provide user interaction and automate data entry. 
•	Make reports more concise and easier to understand by using properties and functions in report controls. 
•	Use Internet-related Access tools by inserting hyperlinks and using the Web toolbar; and integrate Access data with other Office 2000 applications. 

Course Content
Lesson 1: Parameter and Action Queries 
Topic 1A: Creating Parameter Queries 
Topic 1B: Creating Action Queries 

Lesson 2: Query Joins and Crosstab Queries 
Topic 2A: Joining Tables and Working with Join Properties 
Topic 2B: Creating Crosstab Queries 
Topic 2C: Editing Limitations in Query Datasheets 

Lesson 3: Using Advanced Form Techniques 
Topic 3A: Organizing Field Placement 
Topic 3B: Using Functions to Control Data Entry 
Topic 3C: Adding an Option Group to a Form 
Topic 3D: Using a Form as the User Interface 
Topic 3E: Creating a Form that Contains a Subform 

Lesson 4: Creating Basic Macros to Automate Forms 
Topic 4A: Macro Basics 
Topic 4B: Attaching a Macro to a Command Button 
Topic 4C: Revising a Macro 

Lesson 5: Using Macros to Provide User Interaction and Automate Tasks 
Topic 5A: Using a Macro to Provide User Interaction 
Topic 5B: Using Macros to Automate Data Entry 
Topic 5C: AutoKeys and AutoExec Macros 

Lesson 6: Using Advanced Report Techniques 
Topic 6A: Customizing the Appearance and Functionality of a Report 

Lesson 7: Web Capabilities and Data Integration 
Topic 7A: Creating and Using Hyperlinks 
Topic 7B: 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