Description

Part 1- Create the new database and tables:

Create database for daily timesheets.

1.     Create a new database with a name “First_Name_Last_Name_Class_Assigment_4_Timesheets”. Make sure that you remember where you save your file.

2.     Please create table named “tbl_Employee” from the fields below please assign primary key to the correct field.

Employee_ID (use number field, do NOT use auto number)
Employee _First_Name (Choose appropriate format)
Employee _Last_Name (Choose appropriate format)
Employee _Phone_Number (Choose appropriate format)
Employee _Date_Of_Birth (Choose appropriate format)
Employee _Status (Choose appropriate format, but it must be a choice of “current”, “vacation” or “not-current”)

3.     Please create table named “tbl_Manager” from the fields below please assign primary key to the correct field.If needed create a new field to represent a primary key

 Manager_First_Name(Choose appropriate format)

 Manager_Last_Name(Choose appropriate format)

 Manager_Phone_Number

 Manager_Status (Choose appropriate format, but it must be a choice of “active”, “inactive”)

4.     Please create relationships between tbl_Manager and tbl_Employee. Each employee can have only one manager, but one manager can have many employees.

5.     Each day employee comes to work and have to fill out a timesheet. It would be helpful if you can create MS Access application to accommodate that need.

In order to do that you need to create more tables and relationships.

Hint: You’ll need to have some table(s) to record each day when employee comes in. You need to record Date and Time when employee came to work. Also you’ll need to create relationships to support such functionality.

6.     After you created database structure to support timesheets entries add to the structure support for timesheets approval.

Part 2: Create Forms

7.     Create Form to browse/ enter new employees, form also should support of assigning manager to an employee - *hint you can use combo box

8.     Create Form to browse/ enter new managers. Also in addition to enter information for the manager you can also view and assign employees to that manager

9.     Create form to enter new timesheets in the database.

Part 3: Create Reports:

10.  Create report to show Managers and their employees. The report should show Manager’s First and Last name and underneath should show connected employees

Manager’s First Name , Manager’s last name

              Employee First Name, Employee Last Name

              Employee First Name, Employee Last Name

              Employee First Name, Employee Last Name

              Employee First Name, Employee Last Name

Manager’s First Name , Manager’s last name

              Employee First Name, Employee Last Name

              Employee First Name, Employee Last Name

              Employee First Name, Employee Last Name

              Employee First Name, Employee Last Name

Manager’s First Name , Manager’s last name

              Employee First Name, Employee Last Name

              Employee First Name, Employee Last Name

              Employee First Name, Employee Last Name

              Employee First Name, Employee Last Name

11.  Create report which will ask for Date and as an output it will show timesheet of every employee who worked that day including start and end time for that date.

Date: 11/13/2012

Employee First Name, Employee Last Name – 11:30 am to 1240 p.m.

Employee First Name, Employee Last Name – 11:30 am to 1240 p.m.

Employee First Name, Employee Last Name – 11:30 am to 1240 p.m.

Employee First Name, Employee Last Name – 11:30 am to 1240 p.m.

Employee First Name, Employee Last Name – 11:30 am to 1240 p.m.

12.  Create switch form with connection to all forms and reports, exit button. The form should start on access start up.

13.  Enter test data for at least 5 employees, for at least 5 working dates