Home > Courses Certifications > Microsoft Office > Access 2002 Level 1 Synopsis

Microsoft Access 2002 - Level 1

Access 2002 Level 2

Access 2002 Level 3

Duration: 2 days

Lesson 1: Working with a Relational Database

• Identify Uses of a Relational Database
• Define Database Terminology
• Create a New Database Based on a Template
• Examine the New Database

Lesson 2: Planning a Database

• Identify Database Purpose
• Review Existing Data
• Determine Fields
• Group Fields into Tables
• Normalize the Data
• Designate Primary and Foreign Keys
• Identify Table Relationships

Lesson 3: Working with Tables

• Modifying a Table using Design View
• Finding and Editing Records
• Filtering and Sorting Records

Lesson 4: Building the Basic Structure

• Create a Blank Database
• Create a Table using a Wizard
• Compare Datasheet and Design Views
• Create Tables in Design View
• Create Relationships between Tables

Lesson 5: Working with Tables

• Modify a Table Design
• Work in Datasheet View
• Work with Subdatasheets

Lesson 6: Creating and Working with Select Queries

• Examine a Query
• Create a Query using a Wizard
• Work in Query Design View
• Select Records
• Edit Values in a Query Datasheet
• Add a Calculated Field to a Query
• Perform a Calculation for a Group of Records

Lesson 7: Creating and Using Forms

• Create AutoForms
• Create a Form Using a Wizard
• Modify the Design of the Form
• Use Forms to Work with Data

Lesson 8: Creating and Using Reports

• Create an AutoReport
• Create a Report Using a Wizard
• Examine a Report in Design View
• Create a Calculated Field
• Change the Format of a Control
• Change the Style of a Report
• Adjust Report Width

Lesson 9: Managing a Database and Data

• Import Data
• Maintain Record Integrity
• Exporting Data
• Documenting Table Relationships

Lesson 10: Controlling Data Entry

• Make Data Entry More Accurate
• Make Data Entry More Efficient
• Facilitate Data Entry

Lesson 11: Finding and Joining Data

• Find Data with Filters
• Get the Correct Data with Query Joins
• Building Bridges Between the Data
• Relating Data Within a Table

Lesson 12: Creating Flexible Queries

• Summarizing Data with Queries
• Enter Criteria on the Fly
• Maintain Data with Queries

Lesson 13: Improving Your Forms

• Enhance the Appearance of a Form
• Enhance the Usability of a Form
• Make Your Forms More Professional
• Display Form Data from Multiple Tables

Lesson 14: Customizing Your Reports

• Organize Report Information
• Enhance Data Layout
• Working with Report Pagination
• Summarizing Information
• Add a SubReport to an Existing Report
• Creating Mailing Labels

Lesson 15: Making Your Data Available on the Web

• Create a Data Access Page
• Improving the Look of a Data Access Page
• Editing Data Using a Data Access Page
• Group Records in a Data Access Page