Access 2007 Video Tutorials

Starting a new, blank database

Opening an existing database

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

Picture check

Range check (validation rule and text)

Input mask wizard for telephone number

Input mask wizard for postcode

Input mask wizard for postcode - customising it

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