Create the employee table and the timesheet table

Employee table has the following fields:

Field	Type	Size
Employee ID	Text	3
First Name	Text	20
Last Name	Text	20
Pay Rate	Number	Double

Timesheet table has the following fields:

Field	Type	Size
Employee ID	Text	3
Date Worked	Date
Hours Worked	Number	Double
Period	Number	Double

Create a form to input all Employees.

Create another form to input all timesheets.

Enter 2 employees with 2 dates worked each.

Create a query that shows each timesheet record with all the employee information and the total pay for that day. Day's pay = Hours Worked * Pay Rate. Sort by Period and then Employee ID

Create a report using the report wizard to print total hours worked and subtotal by period and then person.