Question

AssignmentUsing the file InvoiceData.accdb, complete the reports & queries below. Before submitting your work, make sure your file has two reports and seven queries.1) Reports:For each Province, show the sum of Sales, grouped by ShipMode. You can include the sums using the "Summary Options" button in the third Report Wizard window, where you select ascending or descending order – choose the summary (sum) only, not summary and details. Use the Layout View to expand any text boxes too small to display the Sales values – these will display as ########## filling up the text box.Show the sum of Profit for each {ProductCategory, OrderPriority} pair. Group the records by ProductCategory, then OrderPriority, and only show the sum of Profit, not other details.2) Queries:Show the Sales, Profit, and UnitPrice fields (only) of all records with Sales above $10000 AND with the ShipMode being Delivery Truck.Show average Sales for each ProductCategory, from all records with a 2021 OrderDate. You should only have one average value per ProductCategory level.Show the ID, ShipDate, and ShippingCost fields (only) of all records where the ShipDate is between 10/1/2019 and 10/31/2019 and the ProductContainer is Small Box.For each Region, show the sum of Sales for each ShipMode. You should have one sum for each {Region, ShipMode} pair.Show all fields of all records where the ProductCategory is Technology and the ProductContainer is JumboDrum.For each Region, show the sum of Sales from the months of April through October (use ShipDate). The sum should be for the entire six-month range, with separate totals for each year.Show all fields of all records where the ShipMode is not Regular Air (in the query criteria, you can use the "<>" operator for "not equal to") and the ProductContainer is Small Box or Small Pack.

Answer 1

Capacitance is the capability of a material object or device to store electric charge. It is measured by the change in charge in response to a difference in electric potential, expressed as the ratio of those quantities. Commonly recognized are two closely related notions of capacitance: self capacitance and mutual capacitance.

An object that can be electrically charged exhibits self capacitance, for which the electric potential i

s measured between the object and ground. Mutual capacitance is measured between two components, and is particularly important in the operation of the capacitor, an elementary linear electronic component designed to add capacitance to an electric circuit