VISD Technology Access Database

Microsoft Access 2003 Database

These lessons have been recorded as flash files and are best viewed at 800 x 600. Be sure you have the latest
Macromedia Flash player.

Introduction

Introduction

The Database

Creating a Database in Design View

Creating a database

Creating a database in Design View

Typing field labels and choosing data type

Saving the table

Primary Key

Entering information

Adding fields in design view

Creating a look up field with the wizard

Creating a Table by Importing Data from a Comma Delimited Text File (.csv)

Importing Data

Using the .csv file

Using the Import Wizard part 1

Using the Import Wizard part 2

Importing a Table that has Already Been Created

Importing the table

Completing the Import table process

Working with the Database

Organizing information using the Sort button

Finding informaiton using the Find button

Filtering

Queries

Starting Queries

Specifying data for the query

Sort/Show/Criteria for queries

Query Conclusion

Printing Data

Printing from the Database

Publish table/query to MS Word

Ways to Use the Database

Merge

Merge table/query data to MS Word

Merge Step 1

Selecting Recipient List in Merge

Using Merge Fields

Completing the Merge

Reports

Reports

Report: Labels