The Knowledge Network
1510 Central Avenue
Albany, NY 12205
Phone (518)452-2675
Fax: (518)452-2872
Office Hours:
Mon-Fri 9:00am-6:00pm
learn@knowledgenetwork.org

Microsoft Access 2003 - Level 1

Location: Colonie

Course Outline:

• An Overview of Microsoft Access
  • Relational Databases
  • The Access Enviroment
  • The Database Enviroment
  • Examining an Access Table
     
• Managing Data
  • Examine an Access Form
  • Add and Delete Records
  • Sort Records
  • Display Record Sets
  • Update Records
  • Run a Report
     
• Establishing Table Relationships
  • Identify Table Relationships
  • Identify Primary and Foreign Keys in the Relationships Window
  • Working with Subdatasheets
     
• Querying the Database
  • The Select Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform a Calculation for a Group of Records
     
• Designing Forms
  • Form Design Guidelines
  • Create AutoForms
  • Create a Form Using the Form Wizard
  • Modify the Design of a Form
     
• Producing Reports
  • Create an AutoReport
  • Create a Report 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 Width of a Report
     
• 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
     
• 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
     
• Controlling Data Entry
  • Restrict Data Entry with Field Properties
  • Create an Input Mask
  • Create a Lookup Field
     
• Finding and Joining Data
  • Find Data with Filters
  • Create Query Joins
  • Join Unrelated Tables
  • Relate Data Within a Table
     
• Creating Flexible Queries
  • Set Query Select Properties
  • Create Parameter Queries
  • Create Action Queries
     
• Improving Your Forms
  • Enhance the Appearance of a Form
  • Restrict Data Entry in Forms
  • Add Command Buttons
  • Create a Subform
     
• Customizing Your Reports
  • Organize Report Information
  • Set Control Properties
  • Control Report Pagination
  • Summarize Information
  • Add a Subreport to an Existing Report
  • Create Mailing Labels
     
• Expanding the Reach of Your Data
  • Publish Access Data as a Word Document
  • Analyze Access Data in Excel
  • Export Data to a Text File
  • Merge Access Data with a Word Document