Access07: Hire Co : Create Hire tables

Entity Relationship diagrams


Which in MS-Access becomes (Entity/Attribute data dictionary follows)




 * Notes
 * Client to Hire is an Access type 2 join "Include ALL records from tblClient ..."
 * Equipment to Hire is an Access type 1 join "Only include rows where the joined fields from both tables are equal"
 * When included in the overall Database for the Hire Center, a staff member will be responsible for the Hire, so StfID has been added to tblHire. Later this will be linked to the staff table. But for now, to keep things from getting too complicated this relationship will be added later.

Tables
Client table (is included in the accounts sub system)



Equipment table



Hire table