Microsoft Office Access 2007: Basic

Description

Access 2007 allows you to capture, organize and analyze data efficiently at work and at home. Whether you're building a contact list or catalog of assets or you're managing tasks and assignments, a well built database can be the difference between chaos and confident success. All it takes is knowledge of the features and tools within this essential management tool.

CONTENTS:

Getting started

Topic A: Database concepts

Topic B: Exploring the Access environment

Topic C: Getting help

Unit summary: Getting started

Databases and tables

Topic A: Planning and designing databases

Topic B: Exploring tables

Topic C: Creating tables

Unit summary: Databases and tables

Fields and records

Topic A: Changing the design of a table

Topic B: Finding and editing records

Topic C: Organizing records

Unit summary: Fields and records

Data entry rules

Topic A: Setting field properties

Topic B: Working with input masks

Topic C: Setting validation rules

Unit summary: Data entry rules

Basic queries

Topic A: Creating and using queries

Topic B: Modifying query results and queries

Topic C: Performing operations in queries

Unit summary: Basic queries-26

Using forms-1

Topic A: Creating forms

Topic B: Using Design view

Topic C: Sorting and filtering records

Unit summary: Using forms

Working with reports-1

Topic A: Reports-2

Topic B: Modifying and printing reports

Unit summary: Working with reports

Course summary

Topic A: Course summary

Topic B: Continued learning after class

Glossary

Index