Access 2000: Advanced

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