Microsoft Office Tutorials and References
In Depth Information
Editing and Modifying a Database
To delete a field from a database table, follow these steps:
1. Click the field (column head) you want to delete.
Access highlights the entire column in your database table.
2. Click the Delete button in the Add & Delete group.
If you have stored data in that field, a dialog box appears, asking
whether you want to permanently delete all the data in the field.
If you delete a field, you also delete any data that may be stored in that
field. Depending on how much data you have stored, you could wipe out
a lot of information by deleting a single field, so be careful.
3. Click Yes (or No).
If you click Yes, Access deletes your chosen field.
Defining the type and size of a field
The type of a field defines the type of data the field can hold (numbers, text,
dates, and so on), and the size of a field defines the amount of data the field
can hold (no numbers larger than 250 digits, any text string fewer than 120
characters, and so on).
The purpose of defining the type and size of a field is to make sure that you
store only valid data in a particular field. If a field is meant to store names,
you don’t want someone typing in a number. If a field is meant to store a
person’s age, you don’t want the field to accept negative numbers.
To define the type and amount of a data a field can store, follow these steps:
1. Click the Home tab.
2. In the All Tables pane on the left of the screen, double-click the table
that contains the fields you want to define.
Access displays the Datasheet view of your table.
3. Click the bottom half of the View icon (that displays a
downwardpointing arrow), which appears in the Views group.
A pull-down menu appears.
4. Click Design View.
Access displays the Design view of your database table.