Database Reference
In-Depth Information
▪
View Shortcuts toolbar
This context-sensitive toolbar in the lower-right corner of
the program window provides single-click switching among the supported views of
the current database 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 that 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 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 tables onto
your active table.
▪
Attachment data type
Attach photos and other files to a database record.
▪
Embedded macros
Macros embedded in a form or report offer a higher level of
security in database applications.
▪
Microsoft Access Help
Easily search end-user and developer help content from
within Access.
1