Microsoft Access

Starting Off

Video Title
Without Sound
new database
Creating a new database
importing data from txt file
Importing data from a text file


Creating Tables

Video Title
Without Sound
setting datatypes Data types - setting them
design view Design view - changing from datasheet view
field length Field length
indexed field Indexed field
primary key Primary key
drop down list Drop down list
adding records Records - adding them to the table



Video Title
Without Sound
required field Required field
input mask Input mask using a wizard
validation rule Validation rule and text - to allow a specific choice of options e.g. male or female



Video Title
Without Sound
creating relationships Creating a relationship
deleting relationships Deleting a relationship



Video Title
Without Sound
wizard Creating a form using the wizard
customising Customising your form
macro buttons Macro buttons
adding a missing field Missing field - how to add one to your form
video tutorial for creating a subform Subforms
switchboard Switchboard - creating one
setting switchboard Switchboard - setting it to be the opening screen


Finding and sorting data

Video Title
Without Sound
filter Filter
sorting Sort


Setting up Queries

Video Title
Without Sound
simple query Query with one table
from more than one table Query with more than one table
adding field to query Adding a field to an existing query
or query Or query
not query NOT query
is null IS NULL query - to find blank records
between dates Between two dates query
wildcard Wildcard


Setting up Reports

Video Title
Without Sound
setting up Using wizard to create a report