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

 

Validation

 
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

 

Relationships

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

 

Forms

 
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