Creating a database; 1. Create a new database document and new table.; Zip Code- Page 26

Creating a database

The following are the basic steps for creating a database.

1. Create a new database document and a new table.

2. Define the field names and their formats.

3. Create records and input the record data.

 Note:

Files saved in the .mdb Microsoft® Access 97 format can be opened in
P-touch Editor Ver. 3.1. However, files created in Microsoft® Access
versions other than 97 are incompatible with P-touch Editor Ver. 3.1.

In order to understand how a database is created and used, we will perform the above steps to make a
database containing the following data:

 First

Name

 Last

Name

 Address

 City

 State

 Zip Code

 John

 Jones

 1 Baker Street Portsmouth

 OH

 32468

 Mary

 Smith

 1 Crescent

Road

 Chicago

 IL

 46901

 Peter

 Brown

 1 Main Street

 Los

Angeles

 CA

 92802

 Jane

 Thompson

 1 Bradford

Street

 New York

 NY

 60867

 John

 Peterson

 1 Green Street

 Miami

 FL

 32960

1. Create a new database document and new
table.

A new table can easily be created by following the steps below.

1. Pull down the [File] menu, select the [New] command to display the [New] submenu, and then
click the [Database] command.