Create and manage a Database

Create a blank desktop database

Create a database from a template

Create a database by using Import objects or data from other sources

Delete database objects

Manage relationships and Keys

Create and modify relationships

Set the primary key

Enforce referential integrity

Set foreign keys and view relationships

Navigate through a Database

Navigate specific records

Create and modify a navigation form

Set a form as the start-up option

Display objects in the Navigation Pane

Change views of objects

Protect and maintain Databases

Compact a database

Repair a database; back-up a database

Split a database

Encrypt a database with a password

Recover data from back-up

Print and Export Data

Print reports

Print records

Save a database as a template

Export objects to alternative formats

Build tables Create Tables

Create a table

Import data into tables

Create linked tables from external sources

Import tables from other databases

Create a table from a template with application parts

Manage Tables

Hide fields in tables

Add total rows

Add table descriptions

Rename tables

Manage records in Tables

Update records

Add records

Delete records

Append records from external data

Find and replace data

Sort records; filter records

Create and modify Fields

Add fields to tables

Add validation rules to fields

Change field captions

Change field sizes

Change field data types

Configure fields to auto-increment

Set default values

Using input masks

Delete fields

Create Queries 

Create a Query

Run a query

Create a crosstab query

Create a parameter query

Create an action query

Create a multi-table query

Save a query

Modify a Query

Rename a query

Add fields; remove fields

Hide fields

Sort data within queries

Format fields within queries

Create calculated fields and grouping within Queries

Add calculated fields

Set filtering criteria

Group and summarize data

Group data by using comparison operators

Group data by using arithmetic and logical operators

Create Forms

Create a Form

Create a form

Create a form from a template with application parts

Save a form

Configure Form Controls

Move form controls

Add form controls

Modify data sources

Remove form controls

Set form control properties

Manage labels

Add sub-forms

Format a Form

Modify tab order

Configure print settings

Sort records by form field

Apply a theme

Control form positioning

Insert backgrounds; insert headers and footers; insert images

Create Reports 

Create a Report

Create a report based on a query or table

Create a report in design view

Create a report by using a wizard

Configure report Controls

Group and sort fields

Modify data sources

Add report controls

Add and modify labels

Format a Report

Format a report into multiple columns

Add calculated fields

Control report positioning

Format report elements

Change report orientation

Insert header and footer information

Insert images

Apply a theme