Access 2000: Level 2
Course Specifications
Course number: 076401
Course length: 1 day
Software: Access 2000 9.0
Certification: Microsoft Office Specialist
Course Description
Access 2000: Level
2 is a hands-on instruction book that
will help you enhance your database designs by using the principles of data
normalization and table relationships, querying multiple tables for data used
in customized forms and reports, and using data access pages.
Target Student: Students enrolling in this course should have a basic
level of understanding of the Access 2000 interface, and should have experience
designing tables, simple queries, forms, and reports.
Prerequisites: We designed Access 2000: Level 2 for the student
who has a basic level of understanding of the Access 2000 interface, and has
designed tables, simple queries, forms, and reports. The prerequisite for this course is Access
2000: Level 1.
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model
with structured hands-on activities.
Benefits: Students will learn how to take the guesswork out of creating
databases by using data-normalization techniques. They will learn how to take
advantage of relational database efficiency to maintain data by establishing
relationships and enforcing referential integrity. In addition, students will
save data entry time by using sound table design techniques to control data
entry and automate tasks. Students will also benefit by becoming familiar
with Access features that will enable them to customize forms and reports,
and to share data over an intranet or the Internet by creating and using data
access pages.
What's Next: Access 2000: Level 2 is
the second course in this series. Access 2000: Advanced,
the next course in this series, teaches students how to use a variety of query
techniques, and how to create more efficient forms and reports, and macros.
After taking the Advanced course, students who want to learn how to develop
an application and tie the objects together into a cohesive system by using
macros and Visual Basic for Applications code can take Access
2000: Introduction to Application Development.
Certification
Access 2000: Level 2 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, Windows 2000, 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 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, 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
- Normalize tables through fifth normal form.
- Establish relationships between tables and enforce referential
integrity.
- Maintain data integrity in tables by setting properties, creating
a Lookup list, and creating indexes.
- Use queries to calculate expressions and extract data from multiple
tables.
- Improve form designs by adding bound controls, calculated fields,
and a combo box.
- Create and modify data access pages, and integrate data with
other applications.
- Create and modify reports with the Report Wizard and Design
View, add a subreport, and add a calculated control.
Course Content
- Lesson 1: Principles of Table Design
- Topic 1A: Normalizing Data
- Topic 1B: Normalizing Data for Fourth and Fifth Normal
Forms
- Lesson 2: Principles of Table Relationships
- Topic 2A: Analyzing Table Relationships
- Topic 2B: Establishing and Testing Referential Integrity
- Lesson 3: Table Design Techniques
- Topic 3A: Data Validation Techniques
- Topic 3B: Indexing Techniques
- Lesson 4: Designing Select Queries
- Topic 4A: Using Calculated Fields in Queries
- Topic 4B: Creating Multiple-table Queries
- Lesson 5: Customizing Form Designs
- Topic 5A: Customizing the Form Design
- Topic 5B: Performing Calculations on a Form
- Topic 5C: Adding Combo Boxes to a Form
- Topic 5D: Adding Unbound Controls
- Lesson 6: Working with Data Access Pages
- Topic 6A: Creating Data Access Pages
- Topic 6B: Integrating with Other Applications
- Lesson 7: Customizing Reports
- Topic 7A: Customizing a Report Created by the Report
Wizard
- Topic 7B: Working with Subreports
- Topic 7C: Creating a Report in Design View