Instruction
Complete problem 6-3 with the following requirements:
1) Create 5 tables as shown on Page 205. Enter the data as shown and print each table
2) Implement the relationships between the 5 tables and print the relationship map.
3) Create a billing report for Hasbro, Inc. (H12456). Hint, create a query first and then use the report wizard to create the report from the query. The following should be on the report. Date, Employee number, Hours, and Billing Rate. Total the hours for the client, remember to use the summary option on the report wizard. Print the report.
4) Create a Employee Training report for HR. Hint, create a query first and then group it by employee number using the report wizard. Data fields are employee number, Employee Name, Date, hours and training code. Sub total the hours by each employee (use employee number as a group and select the summary option to summarize the hours). Print the report.
5) Turn in the following: Header page with group and date; print out of data in each table; print out of the relationships; print out of the billing report for Hasbro; and print out of the Employee training report. Total pages should equal 9 which includes the header page.