Database Concepts

Introduction

Data is Stored in Databases

One the Internet We also have something called a “DATA STORE”
A Data Store can be a collection of data of different types.  This can include

Microsoft Access

Access Can Have Many Databases

Tables

Records

Fields

Keys

Types of Data

Special data types for Access

Currency Fields are for money

Number Fields

 Autonumber

Text Data

Memo Fields

DATE FIELDS

LOGICAL FIELDS

MEMO Fields

Ole Objects

Hyperlink

Lookup Wizard

Field Sizes and Attributes

Deciding What Fields to Use

Sorting

Return to Home

Return to Classes

Return to Access Classes