Practice for MS Access

Products
Product ID	Product Name			Product Quantity	Unit Price
P01	Soap			3260	$15.60
P02	Tin Fish			7800	$49.68
P03	Rice			49700	$35.00
P04	Tea			6500	$125.65
P05	Milk Powder			12560	$45.90
P08	Egg			24500	$45.50
P10	Coconut Oil			4500	$78.90
Sales Person
Sales Person	Title	First Name		Last Name	City
S100	Mr	Selvam		Ranjith	Trincomalee
S101	Miss	Anand		Anitha	Kantale
S102	Mr	Rizwanqn		Niyas	Muthur
S103	Mr	Manilal		Fernando	Trincomalee
S104	Miss	Lucas		Dilana	Thoppur
S105	Mr	Munjeep		Rahman	Muthur
Customer
Customer ID	Title	First Name	Last Name	City	Sales ID
C1000	Mr	Hamshan	Balan	Trincomalee	S100
C1001	Miss	Kaleel	Rizzwana	Kantale	S101
C1002	Miss	Shanger	Yamuna	Muthur	S102
C1003	Mr	Pradees	Gajan	Nilaveli	S103
C1004	Mr	Hansan	Ali	Thoppur	S104
C1005	Miss	Bandara	Sithara	Trincomalee	S105
C1006	Mr	Liyanage	Leela	Kantale	S106
C1007	Mr	Anees	Shafi	Muthur	S107
C1008	Mrs	Murugesu	Kumari	Nilaveli	S108
C1010	Mr	Faiz	Shafran	Kantale	S110
C1019	Mr	Lucas	Xavier	Thoppur	S109
Orders
Order ID	Customer	Order Date	Product ID	Order Quantity	Order Type
OR1	C1000	01-Jan-03	P01	5	TP
OR10	C1003	05-Jan-03	P004	3	TP
OR11	C1005	05-Jan-03	P08	8	SP
OR12	C1010	06-Jan-03	P02	5	TP
OR2	C1000	01-Jan-03	P03	2	SP
OR3	C1000	01-Jan-03	P03	3	TP
OR4	C1002	02-Jan-03	P10	1	DR
OR5	C1005	02-Jan-03	P05	8	DR
OR6	C1003	02-Jan-03	P05	3	TP
OR7	C1006	03-Jan-03	P03	7	SP
OR8	C1009	04-Jan-03	P03	4	TP
OR9	C1000	04-Jan-03	P08	2	SP

1)     Create the above table in your database

2)     Define Primary Key to create the relationship between tables

3)     Make Query Order Type that placed by TP & DR name it as “Query TP & DR”

4)     Create Query to find the Total cost by (Unit Price*Product Qua) name it as              “Total Cost”

5)     Create a Query to display the Customer title Miss and Mr and name it as “Miss       & Mr”

6)     Create a Query to Display the 23% Commission of Products’ Total cost name it       as “Commission 23%”

7)     Create a Query to Display the Full Name

8)     Crate form to each table and name it as Frm Product, Frm Sales Person, Frm             Customer, Frm Orders

9)     Insert Buttons With Following conditions “Go to Previous, Go Next, Close               Form, Add New Record, Open Form (create three buttons for each to display           another forms)”

10) Create a Report to each table and name it as Rep Product, Rep Sales Person,           Rep Customer, Rep Orders