Summary Database Checklist

Task Checklist

Task Completed
Read the task THOROUGHLY
Import data into Access – remember NO PRIMARY KEY

Look for obvious Primary keys e.g. ID; write up the tables on paper and list fields in
each

Draw Entity Relationship Diagram on paper – link the tables where you think there
are relationships, what end of the link lines are the many relationships? Include the
foreign key in the table with the many end of the link line

Create your ‘first tables’

Copy your ‘first’ table structures – use correct name i.e. tbl…

Edit your new tbl tables change ID to AutoNumber only IF it is a number already, if
not leave it as it is

Create the Primary Keys

Create Append queries using the ‘first’ tables to append to the correct tbl tables

Don’t forget to RUN the append queries

Delete all the ‘first’ tables

Check the data types are correct for the fields in all the tables

Create the table lookups to make the relationships between primary keys and the
foreign keys

Create any dropdown lists you need e.g. M, F or 1,2,3 etc.

Adjust the text fields to suitable lengths

Add validation rules i.e. Is Not Null, add any more validation rules needed e.g.
between 1 and 3

Add validation text

Format date fields to short date

Format email fields to *?*@*.*

Create the queries – name them qry1…., qry2…. Etc.

Create the query to go with the report

Create the report – name it rpt…
Don’t forget to format the report so that it looks nice – give it a suitable header