beautypg.com

Working with layouts, Understanding layouts – Apple AppleWorks 5 : Windows 95/NT 4.0 User Manual

Page 195

background image

Database

8-27

Working with layouts

When you work with a database in Browse mode, you see the fields arranged
in a layout, an arrangement of fields, field labels, and other objects that
determine the way data looks when it’s displayed and printed.

AppleWorks automatically creates the standard layout you see in Browse
mode when you create a database. You can change the layout and create
additional layouts for the same data, each one for a different purpose.

Understanding layouts

You create and work with layouts in Layout mode. You can use all the
drawing tools and commands available in AppleWorks to design your
layouts. You don’t enter or edit data in Layout mode, so creating or changing
a layout has no effect on the data in the database.

A specific value in
a pop-up menu or
radio button field

Click the NUMTOTEXT(number)
function and replace number by
selecting it and clicking the field
name. Click the

=

operator, and

then type the value in double
quotation marks.

A selected or
deselected
checkbox field

Click the field name and click
the

=

operator. Then type

true

to find selected fields, or

false

to find deselected fields.

A value that’s
more than one
value and less than
another value

Click the AND (logical1, logical2,...)
function, and then replace
logical1, logical2,... with the values
you want, separating each with a
comma

A date that is later
than the specified
date

Click the field name, click the

>

operator, and then use the
TEXTTODATE function to specify
the date

*

Choose Index from the Help menu and type the first few letters of the entry. Double-click the
entry and then double-click a topic.

To match records
that contain

In Browse or List mode,
choose Match Records from
the Organize menu, and then Example formula

Selects the Italian restaurants

Selects the reviewed restaurants

Finds the restaurants with meal prices more
than $5 but less than $15

Finds the restaurants visited in 1997

In the Help index,

*

see:

E

Layout mode