Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?

Order Now

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

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

Test your code with any of the online SQL engines.

Grading criteria:
The database needs to make sense (do not have silly fields)
The SQL should run without error and a readable report should be produced

Interested in a PLAGIARISM-FREE paper based on these particular instructions?...with 100% confidentiality?

Order Now