|
Access 2002: Introduction (2 Day)
Prerequisites: Windows: Introduction or
equivalent knowledge
Day One:
Lesson 1: Working with a Relational Database
Topic 1A: Identify Uses of a Relational Database
Topic 1B: Define Database Terminology
Topic 1C: Create a New Database Based on a Template
Topic 1D: Examine the New Database
Lesson 2: Planning a Database
Topic 2A: Identify Database Purpose
Topic 2B: Review Existing Data
Topic 2C: Determine Fields
Topic 2D: Group Fields into Tables
Topic 2E: Normalize the Data
Topic 2F: Designate Primary and Foreign Keys
Topic 2G: Identify Table Relationships
Lesson 3: Building the Basic Structure
Topic 3A: Create a Blank Database
Topic 3B: Create a Table using a Wizard
Topic 3C: Compare Datasheet and Design Views
Topic 3D: Create Tables in Design View
Topic 3E: Create Relationships between Tables
Lesson 4: Working with Tables
Topic 4A: Modify a Table Design
Topic 4B: Work in Datasheet View
Topic 4C: Work with Subdatasheets
Lesson 5: Creating and Working with Select Queries
Topic 5A: Examine a Query
Topic 5B: Create a Query using a Wizard
Topic 5C: Work in Query Design View
Topic 5D: Select Records
Topic 5E: Edit Values in a Query Datasheet
Topic 5F: Add a Calculated Field to a Query
Topic 5G: Perform a Calculation for a Group of Records
Lesson 6: Creating and Using Forms
Topic 6A: Create AutoForms
Topic 6B: Create a Form Using a Wizard
Topic 6C: Modify the Design of the Form
Topic 6D: Use Forms to Work with Data
Lesson 7: Creating and Using Reports
Topic 7A: Create an AutoReport
Topic 7B: Create a Report Using a Wizard
Topic 7C: Examine a Report in Design View
Topic 7D: Create a Calculated Field
Topic 7E: Change the Format of a Control
Topic 7F: Change the Style of a Report
Topic 7G: Adjust Report Width
Day Two:
Lesson 1: Managing a Database and Data
Topic 1A: Import Data
Topic 1B: Maintain Record Integrity
Topic 1C: Exporting Data
Topic 1D: Documenting Table Relationships
Lesson 2: Controlling Data Entry
Topic 2A: Make Data Entry More Accurate
Topic 2B: Make Data Entry More Efficient
Topic 2C: Facilitate Data Entry
Lesson 3: Finding and Joining Data
Topic 3A: Find Data with Filters
Topic 3B: Get the Correct Data with Query Joins
Topic 3C: Building Bridges Between the Data
Topic 3D: Relating Data Within a Table
Lesson 4: Creating Flexible Queries
Topic 4A: Summarizing Data with Queries
Topic 4B: Enter Criteria on the Fly
Topic 4C: Maintain Data with Queries
Lesson 5: Improving Your Forms
Topic 5A: Enhance the Appearance of a Form
Topic 5B: Enhance the Usability of a Form
Topic 5C: Make Your Forms More Professional
Topic 5D: Display Form Data from Multiple Tables
Lesson 6: Customizing Your Reports
Topic 6A: Organize Report Information
Topic 6B: Enhance Data Layout
Topic 6C: Working with Report Pagination
Topic 6D: Summarizing Information
Topic 6E: Add a Subreport to an Existing Report
Topic 6F: Creating Mailing Labels
Lesson 7: Making Your Data Available on the Web
Topic 7A: Create a Data Access Page
Topic 7B: Improving the Look of a Data Access Page
Topic 7C: Editing Data Using a Data Access Page
Topic 7D: Group Records in a Data AccessPage
|
