Database and tables

Part 1- Create the new database and tables:

1. Create a new database with a name “First_Name_Last_Name_Homework_Assigment_6_Warehouse”. Make sure that you remember where you save your file.
2. Please create table named “tbl_Warehouse_Workers” from the fields below please assign primary key to the correct field.
   WorkerID (use number field, do NOT use auto number)
   Worker_First_Name (text, size 50 characters)
   Worker_Last_Name (text, size 50 characters)
   Worker_Phone_Number (text, 10, format (718)645-3456)
   Worker_Date_Of_Birth (Choose appropriate format)
   Worker_Speciality (text, size 70 characters)
   Current (make it selection yes/ no)
3. Please create table Named “tbl_Warehouses” from the fields below please assign primary key to the correct field.
   WarehouseId (autonumber)
   Warehouse_Name(text, size 50 characters)
   Warehouse_Street_Address(text, size 70 characters)
   Warehouse_City(text, size 50 characters)
   Warehouse_State(text, size 2 characters)
   Warehouse_Zipcode(text, size 5 characters)
4. Create appropriate relationship between warehouse and warehouse worker. One worker can belong to one warehouse, but one warehouse may have many workers.
5. Please create table Named “tbl_Departments” from the fields below please assign primary key to the correct field.
   DepartmentID(autonumber)
   DepartmentName (text, size 30 characters)
6. Create appropriate relationship between worker and department. One worker can belong to one department, but one department may have many workers.
7. Create Table “tbl_Items”
   ItemID(autonumber)
   Item_Name (text, size 100 characters)
   Item_description (text, size 255 characters)
   Item_Price (currency)
   Item_quantity(number)
8. Create appropriate relationship between item and warehouse. One item can belong to many warehouses; one warehouse may have many items. In other words each item can be stored in multiple places.
   Part 2: Create Forms
9. Create Form to browse/ enter new departments. *hint create form for table departments
10. Create Form to browse/ enter new warehouses. *hint create form for table warehouses
11. Create form to browse/ enter new workers. *hint create form for table tbl_Warehouse_Workers
12. Create form to browse/ enter new items *hint create form for table tbl_Items
13. Create form for assigning warehouse to items *hint use your many to many relationships for this task
14. Create form to view Warehouse and all items associated with this warehouse. *hint you may use sub-forms
    Part 3: Create Reports:
15. Create reports to show worker name and warehouse name where the particular worker belongs. Sort it ascending and group by warehouse name.
    Example:
    Warehouse Name
    Worker First and last Name
    Worker First and last Name
    Worker First and last Name
    Warehouse Name
    Worker First and last Name
    Worker First and last Name
    Worker First and last Name
    ………..
16. Create switch form with connection to all forms and reports, exit button. The form should start on access start up.
17. Enter data in each form. At least 5 records.
18. After you done please upload your file to http://asa.blackboard.com
19. If you have any questions , please feel free to e-mail me at [email protected]

Sample Solution