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
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
