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

Microsoft Access 2003 Level 1

Access 2003 Level 2

Access 2003 Level 3

Duration: 2 days

Lesson 1: An Overview of Microsoft Access

• 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

Lesson 7: Planning a Database

• Design a Relational Database
• Identify Database Purpose
• Review Existing Data
• Determine Fields
• Group Fields into Tables
• Normalize the Data
• Designate Primary and Foreign Keys

Chapter 8: Building the Structure of a Database

• Create a New Database
• Create a Table Using a Wizard
• Create Tables in Design View
• Create Relationships between Tables

Chapter 9: Controlling Data Entry

• Restrict Data Entry with Field Properties
• Create an Input Mask
• Create a Lookup Field

Chapter 10: Finding and Joining Data

• Find Data with Filters
• Create Query Joins
• Join Unrelated Tables
• Relate Data Within a Table

Chapter 11: Creating Flexible Queries

• Set Select Query Properties
• Create Parameter Queries
• Create Action Queries

Chapter 12: Improving Your Forms

• Enhance the Appearance of a Form
• Restrict Data Entry in Forms
• Add Command Buttons
• Create a SubForm

Chapter 13: Customizing Your Reports

• Organize Report Information
• Set Report Control Properties
• Control Report Pagination
• Summarize Information
• Add a SubReport to an Existing Report
• Create Mailing Labels

Chapter 14: Expanding the Reach of Your Data

• Publish Access Data as a Word Document
• Analyse Access Data in Excel
• Export Data to a Text File
• Merge Access Data with a Word Document