Apple M9057 User Manual - Page 189

Defining database fields, Adding fields to an existing database, Define Fields

Page 189 highlights

Database 8-7 Tip When you design a database that holds names and addresses, you can start quickly by using the Address List Assistant, and then changing the database as needed. For more information about using Assistants, see "Using an Assistant" on page 2-4. Defining database fields In the Help index,* see: E fields, defining Once you plan the design of a database, the next step is to define the fields to store the data. When you define a field, you give it a name and then select a field type to determine what kind of data (for example, numbers or a date) can be stored in the field. When you open a new database document, you see the Define Database Fields dialog box, where you set up database fields. Field names and field types appear in a list Select a field type Type a field name Click to set up entry options for a field Note You can also change the appearance of text and the format of numbers, dates, and times for existing fields. For more information, see "Changing the appearance of data" on page 8-34. Adding fields to an existing database To add fields to an existing document, choose Define Fields from the Layout menu. When you create new fields, AppleWorks automatically adds them to the layout you have chosen. * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290
  • 291
  • 292
  • 293

Database
8-7
Tip
When you design a database that holds names and addresses, you can
start quickly by using the Address List Assistant, and then changing the
database as needed. For more information about using Assistants, see “Using
an Assistant” on page 2-4.
Defining database fields
Once you plan the design of a database, the next step is to define the fields
to store the data. When you define a field, you give it a name and then select
a field type to determine what kind of data (for example, numbers or a date)
can be stored in the field. When you open a new database document, you see
the Define Database Fields dialog box, where you set up database fields.
Note
You can also change the appearance of text and the format of numbers,
dates, and times for existing fields. For more information, see “Changing the
appearance of data” on page 8-34.
Adding fields to an existing database
To add fields to an existing document, choose
Define Fields
from the Layout
menu. When you create new fields, AppleWorks automatically adds them to
the layout you have chosen.
*
Choose Index from the
or Help menu and scroll to the entry. Then choose a topic from
the list and click Go To Topic.
In the Help index,
*
see:
E
fields, defining
Field names and field
types appear in a list
Type a field name
Select a field
type
Click to set up entry
options for a field