Access 2007 Video Tutorials

Starting a new, blank database

Opening an existing database

Importing data from a text file

Changing between design and data sheet view

Adding functions to the quick toolbar

Reordering icons in the quick toolbar

Adding other commands to the quick toolbar

Removing icons from the quick toolbar

Changing the location of the quick toolbar

Opening an existing table

Creating a new table

Entering field names in design view

Moving the position/ order of fields

Renaming fields

Inserting a new field

Deleting a field

Changing the column width

Setting up data types in design view

Setting up data types in datasheet view

Setting field lengths

Setting the primary key

Indexing a field

Setting a number datatype

Setting the number of decimal places

Adding records to a table

Required fields

Input mask using a wizard

Input mask - customising

Range check (validation rule and text)

Lookup table

Creating a relationship

Deleting a relationship

Creating a form using the wizard

Customising a form

Adding a missing field to a form

Adding macro buttons to a form

Sub forms

Creating a switchboard

Setting a switchboard as the opening screen

Using a filter

Sorting data

Simple query using one table

Query using two or more tables

Adding a field to an existing query

Or query

NOT query

IS NULL query (blank records)

Between two dates query

Wildcards

Creating a report using a wizard

Customising a report

Adding a missing field to a report