Microsoft® Office 2007 On Demand

14. Creating a Database with Access

What You’ll Do

Understand How Databases Store Data

Create a Database

View the Access Window

Change Database Display Options

Work with Database Objects

Plan Tables

View Database Objects

Create a Table by Entering Data

Create a Table Using a Wizard

Work with a Table

Import Data into Tables

Work with a Table in Design View

Specify Data Types and Field Properties

Create Input Masks

Create a Lookup Field

Plan and Define Table Relationships

Ensure Referential Integrity

Introduction

Microsoft Office Access 2007 is a database program that allows you to:

• Store an almost limitless amount of information.
• Organize information in a way that makes sense for how you work.
• Retrieve information based on selection criteria ...