• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 2. Creating Databases and Tables > Setting a Field's Data Type

Setting a Field's Data Type

After you've opened the table you want to modify in Design view, click in the Data Type column for the field you want to change.

To change the data type from the default, Text, click the down arrow in the Data Type field.

Choose a new data type from the list that appears.

The field type is changed. Click the Save button on the Standard toolbar in the main Access window to save the changes to the table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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