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

Adding a New Field

After you've opened the table you want to modify in Design view, click in the Field Name column of the first empty row.

Type a name for the field and press Tab.

INTRODUCTION

It's best to plan out the structure of your table before you build it, mapping out the various pieces of data you need to store and then figuring out what fields you need to store them. If needed, though, you can add a new field at any time. For example, you might need to add a field if you used a wizard to create your table and the default fields did not include all the entries you needed. Or, you might need to add a new field if you created a table from scratch and accidentally left out something.


TIP

Inserting Rows

If you want to add a new field to the middle of your table, rather than to the end, you can do so. Click in the row below the spot where you want the new row to be, open the Insert menu, and choose Rows. The new row is inserted below the selected row.


To change the data type from the default, Text, click the down arrow in the Data Type field and choose a new data type from the list that appears. Then press Tab.

Optionally, type a field description in the Description column. This text appears in the Table window's status bar when you are entering data and this field is selected.

Click the Save button on the Standard toolbar in the main Access window to save your changes to the database table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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