Database Management Project Microsoft Access

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.

Submission:

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

• Due Date (Double Check): 30/07/2017
• Willing to Pay (USD): 15