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
- Summer '10
- bear, REA ontology, human resource process, Freda Matthews