Access 2007 Video Tutorials

Starting off Validation
The quick toolbar Relationships
Tables, Fields & Records Forms

 

Starting off

Starting a new, blank database

click here

Opening an existing database

click here

Changing between design and data sheet view

click here
 

 

The quick toolbar

Adding functions to the quick toolbar

click here

Reordering icons in the quick toolbar

click here

Adding other commands to the quick toolbar

click here

Removing icons from the quick toolbar

click here

Changing the location of the quick toolbar

click here
 

 

Tables, Fields and Records

Tables

Opening an existing table

click here

Creating a new table

click here
 

Setting up fields

Entering field names in design view

click here

Moving the position/ order of fields

click here

Renaming fields

click here

Inserting a new field

click here

Deleting a field

click here

Changing the column width

click here

Setting up data types in design view

click here

Setting up data types in datasheet view

click here

Setting field lengths

click here

Setting the primary key

click here

Indexing a field

click here

Setting a number datatype

click here

Setting the number of decimal places

click here
 

Records

Adding records to a table

click here

Deleting records in a table

click here
 

 

Validation

Required fields

click here

Picture check

click here

Range check (validation rule and text)

click here

Input mask wizard for telephone number

click here

Input mask wizard for postcode

click here

Input mask wizard for postcode - customising it

click here

Lookup wizard from an existing table

click here

Lookup wizard from your own values

click here
 

 

Relationships

Primary and foreign keys

click here

Setting up a relationship

click here

Referential integrity

click here

Editing a relationship

click here

Deleting a relationship

click here

Adding and removing tables

click here

Closing the relationship screen

click here
 

 

Forms

Designing a form

Creating a form using the wizard

click here

Adding a logo to your form

click here

Changing the background design template

click here

Changing the background colours

click here

Changing the font style and size

click here

Using the format painter tool to copy styles

click here

Resizing the fields

click here

Changing the size of the form

click here

Deleting a field from a form

click here

Adding a missing field to a form

click here