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).
Test your code with any of the online SQL engines.
The database needs to make sense (do not have silly fields)
The SQL should run without error and a readable report should be produced