Hey Guys, I'm trying to work on this Access DB for my school assignment and there are just two questions I absolutely cannot figure out. Here is a short description of the project and the questions are listed below.
SoftwareWizards Inc.. is a software consulting company that is engaged in several web-development projects. Each project has its own project number, name, client, employees assigned to the project and so on. Each employee has an employee number, name, and a job classification such as programmer, project manager, graphical designer, strategists and so on. The company charges its clients by billing the hours spent on each contract. The hourly billing rate is dependent on the employee's position. (For instance, an hour's worth of project manager?s time is billed at a different rate than an hour's worth of graphical designer?s time).
Use Query-by-Examples to answer the following questions (Work with the normalized database)
7.
a. Which employee is the most valuable in terms of money brought into the firm?
b. How much does the company charge its clients for each project?
8. Use the report wizard to print a report of employees (include employee number and name) who spend 16 hours or more on a project. Group by project (include project number and project name and client name ).
I've gotten the sum function to work for each employee per project, but I can't aggregate the different projects under the same employee. All the data and my work so far is in the database below. Thanks for any help guys.
My progress so far
SoftwareWizards Inc.. is a software consulting company that is engaged in several web-development projects. Each project has its own project number, name, client, employees assigned to the project and so on. Each employee has an employee number, name, and a job classification such as programmer, project manager, graphical designer, strategists and so on. The company charges its clients by billing the hours spent on each contract. The hourly billing rate is dependent on the employee's position. (For instance, an hour's worth of project manager?s time is billed at a different rate than an hour's worth of graphical designer?s time).
Use Query-by-Examples to answer the following questions (Work with the normalized database)
7.
a. Which employee is the most valuable in terms of money brought into the firm?
b. How much does the company charge its clients for each project?
8. Use the report wizard to print a report of employees (include employee number and name) who spend 16 hours or more on a project. Group by project (include project number and project name and client name ).
I've gotten the sum function to work for each employee per project, but I can't aggregate the different projects under the same employee. All the data and my work so far is in the database below. Thanks for any help guys.
My progress so far
Facebook
Twitter