Office 2013 On Demand

14. Creating a Database with Access

What You’ll Do

Create a Desktop 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

Define Table Relationships

Ensure Referential Integrity

Back Up and Repair a Database

Package and Share a Database

Introduction

Microsoft Access 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 ...