Access 2002 (Office XP): Level 1 Series: Office XP - Access 2002
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8
Course Type: Self-Study QuickSkill Course
Access 2002 (Office XP): Level 1
Series: Office XP - Access 2002
Platform: Windows NT 4 Workstation, 95, 98, 2000, ME, XP, Mac OS 8
Course Type: Self-Study QuickSkill Course
Access 2002: Level 1 familiarizes students with the basics of Access 2002. Students will learn how to create and use database objects, including tables, queries, forms, and reports.
| Lesson 1: Overview of Access 2002 | |
| Introduction to Database Concepts and Terminology | |
| An Introduction to Access 2002 | |
| Database Planning and Design | |
| Lesson 2: Creating Tables | |
| Examining a table | |
| Creating a Table by Using the Table Wizard | |
| Creating a Table in Design View | |
| Lesson 3: Working with Tables | |
| Modifying the Table Design | |
| Finding and Editing Records | |
| Filtering and Sorting Records | |
| Lesson 4: Using Select Queries | |
| Selecting Fields and Sorting Records in a Query | |
| 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 | |
| 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 | |
| Database Maintenance | |