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 ...

Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.