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