Apple AppleWorks 5 : Windows 95/NT 4.0 User Manual

Page 177

Advertising
background image

Database

8-9

Checking or entering data automatically

AppleWorks can enter or check data when you create records. For example,
you may want the data in a number field to be unique and within a
certain range.

To set up a field for data checking or automatic entry, select the field from
the list in the Define Database Fields dialog box and click Options. You see
the options available for the type of field you selected. For example, this
dialog box shows the options available for number fields:

Multimedia

Display a picture, movie, or library or
OLE object. A picture in a multimedia
field is stored with the database
document. A movie in a multimedia field
is a reference to a movie file, which is
stored separate from the database
document.

Record Info

Display the time and date that the record
was created or modified, or the name of
the creator or modifier

Calculation

Produce the result of a formula that
calculates values from the current record
in the database. For more information, see
“Defining calculation and summary
fields” on page 8-10.

Summary

Produce the result of a formula that
summarizes values from one or more
records in the database. The field appears
only in the summary part of a layout. For
more information, see “Creating a layout”
on page 8-29.

*

Choose Index from the Help menu and scroll to the entry. Double-click the entry and then
double-click a topic.

Use this field type To

Example
(in Browse mode)

In the Help index,

*

see:

E

fields, defining

Advertising