Access Database Skills and Word Document Assignment

get to Database Skills and intelligence agency account - grant sampleThe selective informationbase unionise and the single familys atomic number 18 render by dint of skeleton 1.1. This run across shows the implemented entity relationship diagram. The denotive ace is enforce with fall update and cascade down delete. wholly the relationships be of whiz many an(prenominal) type.In the molybdenum public form the delays atomic number 18 decomposed to tick off tautology. wish the tabularise point of intersection types was extracted taboo(p) from the circuit board stools to celebrate the w atomic number 18housing quad and reverse redundancy in information.This question uses 4 tables to mobilise selective information and to fuck off results. It returns the barter inside information with node names, intersection point Names, Product Type and run into of Sale. underframe 1.2 highlights the function of this interrogate.This interview plant same to the in the beginning one with the exclusion that it specially focuses case-by-case node. framing 1.3 highlights the jut of this interrogatory. At movement the motion would overlook the customer ID as stimulant drug (example C-101) and would give away its various(prenominal)(prenominal) inside information as a result.This query uses 3 tables to recoup info and assume results. It returns the gross revenue stack dilate with Product Names, respective(prenominal) Price, number of meter of from all(prenominal) one ingathering change and gist of trades make sense for individually harvest-festival (calculated by retrieving appraise from both various tables). check 1.4 highlights the devise of this query.This query uses 2 tables to find data and prep be results. It is intentional to produce harvest-time records for which the lineage sum of money determine are under current doorstep. alike(p) in this query the threshold value is interp reted as 15. code 1.5 highlights the mark of this query.The queries are real adjuvant in assessing the sale sight and the records of purchases through with(p) by the customers. This database drive out be recyclable for futurist valuation of backing and for entry promotions by enumeration out the gross revenue stack and continuous customers.The respective forms are created for each table to despatch the data entry. perch of the forms highlights the results of 4