MS Access Database Project

  • Start by deciding on an area to develop a database for. It should be different than anything we did in class.
  • Write a brief problem narrative that describes what information needs to be stored.
  • Create an entity-relationship diagram. There should be at least three entities in your diagram. The entities should be connected to each other - no "islands".
  • Convert your ER diagram into normalized tables, and create these tables in an Access database.
  • Use the Relationships tool, and include all tables. Referential integrity should be enforced for all tables.
  • Populate the normalized database tables. There should be at least one table with at least 20 records, and all tables should contain at least 5 records.
  • Create at least eight useful queries - two of which should use a function; one of which should use a GROUP BY; and at least three of which use more than one table.
  • Create a form to permit data entry into all tables. There should be at least one multiple-table form.
  • Create reports to display all table data. There should be at least one multiple-table report. Have summation rows if reasonable.
  • You will present your work to your instructor at the last class meeting. Use the signup sheets to select a time. Have your problem narrative and ER diagram available on paper.
Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.