Practice for MS Acess

Customer
Customer No	Customer Name			Customer Region
1	Herbert			Cidney
2	David			California
3	Mary			Melbourne
4	Anne			Tokyo
5	Jadeja			Melbourne
6	Mary Taylor			Cidney
7	Flemming			Cidney
8	Peter			Melbourne
9	Kumble			Cidney
Supplier
Supplier		Cost of the Deal		Quantity		ID	Unit Price
Swedish Trading		1500		50		1	Rs. 8,000.00
Chang Shai Co.		100		14		2	Rs. 450.00
Globel Net Co.		200		50		3	Rs. 890.00
Swedish Trading		420		78		4	Rs. 2,354.00
Chang Shai Co.		600		98		5	Rs. 4,512.00
Globel Net Co.		50		56		6	Rs. 3,697.00
Chang Shai Co.		300		12		7	Rs. 7,452.00
Globel Net Co.		900		35		8	Rs. 14,789.00
Globel Net Co.		80		45		9	Rs. 9,845.00
Detail
Customer No	Supplier		Discount Amount		Date Sold
1	Swedish Trading		$5,000.00		03/12/1990
2	Chang Shai Co.		$400.00		04/15/1990
3	Globel Net Co.		$450.00		03/20/1990
4	Swedish Trading		$850.00		05/23/1990
5	Chang Shai Co.		$400.00		03/24/1990
6	Globel Net Co.		$2,000.00		02/12/1990
7	Chang Shai Co.		$2,850.00		05/18/1990
8	Globel Net Co.		$3,500.00		03/10/1990
9	Globel Net Co.		$500.00		02/15/1990

1)     Create above Database as Table Define Primary Key to create the relationship        between tables

2)     Change the Grid line color to Dark Green and align all tables to center

3)     Create a Query to display all Customer No, Customer Name, Customer Region,       Supplier, Quantity and Unit Price and save the Query as Query Cus01

4)     Create another Query to Display Customer No, Customer Name, Suppliers from      “Chang Shai Co.”and save it, name the Query as Query Cus02

5)     Design a Query to view the records which contains date from 01/01/1990 to             02/28/1990, Output Must Listed by following Heading as Query Cus03

6)     Insert another field to Supplier Table as “Cost Of the Deal” and enter the                   following figures to the new column :-(1500,100,200,420,600,50,300,900,80)

7)     Count how many ID from the same Suppliers

8)     Create 3 forms from above tables and insert buttons “Go to Previous, Go Next,        Go to First, Go Last, Close Form, Print Form & Record, Save Record”. And            Name the forms as Frm Cus01, Frm Cus02, Frm Cus03

9)     Find Out the Full Amount (Full Amount = Unit Price*Quantity) and Find Out         the Balance Price (Balance Price = Full Amount – Discount Amount) and do it         in the Form and name the form as “ Form Equation”

10)Create 3 Reports for each and Name it as Rep Cus01, Rep Cus02, and Rep              Cus03 and make another report to display the form Equation Details and name it      as “Rep Equation”.