Question
Tracking project work. Queries and reports You are responsible for managing information systems development project at AAA systems. To better track progress in completing projects
Tracking project work. Queries and reports You are responsible for managing information systems development project at AAA systems. To better track progress in completing projects , you have decided to maintain a simple database table to track the time your employees spend on various tasks and the projects with which they are associated. It will also allow you to keep track of employee billable hours each week. The table below provides a sample data set. a) Build a database table to store the data shown and enter the records as a set of sample data. b) Create a query that will list the hours worked for all workers who worked more than 40 hours during production week 20. c) Create a report grouped by project that will show the number of hours the number of hours devoted to each task on the project and the subtotal number of hours devoted to each project , as well as a grand total of all hours worked . d) Create a report grouped by employee that will show each employees hours worked on each task and total hours worked. The user should be able to select a production week and find data for just that week presented.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started