Access 2003: Level 1

Course specifications
Course number: 074 460
Software version number: 2003
Course length: 1 day

Hardware/software required to run this course

•	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 6 GB hard disk.
•	Either Windows XP Professional with Service Pack 1, or Windows 2000 Professional with Service Pack 4.
•	Microsoft Office Professional Edition 2003.
•	Installed printer drivers so that Print Preview can be used; printers are not required, however.
•	An 800 x 600 resolution monitor.
•	A two-button mouse or IntelliMouse.
•	A CD-ROM drive.
•	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.

Course description

Overview: Students will learn basic worksheets skills and how to work with data in worksheets.

Prerequisites: To ensure your success with this course, we recommend that you first take
the following Element K Content courses or have equivalent knowledge:
•	Windows 2000: Introduction
•	Windows XP: Introduction
•	Windows XP Professional: Level 1
•	Windows XP Professional: Level 2

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

Access 2003: Level 1

Performance-based objectives

The primary objective is to teach the basic skills necessary to use the Access
2003 program.
•	Understand database concepts and terminology in Access 2003.
•	Design and create tables.
•	Enter and manipulate data in tables.
•	Use Access queries to select and analyze information in a table.
•	Create data forms for viewing and inputting data.
•	Create reports that summarize and group data.
•	Perform database maintenance procedures.

Access 2003: Level 1

Course content

Lesson 1: Overview of Access 2003
Introduction to database concepts and terminology
An introduction to Access 2003
Database planning and design

Lesson 2: Creating tables
Examining a table
Creating a table with the Table Wizard
Creating a table in Design View
Types of primary keys

Lesson 3: Working with tables
Adding records
Modifying the table design
Finding and editing records
Deleting, adding, and copying records and values
Filtering and sorting records

Lesson 4: Using select queries
Selecting fields and sorting records
Refining the results of a query
Using queries to perform calculations
Joining tables in a query

Lesson 5: Creating and using forms
Creating a form
Modifying the form design
Using a form to locate and organize information
Multiple-table forms

Lesson 6: Creating and using reports
Creating a report
Creating a report that contains totals

Lesson 7: Creating and maintaining a database 
Creating a database
Managing a database and its objects 
Database maintenance 

Appendix A: Data Access Pages 
Data Access Pages

Appendix B: Improve Efficiency in a Database
Improve Efficiency in a Database

Appendix C: Back Up a Database
How to Back Up a Database