Creating a database, Create a new database document and new table – Brother P-TOUCH 3.1 User Manual

Page 26

Advertising
background image

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.

Advertising