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

Deleting records in a table

Required fields

Input mask using a wizard

Input mask - customising

Range check (validation rule and text)

Lookup wizard from an existing table

Lookup wizard from your own values

Primary and foreign keys

Setting up a relationship

Referential integrity

Editing a relationship

Deleting a relationship

Adding and removing tables

Closing the relationship screen

Creating a form using the wizard

Adding a logo to your form

Changing the background design template

Changing the background colours

Changing the font style and size

Using the format painter tool to copy styles

Resizing the fields

Changing the size of the form

Deleting a field from a form

Adding a missing field to a form

Adding macro buttons to a form

Sub forms

Adding new records to 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