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:
Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
Performance-based objectives
The primary objective is to teach the basic skills necessary to use the Access 2003 program.
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