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.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.
Form window You can add or remove Maximize and Minimize buttons, short cut menus, and other Form window elements.
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.
Controls 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.
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.
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.
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.
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.