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

Chapter 7. Linking, Importing, and Expor... > Modifying Linked and Imported Tables

Modifying Linked and Imported Tables

Access provides a great deal of flexibility in the presentation of the Datasheet view of tables. You can rearrange the sequence of fields in Datasheet view without changing the underlying structure of the database. You also can alter the Caption property of the fields to change the names of the field name buttons. Although you cannot modify the field names, field data types, or Field Length properties of linked tables, you can use the Format property to display the data in linked or imported tables in various ways, as described in the following sections.

Restructuring the Presentation of Tables

The basic structure of the tables you link or import is controlled by the structure of the files from which the table was created. The original structure, unfortunately, may not be in the sequence you want to use for data entry. Database design, for example, often displays the key fields in a left-to-right sequence, starting with the first field. This sequence may not be the best sequence for entering data. You can change the order of the fields displayed by dragging and dropping the field name buttons of linked or imported tables to new locations, using the method described in Chapter 4, "Working with Access Databases and Tables."


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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