Access - Database Design and Reporting

Create a new database

Create data tables

Set field validation and properties

Enter data and manage data

Create forms

Use queries to extract data

Create parameter queries

Create calculations in queries

Build relational databases

Use sub datasheets

Build multi table queries

Use advanced form and report design techniques

Creating a new database

Database elements

Setting field properties

Using input masks

Using input masks

Validation rules

Default values

Setting a primary key

Creating lookup fields

Adding data

Deleting data

Quick keys for data entry

Sorting data

Filtering data

Finding information

Navigation

Creating quick forms

The form wizard

Amending forms

Formatting

Setting the tab order

Entering data using forms

Creating a query

Setting criteria

Using the expression builder

Using wildcards

Using more than one parameter

Adding a totals row

Formatting results

Adding calculations

Printing tables and queries

Creating reports

Building and amending reports

Adding headers and footers

Relational database principles

Importing data from other sources

Linking information between tables

One-to-one and one-to-many links

Defining referential integrity

Amending links

Deleting links

Viewing a subdatasheet

Removing a subdatasheet

Connecting a subdatasheet

Deciding which tables to use

Adding tables to the query

Creating links between tables

Setting join properties

Field properties

Creating lookup fields

Adding calculated fields

Applying conditional formatting

Field properties

Report properties

Alternate colour bandings

Concatenating fields

Adding calculated fields

Sorting and grouping

Grouping settings

Adding headers and footers

Adding dates, times, page numbers