Copy and paste the following text in note pad and save it as club players
"MemberID","Title","FirstName","LastName","Address1","Address2","Address3","DateOfBirth","Gender","MemberType"
1021,"Mr","Frank","Streeter","78 Fratton Way","Perth","BD9 6ZZ",13/08/1990,"M","J"
1022,"Ms","Heena","Shah","127 Lonner Street","Molden","BD3 6AZ",17/07/1979,"F","L"
1023,"Mr","William","Ponsonby","26 Railway Street","Highcliffe","BD6 2HF",16/12/1978,"M","M"
1024,"Mr","Mark","Pratney","45 Stoddard Way","Wendhoven","DR3 4GH",02/03/1971,"M","M"
1025,"Mrs","Sally","Kent","34 Way Street","Dratton","DR4 8JK",24/09/1978,"F","L"
1026,"Mr","Thomas","Pranney","56 Franconia Way","Molden","BD3 5TH",05/06/1967,"M","M"
1027,"Mr","David","Pratton","721 Merther Road","Highcliffe","BD6 8LS",09/07/1978,"M","M"
1028,"Mr","David","Pratter","34 Marks Way","Molden","BD3 6GC",04/06/1958,"M","M"
1029,"Miss","Sarah","Fertgin","113 Leighton Avenue","Molden","BD3 2DS",18/03/1963,"F","L"
1030,"Mrs","Josie","Jones","46 Stratton Road","Wendhoven","DR3 5VC",29/06/1974,"F","L"
1031,"Miss","Sadie","Jones","47 Station Street","Ayton Village","DF1 3MK",14/08/1972,"F","L"
1032,"Mr","Robert","Newell","44 High Street","Westering","BD3 5YP",28/03/1954,"M","M"
1033,"Mr","Stanley","Newell","913 High Street","Highcliffe","BD6 7TV",13/12/1990,"M","J"
1034,"Miss","Sally","Jones","16 The Street","Wendhoven","DR3 4HG",02/05/1965,"F","L"
1035,"Mrs","Sarah","Slowcombe","4 Highground","Ayton Village","DF1 3FB",14/11/1982,"F","L"
1036,"Miss","Joan","Katton","3 Derwent Heights","Highcliffe","BD6 9LX",07/09/1971,"F","L"
1037,"Mr","Sidney","Slanter","56 Forth Way","Highcliffe","BD6 3DF",01/10/1986,"M","M"
1038,"Miss","Christine","Pommel","92 Stratford Road","Molden","BD3 6HG",26/01/1971,"F","L"
1039,"Mr","James","Bently","91 Porton Road","Molden","BD3 7UJ",18/10/1990,"M","J"
1040,"Mr","Robert","Dace","5 Ramthorns Close","Churchly","BD3 5TR",05/07/1982,"M","M"
2034,"Mr","Peter","Smith","30 High Street","Wendhoven","DR3 4HK",01/03/1989,"M","J"
2987,"Miss","Susan","Jones","15 Durham Road","Molden","BD3 5TD",17/04/1990,"F","J"
7484,"Mr","David","Breen","1 Grange Road","Highcliffe","BD6 2FT",25/07/1990,"M","M"
9345,"Mrs","Charlotte","Benson","5 Main Street","Molden","BD3 3NH",15/04/1990,"F","L"
3815,"Mr","Anthony","Lumsden","11 Newton Street","Waterfield","YO14 8BD",19/10/1980,"M","M"
7659,"Miss","Debbie","Conlin","21 West Road","Molden","BD3 8DV",03/07/1974,"F","L"
3496,"Mr","Steve","Penn","13 Newton Street","Highcliffe","BD6 6YH",29/08/1990,"M","J"
6956,"Mr","Michael","Gettins","The Croft","Ayton Village","DF1 4XH",08/09/1985,"M","M"
5279,"Mr","Martin","Gale","45 Bexhill Road","Wendhoven","DR3 7HD",09/02/1984,"M","M"
9235,"Mr","James","Gainford","132 Beck Road","Highcliffe","BD6 5DF",23/10/1990,"M","J"
3814,"Mr","John","Betts","14 Church Road","Wendhoven","DR3 9HB",12/07/1967,"M","M"
3261,"Mrs","Joan","Henson","21 Fairley Way","Ayton Village","DF1 3DP",14/06/1986,"F","L"
3321,"Mr","Ravinder","Patel","13 Westover Avenue","Molden","DB1 4FG",07/08/1982,"M","M"
4962,"Mr","Jason","Atkins","19 Westover Avenue","Molden","DB1 4FG",01/01/1990,"M","J"
5329,"Miss","Joan","Wilkins","25 Newton Street","Highcliffe","BD6 4DF",01/01/1991,"F","J"
5187,"Mr","Mike","Fellows","19 Hill Street","Ayton Village","DF5 2SH",31/12/1990,"M","J"
4295,"Mr","Howard","Everton","13 Beech Road","Wendhoven","DR3 3GH",13/07/1975,"M","M"
1214,"Mrs","Carolyn","Mills","41 Gatehouse Lane","Molden","DB1 5JF",27/06/1979,"F","L"
1829,"Mr","David","Hall","4 Bexhill Road","Wendhoven","DR3 6JK",15/07/1983,"M","M"
2262,"Mr","Malcolm","Adams","5 West Road","Molden","BD3 3FD",19/03/1991,"M","J"
3192,"Mr","Richard","Holmes","7 Grange Road","Highcliffe","BD6 9SD",01/01/1992,"M","J"
5608,"Mrs","Rosemary","North","15 Fairley Way","Ayton Village","DF1 5TF",05/04/1990,"F","L"
5271,"Mr","Grant","Yelton","17 Ferndale Road","Highcliffe","BD6 3CF",06/02/1983,"M","M"
6002,"Miss","Jennifer","St John","2 Church Road","Wendhoven","DR3 2HJ",28/07/1985,"F","L"
6943,"Miss","Kelly","Unwin","10 Main Street","Molden","BD3 4RT",01/01/1990,"F","J"
7291,"Mrs","Kathy","Beddoes","9 High Street","Wendhoven","DR3 7HG",19/06/1985,"F","L"
7895,"Mr","Colin","Wilson","9 Durham Road","Molden","BD3 2FD",20/07/1989,"M","M"
Copy and paste the following text in note pad and save it as Ice cream stock
"ProductID","ProductName","Category","MinLevel","MaxLevel","Re-orderLevel","UnitSize","Supplier","TradePrice","RetailPrice","VanAStock","VanBStock","VanCStock"
"FA01","Jumbo Truffle Milk","Adult Lines",2,48,24,24,"Fabrizio Bros",4.73,0.24,1,0,1
"FA02","Jumbo Truffle White","Adult Lines",2,48,24,24,"Fabrizio Bros",4.73,0.24,1,0,1
"FA03","Monster Choc Bar","Adult Lines",24,96,48,24,"Fabrizio Bros",4.73,0.24,1,0,1
"FA04","Crispy Mint","Adult Lines",2,48,24,24,"Fabrizio Bros",4.73,0.24,1,0,1
"FA05","Vanilla 1 litre","Take Home",3,8,4,4,"Fabrizio Bros",5.80,2.40,1,0,0
"FA06","Chocolate 1 litre","Take Home",3,8,4,4,"Fabrizio Bros",5.80,2.40,1,0,0
"FA07","Raspberry 1 litre","Take Home",3,8,4,4,"Fabrizio Bros",5.80,2.40,1,0,1
"FA08","Italian 1 litre toffee","Take Home",3,8,4,4,"Fabrizio Bros",5.80,2.40,1,0,0
"FA09","Italian 1 litre rum & raisin","Take Home",3,8,4,4,"Fabrizio Bros",5.80,2.40,1,0,0
"FA10","Chocolate Treats","Take Home",3,8,4,4,"Fabrizio Bros",7.43,2.34,1,0,1
"IC01","Heavenly Vanilla/Choc","Ice Cream Cones",20,40,20,20,"Ices 'R' Us",3.00,0.20,1,0,0
"IC02","Heavenly Choc 'n' Nut","Ice Cream Cones",6,32,6,6,"Ices 'R' Us",8.39,2.80,1,0,0
"IC03","Heavenly Strawberry","Ice Cream Cones",6,32,6,6,"Ices 'R' Us",8.39,2.80,1,0,0
"IC04","Nougat Ice","Ice Cream Snacks",2,48,24,24,"Ices 'R' Us",4.80,0.50,1,1,0
"IC05","Chocolate Treats","Ice Cream Snacks",2,48,24,24,"Ices 'R' Us",4.80,0.50,0,1,0
"IC06","Toffee Split","Ice Cream Snacks",2,48,24,24,"Ices 'R' Us",4.80,0.50,0,1,0
"IC07","Bubbly Mint","Ice Cream Snacks",2,48,24,24,"Ices 'R' Us",4.80,0.50,0,1,0
"IC08","Whirly Wafer","Ice Cream Snacks",2,64,32,32,"Ices 'R' Us",3.63,0.28,0,1,0
"RO01","Mint Miracle","Desserts",3,8,4,4,"Roberto & Sons",4.50,2.20,1,0,0
"RO02","Chunky Choc","Desserts",3,8,4,4,"Roberto & Sons",4.50,2.20,1,0,1
"RO03","Vanilla Treat","Desserts",3,8,4,4,"Roberto & Sons",7.04,2.74,1,0,0
"RO04","Toffee Treat","Desserts",3,8,4,4,"Roberto & Sons",7.04,2.74,1,0,0
"RO05","Mint Treat","Desserts",3,8,4,4,"Roberto & Sons",7.04,2.74,1,0,1
"RO06","Ice Surprise","Desserts",3,8,4,4,"Roberto & Sons",7.04,2.74,1,0,1
"SH01","Lemon Splice","Refreshment Lines",24,72,36,24,"Shelley & Co",4.94,0.32,0,1,0
"SH02","Orange Splice","Refreshment Lines",24,72,48,12,"Shelley & Co",4.94,0.62,0,1,0
"SH03","Orange Sizzler","Refreshment Lines",24,72,36,24,"Shelley & Co",9.44,0.67,0,1,1
"SH04","Purple Pops","Children's Lines",20,80,40,40,"Shelley & Co",8.00,0.36,1,1,0
"SH05","Ace","Children's Lines",24,96,48,24,"Shelley & Co",4.80,0.36,1,1,0
"SH06","Frosty","Children's Lines",24,70,35,35,"Shelley & Co",7.00,0.35,1,1,0
"SH07","Tootie Fruitie","Children's Lines",6,64,32,32,"Shelley & Co",6.40,0.56,1,1,0
"SH08","Super Cool","Children's Lines",6,64,32,32,"Shelley & Co",6.40,0.56,1,1,1
"SH09","Rocket","Children's Lines",12,72,36,12,"Shelley & Co",3.60,0.56,1,1,1
"SH10","Milk Lolly","Children's Lines",12,72,36,12,"Shelley & Co",3.60,0.56,1,1,1
"SH11","Fruit Lolly","Children's Lines",12,72,36,12,"Shelley & Co",3.60,0.56,1,1,1
"SH12","Pink Pig","Children's Lines",6,64,32,32,"Shelley & Co",9.53,0.76,1,1,1
"SH13","Blue Baboon","Children's Lines",20,80,40,40,"Shelley & Co",12.00,0.46,1,1,1
"SH14","UFO","Children's Lines",12,36,24,12,"Shelley & Co",3.80,0.58,1,1,0
"WA01","Chocolate Shell","Cones & Wafers",100,520,260,260,"Wardleys",4.00,0.05,1,1,1
"WA02","Duo Cones","Cones & Wafers",100,520,260,260,"Wardleys",9.62,0.10,1,0,1
"WA03","Vanilla tub","Ice Cream Snacks",2,36,12,24,"Wardleys",8.65,1.00,0,1,0
"WA04","Chocolate tub","Ice Cream Snacks",2,36,12,24,"Wardleys",8.65,1.00,0,1,0
"WA05","Cherry tub","Ice Cream Snacks",2,36,12,24,"Wardleys",8.65,1.00,0,1,1
"WA06","Toffee tub","Ice Cream Snacks",2,36,12,24,"Wardleys",8.65,1.00,0,1,0
"WA07","Italian 5 litre","Leisure Catering",2,14,8,4,"Wardleys",20.00,7.50,0,0,1
"WA08","Super Soft 5 litre","Leisure Catering",2,14,8,4,"Wardleys",20.00,7.50,0,0,1
"WA09","Vanilla 10 litre","Leisure Catering",2,6,4,1,"Wardleys",7.20,8.75,0,0,1
"WA10","Chocolate 10 litre","Leisure Catering",2,6,4,1,"Wardleys",7.20,8.75,0,0,1
"WA11","Packet Wafers (10 pack)","Cones & Wafers",24,96,48,48,"Wardleys",8.80,0.24,1,1,0
"WA12","Large Round Cones","Cones & Wafers",100,780,390,390,"Wardleys",8.83,0.04,1,0,1
Use the above .txt files to complete the follwing task :
Click on the images to enlarge the image .
No comments:
Post a Comment