Introduction to
Microsoft Access 2003

Course Content

• Lesson 1: An Overview of Access 2003
  • Relational Databases
  • The Access Environment
  • The Database Environment
  • Examine an Access Table
• Lesson 2: Managing Data
  • Examine an Access Form
  • Add and Delete Records
  • Sort Records
  • Display Record Sets
  • Update Records
  • Run a Report
• Lesson 3: Establishing Table Relationships
  • Identify Table Relationships
  • Identify Primary and Foreign Keys in the Relationships Window
  • Working with Subdatasheets
• Lesson 4: Querying the Database
  • The Select Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform a Calculation on a Record Grouping
• Lesson 5: Designing Forms
  • Form Design Guidelines
  • Create AutoForms
  • Create a Form Using the Form Wizard
  • Modify the Design of a Form
• Lesson 6: Producing Reports
  • Create an AutoReport
  • Create a Report by Using the Wizard
  • Examine a Report in Design View
  • Add a Calculated Field to a Report
  • Modify the Format Properties of a Control
  • AutoFormat a Report
  • Adjust the Width of a Report

---

All Access Courses

Access 2010 Classes	Access 2007 Classes	Access 2003 Classes
What's New in Access 2010 > Introduction > Intermediate > Advanced >	What's New in Access 2007 > Introduction > Intermediate > Advanced > Expert >	Introduction > Intermediate > Advanced >
		About Access >

---