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