Database Management Project Microsoft Access

Create a database with two tables in Microsoft Access. Each table should be connected via a foreign key. Each table should have a minimum of six fields (to include text and numerical – integer/decimal). You will then produce a report displaying records that satisfy two separate criteria and you will also create two calculated fields (could be the average of the values or an increase in a value, say 12%). You need to use headings other than the field names for the report. All relevant fields should be on the report.


You need to submit the code to:

Create the database (including the field definitions)
Insert (minimum of) 6 records into each table.
Select the report (with calculated fields).

  • 30/07/2017
  • 15
Categories: Questions

Available CoursesAsk Questions & Chat Now
Welcome to!

Click on Peter below to initiate a chat with him on WhatsApp to receive help Anonymously.

× WhatsApp Us & Get Help...