Query Analysis - Chemical Composition - Data - Additional Tables - Report Writing Assessment Answer

Assessment Task:

Query Analysis - Chemical Composition - Data - Additional Tables - Report Writing Assessment Answer 

Introduction
Students have to complete all the following parts of this assessment taks:
A.    SQL Queries
B.    Query Analysis
C.    Form 
D.    Report 

Important

Download the Microsoft Access database, Chemical_Composition_Analysis.mdb, from the unit website and use it to complete this assessment.  If you get a security warning message when opening the downloaded database, then you need to open/click the options and then choose the option “enable this content”.
Do not modify the structures of the tables and relationships.  Do not create additional tables.  It is not recommended to delete any of the existing records from the downloaded database (hereafter referred as ‘your database’).
You need to write SQL queries in your database and make sure those queries produce the desired results as shown in Part A. Save and name those queries suitably such as Q1, Q2, Q10 respective to the question that you are answering.
You need to create a MS Access-form and also a MS Access-report that are related to Part C and    Part D and save them in your database.
 
Chemical Composition Analysis

The database, Chemical_Composition_Analysis.mdb, contains tables that can store the data related to the appointments made by the clients for analysing the chemical composition of materials collected by the government agencies.  Tests are conducted on materials only when referred by the government agencies. Tests are conducted by the Lab technicians, who have expertise in various chemical tests.  In order for the tests to be conducted, the employee of the respective government agency needs to make an appointment with a particular lab technician.    Only one material/sample is tested by the assigned lab technician in that appointment.  If there is more than one sample, then tests are carried out only when there are subsequent appointments.  As per the testing process, similar tests may be conducted on multiple samples in different appointments. 
 

This Report Writing Assessment has been solved by our Report Writing experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.