This preview shows page 1. Sign up to view the full content.
Unformatted text preview: the wage rate and the time worked. D3. Consider the tables in exhibit 12-7. Describe the necessary procedures to construct a query to determine the number of hours for which Freda Matthews is scheduled to work during the first week of April 2010. Using the Employee Table & Participation Labor Schedule Employee Table you would connect the EmpID’s on both tables. Then you would should the Employee Name, Hours Scheduled. Enter Criterion LIKE *E18* in the Employee ID Field; Display Name and Hours Scheduled D4. Consider the tables in Exhibit 12-5. Describe the necessary procedures to construct a query to determine the total number of labor hours needed for unfulfilled labor requisitions. Using the Proposition Relationship table; enter criterion =SUM in the Hours Needed Field; display total hours needed....
View Full Document
This note was uploaded on 09/27/2010 for the course ACCT 425 taught by Professor Terawooten-tanner during the Summer '10 term at Franklin.
- Summer '10