Page 160 - UNI 101 Computer Science Handout.

Faculty of Nursing
Adult care Nursing Department

PivotTable view, PivotChart view, Form view, Layout view, Report view, and other views

appropriate to the current object.

● Tabbed documents Open multiple database objects and switch between them

quickly by clicking tabs on a tab bar.

● Template library Quickly locate and download professionally designed
templates for common database projects.

● Improved sorting and filtering Easily sort all records in a table based on one or

more fields, or filter a table or form to display or hide records matching multiple criteria.

● Layout view Redesign a form or report while viewing it.

● Stacked and Tabular layouts Group controls in a form or report layout so

you can easily manipulate the entire group as one unit.

● Automatic calendar The Date/Time data type includes an optional
calendar control. Click the calendar, and select the date you want.

● Rich Text Memo fields now support most common formatting options,

including fonts, color, and character formatting. The formatting is stored with the
database.

● Create tab Quickly create a new table, form, query, report, macro,

SharePoint list, or other Access object.

● Totals function Add a totals row to a query, and select from a list of

formulas to automatically calculate aggregate values for forms and reports.

● Field List Drag and drop fields from one or more related or unrelated

173