As you can see, it??™s a
good idea not to change a field name because it creates more work.
CAUTION CAUTION
TIP TIP
TIP TIP
53
Creating Access Tables 2
Changing a field size
Making a field size larger is simple in a table design. However, only text and number fields can be
increased in size. You simply increase the Field Size property for text fields or specify a different
field size for number fields. You must pay attention to the decimal-point property in number fields
to make sure that you don??™t select a new size that supports fewer decimal places than you currently
have.
When you want to make a field size smaller, make sure that none of the data in the table is larger
than the new field width. (If it is, the existing data will be truncated.) Text data types should be
made as small as practical to limit the amount of data entered by the user.
Remember that each text field uses only the number of characters actually entered in
the field. You should still try to make your fields only as large as the largest value so that
Access can stop someone from entering a value that may not fit on a form or report.
Pages:
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