Page 49 - Computer - 8

Renaming a Field

To rename a field:

1. Click the cell in the Field Name column for the field that you want to rename.
2. Type the new name.

Access renames the field.

Moving a Field

To move a field:
1. Click the Row selector for the field you want to move.

1

2. Drag the field vertically and drop it where you want to place it.

2

Access moves the field to the new position.

Database Subject Enrichment

Access is the best choice when you must track and record data regularly and then display, export, or print
subsets of that data. Access forms provide a more convenient interface than an Excel worksheet for working
with your data. You can use Access to automate frequently performed actions, and Access reports let you
summarise data in printed or electronic form. Access provides more structure for your data; for example,
you can control what types of data can be entered, what values can be entered and you can specify how
data in one table is related to data in other tables. This structure helps you ensure that only the correct types
of data are entered. Access stores data in tables that look much the same as worksheets, but Access tables
are designed for complex querying in relation to data stored in other tables.

47