Access 2000: Level 2 (Windows)

Students will learn how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports. Additionally, students learn how to create data access pages to share data over an intranet or the Internet.

Benefits:

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. In addition, students will be able to save time by controlling data entry and automating 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.

Prerequisites

Access 2000: Level 1 or equivalent knowledge.

Target Student:

Students enrolling in this course should understand the basics of creating and using database objects, including tables, queries, forms, and reports.

Performance-Based Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

Normalize sample tables by identifying design problems.
Establish relationships between tables by analyzing table relationships and enforcing referential integrity.
Customize table designs by setting field properties to maintain data integrity, by creating a lookup list, and by creating indexes.
Design select queries by using multiple tables to calculate, group, average, and concatenate values and to show top values.
Customize form designs by creating calculated fields, combo boxes, and unbound controls.
Interact with data through a browser by creating and using data access pages.
Customize report designs by grouping, sorting, and summarizing data, and by adding subreports.

Delivery Method:

Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

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 create action queries, more efficient forms and reports, and macros.

New features covered in this series

Below is a table listing the new software features that are covered in ZD Education courseware:

New Feature	Introduction	Intermediate	Advanced
Printing the Relationships window as a report		>X
Subdatasheets		>X
Data access pages		>X
Page wizard		>X
Redesigned menu system	>X
Redesigned File Management dialog boxes (File,Open and File, Save)	>X
Improved Help system	>X
Improved Database window	>X
Improved Hyperlinks dialog box			>X

Course duration

1 Day(s)

Course outline

Lesson 1: Principles of table design

Normalizing data
Normalizing data for fourth and fifth normal forms

Lesson 2: Principles of table relationships

Analyzing table relationships
Establishing and testing referential integrity

Lesson 3: Table design techniques

Data validation techniques
Indexing techniques

Lesson 4: Designing select queries

Using calculated fields in queries
Creating multiple-table queries

Lesson 5: Customizing form designs

Customizing the form design
Performing calculations on a form
Adding combo boxes to a form
Adding unbound controls

Lesson 6: Working with data access pages

Creating data access pages

Lesson 7: Customizing reports

Customizing a report created by the Report Wizard
Working with subreports

Appendix A: Using the Chart Wizard

Creating a chart in a form or report

Hardware/Software Requirements

A 486/66-compatible PC that meets minimum hardware requirements for Windows 95 or later or Windows NT 4.0 or later. A Pentium processor with a speed of at least 90 MHz is recommended; and either a local or network-accessible CD-ROM drive.
At least 16 megabytes (MB) of Random Access Memory (RAM). 32 MB RAM or more is recommended.
At least 421 MB of hard-disk space to install the entire Office 2000 suite of software. Installing the Access database files from the data disk to the hard disk for each student station requires an additional 2 MB of hard-disk space.
Microsoft Windows 95, Windows 98, or Windows NT 4.0. Windows NT 4.0 requires that Service Pack 3 or higher be installed.
Internet Explorer 5.0 is required for local access to the browser and to design data access pages.
An installation of Microsoft Office 2000 that includes a custom installation of Access 2000.
An installed printer driver so that Print Preview can be used; printers are not required, however.
At least a VGA display adapter (the EGA display adapter is not supported).
A two-button mouse or IntelliMouse.
A floppy-disk drive.

Contact Information
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com

Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2008 Wintrac Inc.