Saturday, January 2, 2010
Wednesday, December 30, 2009
Monday, December 7, 2009
Saturday, November 28, 2009
Wednesday, November 25, 2009
Tuesday, November 24, 2009
Monday, November 23, 2009
Lesson 6: Data handling task : Workbook 2
Catering Text Box
Copy and paste the following text in note pad and save it as catering .
"Title","FirstName","LastName","ContractID","Address1","Address2","PostCode","TelNo","Event","Date","Time","Numbers","PricePerPerson","Paid","OptExtras","CostExtras"
"Miss","Joan","Baxendale","BU233","22 Bolton Road","Whitehall","ZK11 8RE","0161 444 67543","Buffet",12/12/2003,12:30:00,30,10.25,0,"D",3.5
"Mr","Simon","Holmes","BU355","89 Holden Road","Avondale","ZK1 7TY","0161 332 10298","Buffet",07/11/2003,13:30:00,25,12.55,0,"W",25
"Mr","Nazir","Washid","DO344","51 Ashton Avenue","Avondale","ZK12 9QW","0161 333 58493","Dinner",06/06/2004,21:00:00,8,15,1,"GT",20
"Mr","Bob","Forrest","LO334","77 Everton Road","Sett","ZK4 11DK","0161 441 67453","Lunch",20/12/2003,13:00:00,10,12.5,1,,
"Mrs","Jasmine","Patel","BU323","21 Peel Street","Duckworth","ZK6 5JK","0161 418 76543","Buffet",18/05/2003,22:00:00,33,10.25,0,"WT",30
"Mr","Lee","Tseng","LO336","7 Pole Lane","Sett","ZK4 2UY","0161 412 78965","Lunch",7/11/2003,13:30:00,18,10,1,"T",7
"Mr","Philip","Eaton","LO338","112 Sunnyhurst Road","Avondale","ZK1 6DH","0161 437 22775","Lunch",15/12/2003,13:00:00,16,10,1,,
"Miss","Iva","Buwczkowski","BU325","18A Peel Gardens","Duckworth","ZK5 9WQ","0161 402 77732","Buffet",10/03/2004,14:00:00,35,10.25,0,"WT",30
"Ms","Sylvia","Cullen","BI355","61 Fellbank","Moorside","ZK6 5JP","0161 425 98761","Birthday",06/06/2004,21:00:00,22,11.75,0,"GD",12
"Mr","Karl","Bourne","DO356","617 Lostock Towers","Daren","ZK2 5JP","0161 480 88873","Dinner",03/12/2003,19:30:00,8,15,1,,
"Mr","Cormac","McArdle","DO361","5 Haringey Road","Daren","ZK2 9JL","0161 427 55533","Dinner",06/08/2004,20:30:00,6,15,0,,
"Mrs","Kath","Roscoe","BI344","34 Robert Street","Hindle","ZK3 7PS","0161 437 11222","Birthday",11/09/2003,18:30:00,28,11.75,1,"GDT",19
"Mr","Chris","Walsh","BI345","77 Punstock Road","Whitehall","ZK11 3ER","0161 482 11448","Birthday",25/10/2003,15:30:00,12,12.75,1,"GD",20
"Ms","Pauline","Armstrong","BI348","5 Chester Avenue","Whitehall","ZK11 4QQ","0161 313 26543","Birthday",02/02/2004,15:30:00,10,12.75,1,"G",10
"Miss","Kerry","Jarvis","LO104","17 Old Barn Hill","Duckworth","ZK5 7HD","0161 487 22444","Lunch",16/12/2003,13:30:00,8,12.5,1,,
"Mr","Mark","Rhodes","BI218","31 Everton Street","Moorside","ZK6 7PT","0161 283 54677","Birthday",24/10/2004,19:00:00,28,6.75,0,"GD",12
"Mr","Cliff","Webb","BR113","33 Hindle Street","Sett","ZK4 8PQ","0161 402 12222","Brunch",18/12/2003,10:30:00,30,9.8,1,"T",7
"Mrs","Rita","Takang","BI219","11 Harwood Street","Hindle","ZK3 7HG","0161 403 32111","Birthday",23/08/2004,18:30:00,24,6.75,0,"GD",12
"Miss","Tracy","Burton","AO127","66 Crown Way","Sett","ZK4 8HG","0161 403 87111","Anniversary",17/07/2004,19:00:00,6,12.75,0,"D",5
"Mrs","Diane","Rutter","BR112","86 Gillbank Place","Hindle","ZK3 9TY","0161 483 31233","Brunch",09/02/2004,10:30:00,30,9.8,1,"T",7
"Miss","Vici","Lorenzo","LO103","22 Curzon Green","Hindle","ZK3 5PQ","0161 483 88991","Lunch",12/01/2004,13:30:00,10,12.50,1,,
"Mrs","Kerris","Forrester","BI215","10 Sundial Lane","Duckworth","ZK5 1YU","0161 422 99887","Birthday",29/06/2004,12:30:00,20,6.75,0,"GD",12
"Mr","Barry","Wardley","BU372","5 Borough Road","Garden Village","ZK6 7RT","0161 283 22334","Buffet",29/11/2003,18:00:00,50,10.25,1,"TW",27
"Mr","John","Stubbs","BU371","14 Rostrevor Avenue","Daren","ZK2 5PS","0161 227 91501","Buffet",15/07/2004,13:00:00,44,10.25,0,"WT",30
"Mr","Alan","Chapman","DO213","42 Westwood Road","Whitehall","ZK1 8GH","0161 423 55446","Dinner",14/02/2004,20:00:00,10,15,1,"D",5
"Ms","Lisa","Jones","BI216","6 Chestnut Avenue","Sett","ZK4 6TH","0161 221 44775","Birthday",06/06/2004,14:30:00,22,6.75,0,"GD",12
"Ms","Marilyn","Gray","DO215","6 Kestrel Close","Daren","ZK2 7RO","0161 992 48561","Dinner",24/06/2004,20:30:00,6,15,0,"D",5
"Miss","Nerys","Ruddock","LO102","54 Collingtree Avenue","Duckworth","ZK5 8UY","0161 222 89731","Lunch",04/03/2004,14:00:00,14,10,1,"T",7
"Mr","Alexander","Church","LO106","6 Selkirk Drive","Garden Village","ZK8 7FC","0161 480 77114","Lunch",16/04/2004,13:00:00,12,10,0,,
"Mr","Alan","Singleton","BU373","92 Queensway","Moorside","ZK6 4RT","0161 483 22991","Buffet",06/02/2004,15:00:00,20,10.25,1,"T",7
"Mrs","Joan","Stubbs","LO110","4 The Fairway","Hindle","ZK3 5PS","0161 227 91501","Lunch",16/05/2004,13:30:00,12,10,0,,
"Miss","Reni","Nyurat","AO124","187 Burton Road","Sett","ZK4 8BN","0161 222 11568","Anniversary",02/09/2004,19:30:00,6,12.75,0,"D",5
"Mr","Gordon","Maxfield","BI217","68 Buxton Road","Sett","ZK4 1PS","0161 852 92388","Birthday",09/11/2004,16:00:00,20,11.75,0,"GD",12
"Mr","James","Lisle-Duncan","BU369","30 Highfield Drive","Duckworth","ZK5 8LL","0161 982 49787","Buffet",07/05/2004,14:00:00,40,10.25,0,"WT",30
"Mr","Walter","Evans","BR101","89 Railway Road","Garden Village","ZK8 9UY","0161 283 33441","Brunch",22/05/2004,11:00:00,33,9.8,0,"WT",30
"Mr","Damien","Hadcroft","LO105","108 Riddings Road","Duckworth","ZK5 6TJ","0161 159 71004","Lunch",11/09/2004,12:30:00,16,12.5,0,"T",7
"Mrs","Alison","Rokeby","AO123","18 Cheviot Street","Daren","ZK2 7DW","0161 987 44423","Anniversary",12/10/2004,20:30:00,10,12.75,0,"D",5
"Mrs","Bernice","Altoft","DO212","7 Church Street","Hindle","ZK3 7PS","0161 921 75542","Dinner",03/02/2004,20:00:00,8,15,1,,
"Mr","Leonard","Park","DO220","263 Branson Street","Hindle","ZK3 3MN","0161 280 66773","Dinner",30/03/2004,20:30:00,4,15,1,,
"Mr","Michael","Fletcher","AO126","8 Manor Towers","Sunnyhurst","ZK7 5SP","0161 576 24917","Anniversary",08/08/2004,20:00:00,4,12.75,0,"D",5
"Mr","Kurt","Van Ryan","AO129","33 Burnside Drive","Daren","ZK2 3WE","0161 224 88776","Anniversary",11/01/2004,19:30:00,8,12.75,1,"D",5
"Mr","James","Duttine","BI212","12 Peabody Street","Duckworth","ZK5 7BV","0161 287 99227","Birthday",30/04/2004,14:30:00,18,6.75,0,"GD",12
"Mr","Kieran","O'Hare","BR111","3 Hazeldine Crescent","Garden Village","ZK8 5QQ","0161 748 92333","Brunch",28/01/2004,11:00:00,18,9.8,1,,
"Miss","Petra","Summers","BI301","36A Mallory Crescent","Sunnyhurst","ZK7 4LK","0161 159 76324","Birthday",05/01/2004,20:00:00,22,6.75,1,"D",5
"Ms","Claudia","Brooke","BI211","7 The Oval","Garden Village","ZK8 6JS","0161 921 84985","Birthday",02/06/2004,14:00:00,20,6.75,0,"GD",12
"Mrs","Jean","Walsh","DO225","99 Marsland Road","Garden Village","ZK8 4SC","0161 921 55867","Dinner",10/01/2004,20:30:00,10,15,1,"T",7
"Miss","Susan","Chapman","BU366","54 Westway","Sett","ZK4 8GH","0161 423 55446","Buffet",21/03/2004,19:00:00,25,10.25,1,"TW",24
"Mrs","Patricia","Jarvis","BR110","71 Sundial Road","Sunnyhurst","ZK7 7HD","0161 487 22444","Brunch",10/07/2004,10:30:00,12,9.8,0,,
Copy and paste the following text in note pad and save it as catering .
"Title","FirstName","LastName","ContractID","Address1","Address2","PostCode","TelNo","Event","Date","Time","Numbers","PricePerPerson","Paid","OptExtras","CostExtras"
"Miss","Joan","Baxendale","BU233","22 Bolton Road","Whitehall","ZK11 8RE","0161 444 67543","Buffet",12/12/2003,12:30:00,30,10.25,0,"D",3.5
"Mr","Simon","Holmes","BU355","89 Holden Road","Avondale","ZK1 7TY","0161 332 10298","Buffet",07/11/2003,13:30:00,25,12.55,0,"W",25
"Mr","Nazir","Washid","DO344","51 Ashton Avenue","Avondale","ZK12 9QW","0161 333 58493","Dinner",06/06/2004,21:00:00,8,15,1,"GT",20
"Mr","Bob","Forrest","LO334","77 Everton Road","Sett","ZK4 11DK","0161 441 67453","Lunch",20/12/2003,13:00:00,10,12.5,1,,
"Mrs","Jasmine","Patel","BU323","21 Peel Street","Duckworth","ZK6 5JK","0161 418 76543","Buffet",18/05/2003,22:00:00,33,10.25,0,"WT",30
"Mr","Lee","Tseng","LO336","7 Pole Lane","Sett","ZK4 2UY","0161 412 78965","Lunch",7/11/2003,13:30:00,18,10,1,"T",7
"Mr","Philip","Eaton","LO338","112 Sunnyhurst Road","Avondale","ZK1 6DH","0161 437 22775","Lunch",15/12/2003,13:00:00,16,10,1,,
"Miss","Iva","Buwczkowski","BU325","18A Peel Gardens","Duckworth","ZK5 9WQ","0161 402 77732","Buffet",10/03/2004,14:00:00,35,10.25,0,"WT",30
"Ms","Sylvia","Cullen","BI355","61 Fellbank","Moorside","ZK6 5JP","0161 425 98761","Birthday",06/06/2004,21:00:00,22,11.75,0,"GD",12
"Mr","Karl","Bourne","DO356","617 Lostock Towers","Daren","ZK2 5JP","0161 480 88873","Dinner",03/12/2003,19:30:00,8,15,1,,
"Mr","Cormac","McArdle","DO361","5 Haringey Road","Daren","ZK2 9JL","0161 427 55533","Dinner",06/08/2004,20:30:00,6,15,0,,
"Mrs","Kath","Roscoe","BI344","34 Robert Street","Hindle","ZK3 7PS","0161 437 11222","Birthday",11/09/2003,18:30:00,28,11.75,1,"GDT",19
"Mr","Chris","Walsh","BI345","77 Punstock Road","Whitehall","ZK11 3ER","0161 482 11448","Birthday",25/10/2003,15:30:00,12,12.75,1,"GD",20
"Ms","Pauline","Armstrong","BI348","5 Chester Avenue","Whitehall","ZK11 4QQ","0161 313 26543","Birthday",02/02/2004,15:30:00,10,12.75,1,"G",10
"Miss","Kerry","Jarvis","LO104","17 Old Barn Hill","Duckworth","ZK5 7HD","0161 487 22444","Lunch",16/12/2003,13:30:00,8,12.5,1,,
"Mr","Mark","Rhodes","BI218","31 Everton Street","Moorside","ZK6 7PT","0161 283 54677","Birthday",24/10/2004,19:00:00,28,6.75,0,"GD",12
"Mr","Cliff","Webb","BR113","33 Hindle Street","Sett","ZK4 8PQ","0161 402 12222","Brunch",18/12/2003,10:30:00,30,9.8,1,"T",7
"Mrs","Rita","Takang","BI219","11 Harwood Street","Hindle","ZK3 7HG","0161 403 32111","Birthday",23/08/2004,18:30:00,24,6.75,0,"GD",12
"Miss","Tracy","Burton","AO127","66 Crown Way","Sett","ZK4 8HG","0161 403 87111","Anniversary",17/07/2004,19:00:00,6,12.75,0,"D",5
"Mrs","Diane","Rutter","BR112","86 Gillbank Place","Hindle","ZK3 9TY","0161 483 31233","Brunch",09/02/2004,10:30:00,30,9.8,1,"T",7
"Miss","Vici","Lorenzo","LO103","22 Curzon Green","Hindle","ZK3 5PQ","0161 483 88991","Lunch",12/01/2004,13:30:00,10,12.50,1,,
"Mrs","Kerris","Forrester","BI215","10 Sundial Lane","Duckworth","ZK5 1YU","0161 422 99887","Birthday",29/06/2004,12:30:00,20,6.75,0,"GD",12
"Mr","Barry","Wardley","BU372","5 Borough Road","Garden Village","ZK6 7RT","0161 283 22334","Buffet",29/11/2003,18:00:00,50,10.25,1,"TW",27
"Mr","John","Stubbs","BU371","14 Rostrevor Avenue","Daren","ZK2 5PS","0161 227 91501","Buffet",15/07/2004,13:00:00,44,10.25,0,"WT",30
"Mr","Alan","Chapman","DO213","42 Westwood Road","Whitehall","ZK1 8GH","0161 423 55446","Dinner",14/02/2004,20:00:00,10,15,1,"D",5
"Ms","Lisa","Jones","BI216","6 Chestnut Avenue","Sett","ZK4 6TH","0161 221 44775","Birthday",06/06/2004,14:30:00,22,6.75,0,"GD",12
"Ms","Marilyn","Gray","DO215","6 Kestrel Close","Daren","ZK2 7RO","0161 992 48561","Dinner",24/06/2004,20:30:00,6,15,0,"D",5
"Miss","Nerys","Ruddock","LO102","54 Collingtree Avenue","Duckworth","ZK5 8UY","0161 222 89731","Lunch",04/03/2004,14:00:00,14,10,1,"T",7
"Mr","Alexander","Church","LO106","6 Selkirk Drive","Garden Village","ZK8 7FC","0161 480 77114","Lunch",16/04/2004,13:00:00,12,10,0,,
"Mr","Alan","Singleton","BU373","92 Queensway","Moorside","ZK6 4RT","0161 483 22991","Buffet",06/02/2004,15:00:00,20,10.25,1,"T",7
"Mrs","Joan","Stubbs","LO110","4 The Fairway","Hindle","ZK3 5PS","0161 227 91501","Lunch",16/05/2004,13:30:00,12,10,0,,
"Miss","Reni","Nyurat","AO124","187 Burton Road","Sett","ZK4 8BN","0161 222 11568","Anniversary",02/09/2004,19:30:00,6,12.75,0,"D",5
"Mr","Gordon","Maxfield","BI217","68 Buxton Road","Sett","ZK4 1PS","0161 852 92388","Birthday",09/11/2004,16:00:00,20,11.75,0,"GD",12
"Mr","James","Lisle-Duncan","BU369","30 Highfield Drive","Duckworth","ZK5 8LL","0161 982 49787","Buffet",07/05/2004,14:00:00,40,10.25,0,"WT",30
"Mr","Walter","Evans","BR101","89 Railway Road","Garden Village","ZK8 9UY","0161 283 33441","Brunch",22/05/2004,11:00:00,33,9.8,0,"WT",30
"Mr","Damien","Hadcroft","LO105","108 Riddings Road","Duckworth","ZK5 6TJ","0161 159 71004","Lunch",11/09/2004,12:30:00,16,12.5,0,"T",7
"Mrs","Alison","Rokeby","AO123","18 Cheviot Street","Daren","ZK2 7DW","0161 987 44423","Anniversary",12/10/2004,20:30:00,10,12.75,0,"D",5
"Mrs","Bernice","Altoft","DO212","7 Church Street","Hindle","ZK3 7PS","0161 921 75542","Dinner",03/02/2004,20:00:00,8,15,1,,
"Mr","Leonard","Park","DO220","263 Branson Street","Hindle","ZK3 3MN","0161 280 66773","Dinner",30/03/2004,20:30:00,4,15,1,,
"Mr","Michael","Fletcher","AO126","8 Manor Towers","Sunnyhurst","ZK7 5SP","0161 576 24917","Anniversary",08/08/2004,20:00:00,4,12.75,0,"D",5
"Mr","Kurt","Van Ryan","AO129","33 Burnside Drive","Daren","ZK2 3WE","0161 224 88776","Anniversary",11/01/2004,19:30:00,8,12.75,1,"D",5
"Mr","James","Duttine","BI212","12 Peabody Street","Duckworth","ZK5 7BV","0161 287 99227","Birthday",30/04/2004,14:30:00,18,6.75,0,"GD",12
"Mr","Kieran","O'Hare","BR111","3 Hazeldine Crescent","Garden Village","ZK8 5QQ","0161 748 92333","Brunch",28/01/2004,11:00:00,18,9.8,1,,
"Miss","Petra","Summers","BI301","36A Mallory Crescent","Sunnyhurst","ZK7 4LK","0161 159 76324","Birthday",05/01/2004,20:00:00,22,6.75,1,"D",5
"Ms","Claudia","Brooke","BI211","7 The Oval","Garden Village","ZK8 6JS","0161 921 84985","Birthday",02/06/2004,14:00:00,20,6.75,0,"GD",12
"Mrs","Jean","Walsh","DO225","99 Marsland Road","Garden Village","ZK8 4SC","0161 921 55867","Dinner",10/01/2004,20:30:00,10,15,1,"T",7
"Miss","Susan","Chapman","BU366","54 Westway","Sett","ZK4 8GH","0161 423 55446","Buffet",21/03/2004,19:00:00,25,10.25,1,"TW",24
"Mrs","Patricia","Jarvis","BR110","71 Sundial Road","Sunnyhurst","ZK7 7HD","0161 487 22444","Brunch",10/07/2004,10:30:00,12,9.8,0,,
Sunday, November 22, 2009
Lesson 5: Data handling task : Workbook 1
Data Handling Task : Work Book 1
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 .
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 .
Lesson 4 : Car Database
CAR DATABASE QUESTIONS
Create the Car Database as shown below
Design View
Use the car database to find the answers to the following questions
Use the table design view to find the following information
1 Which field is the primary key?
2 Which field has the data type ‘number’?
3 Which field has the data type ‘currency’?
4 Which field will only allow you to put yes/no into?
5 Which field will only allow 8 characters to be typed?
Use the table view to find the following information
6 How many records are in the database?
7 Sort the database on ‘price’ in ascending order. Which is the cheapest car?
8 Sort the database on ‘price’ in descending order. Which make would be the most expensive car?
9 Sort the database on ‘year’ in ascending order. Which is the oldest car?
10 Sort the database on ‘Make’ in descending order. Which make would be displayed first?
Create a query to answer the following questions
11 How many ‘Ford’ cars are in the database?
12 How many ‘Ford Ka’ are in the database?
13 How many different ‘Rover’ models are in the database?
14 How many cars were registered in 1999?
15 How many cars do NOT have tax?
16 How many cars cost less than £1000?
17 How many cars cost more than £4000?
18 How many cars cost less than £2000 AND do not have tax?
19 How many Red cars are there?
20 How many Vauxhall cars are White
21 How many Red cars cost more than £5000?
22 How many Silver cars were there in 1999?
23 What colour is the Renault Clio 2002?
24 What is the make of two cars that are Black and built in 1997?
25 How many cars are there between 2000 and 2003?
26 How many cars for 1999 are there which are NOT red?
27 How many cars are there in 1996 which are NOT silver and NOT a 406?
Create the Car Database as shown below
Design View
Car Records
Use the car database to find the answers to the following questions
Use the table design view to find the following information
1 Which field is the primary key?
2 Which field has the data type ‘number’?
3 Which field has the data type ‘currency’?
4 Which field will only allow you to put yes/no into?
5 Which field will only allow 8 characters to be typed?
Use the table view to find the following information
6 How many records are in the database?
7 Sort the database on ‘price’ in ascending order. Which is the cheapest car?
8 Sort the database on ‘price’ in descending order. Which make would be the most expensive car?
9 Sort the database on ‘year’ in ascending order. Which is the oldest car?
10 Sort the database on ‘Make’ in descending order. Which make would be displayed first?
Create a query to answer the following questions
11 How many ‘Ford’ cars are in the database?
12 How many ‘Ford Ka’ are in the database?
13 How many different ‘Rover’ models are in the database?
14 How many cars were registered in 1999?
15 How many cars do NOT have tax?
16 How many cars cost less than £1000?
17 How many cars cost more than £4000?
18 How many cars cost less than £2000 AND do not have tax?
19 How many Red cars are there?
20 How many Vauxhall cars are White
21 How many Red cars cost more than £5000?
22 How many Silver cars were there in 1999?
23 What colour is the Renault Clio 2002?
24 What is the make of two cars that are Black and built in 1997?
25 How many cars are there between 2000 and 2003?
26 How many cars for 1999 are there which are NOT red?
27 How many cars are there in 1996 which are NOT silver and NOT a 406?
Subscribe to:
Posts (Atom)