Access07: Hire Co : Create Hire tables

From virtualMV2015wiki
Jump to: navigation, search
 Home  MS Access <

Entity Relationship diagrams

Acc07 Hire ERD Hire04.png

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

Acc07 Hire ERD HireAcc01.png

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

Acc07 Hire tblClient.png

Equipment table

Acc07 Hire tblEquip.png

Hire table

Acc07 Hire tblHire.png

Icon References.png References


Access07: Hire Co : Create Hire tables. (2017). In virtualMV's ( Michael Verhaart ) wiki. Retrieved December 17, 2017, from http://www.virtualmv.com/wiki/index.php?title=Access07%3A_Hire_Co_%3A_Create_Hire_tables    (zotero)