Transform

Specify a transform file when you import data from or export data to XML. The transform is then applied automatically. When you import XML data, the transform is applied to the data as soon as the data is imported, before any new table is created or an existing one is appended to. When you export data to XML, the transform is applied following the export operation.

Importing and Exporting Information

Importing Information from HTML and XML Documents

Property Update Options

In previous versions of Access, whenever you modified a field's inherited property, you had to manually modify the property of the corresponding control in each of the forms and reports. Now, when you modify certain inherited field properties, such as Format and Input Mask, in Table design view, Access displays an option to update the property of all or some controls that are bound to the field.

Keeping Information Accurate

Using Input Masks to Restrict Data

Enhanced sorting in controls

Specify the ascending or descending sort order of up to four fields in the List Box and Combo Box Wizards in forms and reports, and the Lookup Wizard in an Access database. The sort page added to these wizards looks and behaves like the sort page in the Report Wizard.

Keeping Information Accurate

Using Lookup Lists to Restrict Data

Smart Tags

Use the SmartTags property to add a smart tag to any field in a table, query, form, report, or data access page in a database.

Working with Reports

Creating and Modifying a Report in Design View