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,,
Workbook 2
Use the catering text box to complete the following.


"Mr","Reginald","Rutter","DO223","55 Hope Street","Hindle","ZK3 9TY","0161 483 31233","Dinner",10/04/2004,21:00:00,6,15,1,,

"Mr","David","Jones","DO217","18 Turton Road","Duckworth","ZK5 6TH","0161 221 44775","Dinner",19/02/2004,20:00:00,4,15,1,,

Complete the following task :

















No comments:

Post a Comment