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