In Design view
You can customize a form in Design view in the following ways:
Record source Change the tables and queries that a form is based on.
For more information, see the topics Change the record source or connection information and Bind a blank form or report to one or more tables or queries.Controlling and assisting the user You can set form properties to allow or prevent users from adding, deleting, or editing records displayed in a form. You can also add custom Help to a form to assist your users with using the form. For more information, see the following topics:
Form window You can add or remove Maximize and Minimize buttons, short cut menus, and other Form window elements. For more information, see the topic Customize a form or report window.
Sections You can add, remove, hide, or resize the header, footer, and details sections of a form. You can also set section properties to control the appearance and printing of a form. For more information, see these topics:
Controls and subforms You can move, resize, or set the font properties of a control. You can also add controls to display calculated values, totals, current date and time, and other useful information on a form. For more information, see these topics:
In PivotTable or PivotChart view
You can customize a form in PivotTable or PivotChart view in the following ways:
Add, move, or remove fields You can add fields to the filter, row, column, and detail areas in PivotTable view, and to the filter, category, series, and data areas in PivotChart view. You can also move fields from one area to another and remove fields from the view. For more information, see the topic Add, move, or remove a field in PivotTable or PivotChart view.
Filter records You can filter data displayed in the view by adding or moving a field to the filter area. You can also filter a field in the row and column area. For more information, see the topic Create a filter.
Sort records You can sort items in row or column fields in ascending or descending order. You can also sort items in custom order in PivotTable view. For more information, see the topic Sort records.
Group records You can group items in row or column fields on intervals, or create custom groups.
Format elements and change captions In PivotTable view, you can change the font settings, alignment, background color, and number format of a field. You can also change the captions of fields and custom groups. In PivotChart view, you can change the chart type, format data markers, and more. For more information, see the topics Format an element in PivotTable or PivotChart view and Add or change captions, labels, and titles in PivotTable or PivotChart view.