Practice for MS Access

Tape
Tape ID	Tape Name	Director	Language	Story Type	Tape Type
125	Nantha	Bala	Tamil	Social	VCD
126	Boys	Shanger	Tamil	Love	DVD
127	Kankalaal Kaithu Sei	Bharathiraja	Tamil	Love	Tape
128	Rangeela	Shekar Kapoor	Hindi	History	DVD
129	Roja	Manirathnam	Tamil	Terrorism	VCD
130	Mowna Ragam	Manirathnam	Tamil	Love	Tape
131	Kaaka Kaaka	Gowtham Menon	Tamil	Action & Love	VCD
132	Acham Enpathu Madamaiyada	Gowtham Menon	Tamil	Action & Love	DVD
133	Engeyum Kadhal	Prabu Theva	Tamil	Love	DVD
134	Kovil	Hari	Tamil	Love	VCD

Customer
Customer ID	Cutomer Title	Customer First Name	Customer Last Name	Customer Address	Customer TP No
X100	Mrs	Vincent	Reeta	104,Lobster, Tri	22345
X101	Mr	Cerchil	Maliniaalan	10/5,Varnasi, Tri	21698
X102	Mr	Huwain	Saavith	5/4, N.C rd, Kan	36521
X103	Miss	Ranakan	Ranathi	12, Lati Colony, Jaf	27545
X104	Miss	Saagar	Shrija	203, Nortan Rd, Myt	39452
X105	Mrs	Mathushan	Maathuri	23, Vishwa St, Kan	32654
X106	Miss	Marukan	Vasanthi	45, Hoorin, Bat	49562
X107	Mrs	Virukshan	Meena	12, Latin Colony, Jaf	48744
X108	Miss	Lakmanam	Maalini	23/8, Wistan, Kan	25488
X109	Mrs	Shriman	Saavithri	489, Hershan, Col	15154

Rental
Order ID	Tape ID	Cust ID	Rental Date	Return Date
1	125	X100	01/01/2014	02/01/2015
2	126	X101	10/01/2014	15/01/2015
3	127	X102	10/01/2014	12/01/2015
4	128	X103	20/01/2014	24/01/2015
5	129	X104	25/01/2014	25/03/2015
6	130	X105	28/01/2014	28/03/2014
7	131	X106	31/01/2014	31/05/2014
8	132	X107	30/01/2014	16/05/2014
9	133	X108	01/02/2014	18/04/2014
10	134	X109	08/02/2014	08/04/2014

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

2)     Change the Grid line color to Dark Blue

3)     Create Query to display Customer and Rental details and name it as Query Cus & Ren

4)     Create Query to display Customer and Tape details and name it as Query Cus & Tap

5)      Create Query to display Manirathanam films name it as Query Manirathnam

6)     Create Query to display who are the customers lend films in DVD name it as DVD-Query

7)     Create Query to display only Tamil Movies and name it as “Tamil Query”

8)     Create forms for each table and name it as “Frm Customer, Frm Tape, Frm Rental”

9)     Add Buttons with following conditions“Find Next, Go to Previous, Go Next, Go to First,        Go Last, Close Form, Add New Record, Delete Record, Save Record”

10)Create Report to each table and name it as “Rep Customer, Rep Tape, Rep Rent”