Access 2007 Level 1

1 Day Course
Hands On
Code DAC07L1

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Collapse all

Exploring the Access Environment (6 topics)

  • Examine Database Concepts
  • Explore the User Interface
  • Explore the Ribbon
  • Customize the Access Environment
  • Obtain Help
  • Use an Existing Access Database

Designing a Database (8 topics)

  • Describe the Relational Database Design Process
  • Define Database Purpose
  • Review Existing Data
  • Determine Fields
  • Group Fields into Tables
  • Normalize Data
  • Designate Primary and Foreign Keys
  • Determine Table Relationships

Building a Database (4 topics)

  • Create a New Database
  • Create a Table
  • Manage Tables
  • Create a Table Relationship

Managing Data in a Table (3 topics)

  • Modify Table Data
  • Sort Records
  • Work with Subdatasheets

Querying a Database (5 topics)

  • Filter Records
  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping

Designing Forms (4 topics)

  • View Data Using an Access Form
  • Create a Form
  • Create a Form Using the Form Wizard
  • Modify the Design of a Form

Generating Reports (7 topics)

  • View an Access Report
  • Create a Report
  • Create a Report Using the Report Wizard
  • Add a Custom Calculated Field to a Report
  • Format the Controls in a Report
  • Apply an AutoFormat to a Report
  • Prepare a Report for Print

Course PDF

Print

Sections