Access 2003: Level 2

Course specifications

Course number: 074 461

Software version number: 2003

Course length: 1 day

Hardware/software required to run this course

This book was written for the Windows XP platform.

A 233 MHz Pentium-class processor if you use Windows XP Professional as your operating system. (300 MHz is recommended.)

A 133 MHz Pentium-class processor if you use Windows 2000 Professional as your operating system.

128 MB of RAM.

A 5 GB hard disk or larger, if you use Windows XP Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.

A 3 GB hard disk or larger, if you use Windows 2000 Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.

A CD-ROM or DVD-ROM drive.

A mouse or other pointing device.

An 800 x 600 resolution monitor.

Network cards and cabling for local network access.

Internet access (see your local network administrator).

A printer (optional).

A projection system to display the instructor's computer screen.

Either Windows XP Professional with Service Pack 1, or Windows 2000 Professional with Service Pack 3.

Microsoft Office Professional Edition 2003.

Course description

Overview: Students will get the most out of this course if they want to learn to enhance their database designs by using the principles of data normalization and table relationships; to query multiple tables for data that is used in customized forms and reports; and to begin using data access pages.

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 2003: Level 1

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

Access 2003: Level 2

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.
• Publish data to the Web by creating data access pages.
• Customize report designs by grouping, sorting, and summarizing data, and by adding subreports.

Access 2003: Level 2

Course content

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

Appendix B: New features of Access

View information on object dependencies

Property update options