EXPLORING THE ACCESS 2007 ENVIRONMENT
- Examine Database Concepts
- Explore the User Interface
- Use an Existing Access Database
- Customize the Access Environment
- Obtain Help Information
DESIGNING A DATABASE
- Describe the Relational Database 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
- Create a New Database
- Create a Table
- Manage Tables
- Create a Table Relationship
- Save a Database as a Previous Version
MANAGING DATA IN A TABLE
- Modify Table Data
- Sort Records
- Work with Subdatasheets
|
QUERYING A DATABASE
- Filter Records
- Create a Query
- Add Criteria to a Query
- Modifying a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
DESIGNING FORMS
- View Data Using an Access Form
- Create a Form
- Modify the Design of a Form
GENERATING REPORTS
- View an Access Report
- Create a Report
- Add a Custom Calculated Field to a Report
- Format the Controls in a Report
- Apply an AutoFormat Style to a Report
- Prepare a Report for Print
|