ISDD+Reports,+Forms+and+Calculations

media type="custom" key="28198579"


 * Questions**

Download the Employees by Country file



1. Create a report on the Employees table, grouped by country which shows the total salary of employees for each country.

2. Create a form for the table to make it easier to view and enter data

3. DesktopPC build and sell computers. They use the relational database below to store their data: 

(a) Why does the components table require a compound key?

(b) Draw an entity-relationship diagram to illustrate the relationships between the four tables.

A report is produced each time a customer makes an order. An example is shown below.

(c) This report is based on a query. State a list of the tables and fields that would be used in this query and any criteria that would be used to select the above data.

(d) The report includes a single total of £880 after the three price totals. Describe how this can be done in the report.