Database Management

YVYB9090
timer Asked: Jul 30th, 2017

Question Description

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors