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

Inserting Fields

Perhaps one of the most common changes you’ll make to your database is to insert a new field in a table. Up until now, we’ve renamed and moved the available fields to more closely match tblContacts. If you take a look at the comparison of the two tables again (Tables 5-1 and 5-2 on page 148 and 149), you can see that we need to add a few more fields. Now you’re ready to insert fields to store the contact title, suffix, contact type, default address indicator, and more.

First, you must select the row or move your cursor to the row that defines the field after the point where you want to insert the new field. In this case, if you want to insert fields for the title (Mr., Mrs., etc.), suffix (Jr., Sr., etc.), and contact type (customer, sales prospect, etc.) between the MiddleInit and Birthdate fields, place the cursor anywhere in the row that defines the Birthdate field. You can also select the entire row by using the arrow keys to move to the row and then pressing Shift+Spacebar or by clicking the row selector. Next, choose the Rows command from the Insert menu (as shown in Figure 5-13) or click the Insert Row button on the toolbar. (You can also click a field row and press the Insert key to insert a row above your selection.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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