• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Adding Fields

You should add a field to your table whenever you spot a gap in your information. One common reason to add a field is to give you a place to enter comments that will explain or give insight into a record. Keep the basic information in other fields, but adding a comment field allows you to enter information that may not fit elsewhere.

To add a field:

1.
Display the tables in your database and select the table you want to open.

2.
Click the Design toolbar button ( Figure 3.17 ).

Figure 3.17. Clicking the Design button opens a table in Design view.


Your table appears in Design view ( Figure 3.18 ).

Figure 3.18. Once you've opened your table in Design view, you can start adding fields and comments.


3.
Add a field to your table by typing its name in the first open Field Name cell. Press Tab to move to the Data Type cell.

4.
Click the drop-down menu that appears in the Data Type cell and select a data type for your new field. Press Tab.

5.
Type a description for your new field in the space provided.

6.
Choose File > Save to save your changes.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint