Overview of Access 2007

Introduction to Database Concepts and Terminology

An Introduction to Access 2007

The Access 2007 Interface

Database Planning and Design

Creating a Database

 

Principles of Table Design

Normalizing Data

Normalizing Data for Fourth and Fifth Normal Forms

Analyzing Table Relationships

Establishing and Testing Referential Integrity

 

Creating Tables

Examining a Table

Access Data Types

Creating a Table with the Table Wizard

Creating a Table in Design View

Types of Primary Keys

 

Working with Tables

Adding Records

Modifying the Table Design

Finding and Editing Records

Deleting, Adding, and Copying Records and Values

Filtering and Sorting the Data Sheet

 

Data Integrity

Preventing Blanks

Preventing Duplicates

Creating Input Masks

Validation Rules

Using a Lookup

 

Using Select Queries

Selecting Fields and Sorting Records

Refining the Results of a Query

Using Queries to Perform Calculations

Joining Tables in a Query

Query Joins and Crosstab Queries

Joining Tables and Working with Join Properties

Creating Crosstab Queries

Editing Limitations in Query Datasheets

 

Changing Data with Queries

Update Queries

Append Queries

Delete Queries

 

Creating and Using Forms

Creating a Form

Modifying the Form Design

Using a Form to Locate and Organise Information

Multiple-Table Forms

Performing Calculations on a Form

Adding Combo Boxes to a Form

Adding Unbound Controls

 

Using Advanced Form Technqiues

Organising Field Placement

Using Functions to Control Data Entry

Adding an Option Group to a Form

Using a Form as the User Interface

Creating a Form that Contains a Subform

Creating a Naviagtion System

 

Creating and Using Reports

Creating a Report

Creating a Report that Contains Totals

Working with Subreports

Working with Groups

 

Maintaining a Database

Managing a Database and its Objects

Database Maintenance

Securing a Database