Microsoft Office 2010 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 an Application Part Using a Template

Create a Table Using SharePoint

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 2010 is a database program that allows you to:

Store an almost ...