Access Assignment Winter 2011_BenLevesque_AntoineTardif

Access Assignment Winter 2011_BenLevesque_AntoineTardif -...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Benoit Levesque(260383938) and Antoine Tardif, Monday Nights with Charles Quesnel PART A PART B Step 2 Countries Country Code Country Name Country Dial Code 1Canada 1 2United States 1 3United Kingdom 44 Countries Country Code Country Name Country Dial Code 4France 33 5Germany 49 Time Of day ID Time of Day Time of Day Description 1D Day Time 8:00 to 19:00 2E Evening 0:00 to 8:00 and 19:00 to 24:00 3H Holiday 4W Weekend Step 4 UPDATE Countries INNER JOIN [Area codes] ON Countries.[Country Code] = [Area codes]. [Country Code] SET [Area codes].[Area Code Name] = [Countries]![Country Name]; Step 6 UPDATE [Telephone Calls] SET [Telephone Calls].[Time of Day] = IIf([Telephone Calls]![Call Date]=#12/25/2010# Or [Telephone Calls]![Call Date]=#1/1/2011#,"H",IIf(Weekday([Telephone Calls]![Call Date])=7,"W",IIf([Telephone Calls]![Time of Call]>TimeValue(#12/30/1899#) And [Telephone Calls]![Time of Call]<TimeValue(#12/30/1899 19:0:0#),"D","E"))); Step 8 STEP 9 Copy Of Step9_Query1 Call ID Last Name Plan Description Dialled Number Time of Day Country Name Call Duration Area Code Number Phone Number Phone Type Call Date Call Cost Discount/Premiu m Net Cost 5Swift Regular Calling 450 501-7948 W Nova Scotia 47.80 450726-9231 B 22/01/2011 $2.05 0.82 $1.23 41Graves Unlimited Calling 49 9254-2535 E Germany 54.17 49556-5055 O 14/02/2011 $5.47 0$5.47 42Hopewell Low Volume Calling 44 6755-3378 D United Kingdom 16.50 44308-3037 F 31/12/2010 $1.42 0$1.42 46Swift Regular Calling 450 830-8977 D Nova Scotia 12.33 450726-9231 B 30/11/2010 $0.53 0$0.53 53Tardif Unlimited Calling 33 7578-1781 D France 3.00 33892-7853 F 05/01/2011 $0.26 0$0.26 59Claus Regular Calling 49 2042-7882 E Germany 52.20 49659-4152 H 18/01/2011 $5.27 1.581 $3.69 64Hopewell Low Volume Calling 418 907-6060 H Nova Scotia 111.05 418984-5716 H 25/12/2010 $2.71 0$2.71 77Levesque Regular Calling 888 734-1274 W Nova Scotia 18.43 888200-5571 C 22/01/2011 $0.00 0$0.00 86Rabbit Regular Calling 49 8012-5592 H Germany 144.93 49728-2435 H 25/12/2010 $14.6425/12/2010 $14....
View Full Document

Page1 / 7

Access Assignment Winter 2011_BenLevesque_AntoineTardif -...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online