PLEASE MAKE AN ACCESS DOCUMENT BASED ON THE FOLLOWING

• Create a database to record rental housing units and repairs (2 tables are enough - Houses table & Repairs table listing repairs). You need to record the houses and their repairs -Think of the data needed & how the tables will be related.
• Houses table listing housing units should have 9 fields - ONE FIELD MUST BE A YES/NO FIELD SPECIFYING IF THE UNITS IS AN "ACCESSIBLE UNIT" (DO NOT LIST POINTLESS DATA SUCH AS "HAS A SINK"). You are NOT selling these houses.
• Record 5 houses in your database
• Repairs table listing 12 repairs should have 6 fields
• YOU HAVE TO LIST 2 PLUMBING REPAIRS and your choice others such as door locks, windows etc - MUST BE 6 REPAIR TYPES AT LEAST
  • consider what common field (key) will connect the two tables (Primary Key from one table connected to the Foreign Key in the other table)
  • create a relationship to join the two tables together
• create at least 2 Queries to combine information from both tables
  • one Query should list all theaccessible units - name it "Accessible Qry"
  • one Query list all the plumbing repairs - name it "Plumbing Qry"
  • one Query should include statistics on the repairs costs - name it "Repair Stats Qry"
• create a Form with Sub-Form that displays data from both tables
• create a Report with an image and good formatting that displays houses and their repairs

THE QUERY AND REPORTS HAVE TO HAVE DATA IN THEM ,