In this chapter we cover adding a field to a table in design view, insert/delete fields, enter a caption and default value for field and setting field properties.

In This Chapter:

Adding a Field to a Table in Design View

Before entering data, Michael checks the table design. This is an important activity, as it enables you to add/delete a field before entering the data.

Inserting/Deleting Fields

Here we go over inserting fields at a certain point in a table's list of fields.

Entering a caption and default value

Michael decides to enter captions and default values in the fields to make the database user-friendly and easy to operate.

Setting the Field Properties: Size Format etc

Now we set other common properties of database table fields