Hello Kattie, please see the attachments and let me know if you need anything else. Thank you so much!

 

Customer NameContact IDContact PositionContact PhoneCompany AddressCityStateZIPTerritoryActive?1001 Segal Inc.100 HarrySegalVice President(603) 555-0987 #11 - Hwy 16NashuaNH030602YesC09BocelliCarlos(603) 522-6487389/20/20011001 Segal Inc.200 Mary AnnWatersCFO(603) 555-0988 #11 - Hwy 16NashuaNH030602YesC09BocelliCarlos(603) 522-6487389/20/20011002 Fair Weather Enterprises335 KarenHarper-WillisMarketing Manager(617) 354-1234 345 Wiltshire AvenueCambridgeMA021391YesA02DukeArthur(617) 336-5547406/25/20021002 Fair Weather Enterprises336 MarkStevensonCEO(617) 354-1235 345 Wiltshire AvenueCambridgeMA021391YesA02DukeArthur(617) 336-5547406/25/20021002 Fair Weather Enterprises337 BenjaminYangCFO(617) 354-1236 345 Wiltshire AvenueCambridgeMA021391YesA02DukeArthur(617) 336-5547406/25/20021003 Halston & Co.600 DianneLorenzoCEO(631) 757-3344 387 Roper PlaceNorthportNY117685YesB02BoseSally(207) 422-7411384/10/20001004 MMB Holdings125 PabloDiazCEO(703) 222-5678 4090 Lethbridge StreetViennaVA330677YesB05van der HamLawrence(202) 844-603335.56/30/20011004 MMB Holdings126 NaomiMiradaCFO(703) 222-5679 4090 Lethbridge StreetViennaVA330677YesB05van der HamLawrence(202) 844-6033356/30/20011005 Ward Co.900 JimShelbyCOO(617) 344-6677 35-9087 14th StreetBostonMA021151YesA02DukeArthur(617) 336-5547406/25/20021006 Bakertime Mobile850 TomDiBonoVice President(201) 455-8765 759 East 31 AveTrentonNJ078825YesB02BoseSally(207) 422-7411384/10/20001006 Bakertime Mobile851 RuthSchroederCEO(201) 455-8766 759 East 31 AveTrentonNJ078825YesB02BoseSally(207) 422-7411384/10/20001007 Classic Accents1200 DaveBurleyCEO(781) 566-2233 324 Main StreetBurlingtonMA018031YesA02DukeArthur(617) 336-5547406/25/20021007 Classic Accents1201 ConnieBurleyVice President(781) 566-2234 324 Main StreetBurlingtonMA018031YesA02DukeArthur(617) 336-5547406/25/20021007 Classic Accents1202 TeresaPerryMarketing Manager(781) 566-2235 324 Main StreetBurlingtonMA018031YesA02DukeArthur(617) 336-5547406/25/20021008 Summit Supply1500 GaryGiovanettiCFO(304) 555-6677 Ridgeway ConnectorStoney BluffWV356667NoB05van der HamLawrence(202) 844-6033356/30/20011008 Summit Supply1501 JohnKimCEO(304) 555-6678 Ridgeway ConnectorStoney BluffWV356667NoB05van der HamLawrence(202) 844-6033356/30/20011009 Harper & Ronick1700 LeePanettiCEO(206) 333-4455 288 Landsdowne DriveNicolaCT234453YesA14FinkPeter(860) 545-98233010/25/19991010 Professional Supply250 AnnZankoskiMarketing Manager(207) 354-0099 7241 South DriveThomastonME047784YesC02BonhamEarl(802) 455-9070382/15/20001010 Professional Supply251 BobZankoskiVice President(207) 354-0100 7241 South DriveThomastonME047784YesC02BonhamEarl(802) 455-9070382/15/20001010 Professional Supply252 AaronZankoskiCFO(207) 354-0101 7241 South DriveThomastonME047784YesC02BonhamEarl(802) 455-9070382/15/20001011 Silver Cloud2100 MariaShimanoPresident & CEO(704) 566-7889 111 Rand AvenueBaltimoreMD227776YesA05Louis-HawkinsBrenda(212) 224-3322357/15/19991012 Ryssell Bros.490 MaxineGarrisonMarketing Manager(802) 455-1122 1255 Vollrath StSouth GlennVT456684YesC02BonhamEarl(802) 455-9070382/15/20001012 Ryssell Bros.487 RachelPappasVice President(802) 455-1123 1255 Vollrath StSouth GlennVT456684YesC02BonhamEarl(802) 455-907038.52/15/20001012 Ryssell Bros.444 JonathanReuscheCEO(802) 455-1124 1255 Vollrath StSouth GlennVT456684YesC02BonhamEarl(802) 455-9070382/15/20001013 Omega Distributions2500 PaulTomazewskiPresident & CEO(305) 455-6778 32 Merrit AveOrlandoFL356678NoC11MastersonJanet(703) 342-43924011/30/19981013 Omega Distributions2505 DavidTonelliCFO(305) 455-6779 32 Merrit AveOrlandoFL356678NoC11MastersonJanet(703) 342-43924011/30/19981014 J&J Ltd.1780 PattyGlicoMarketing Manager(603) 233-0099 675 Cinnamon Ridge RoadManchesterNH031012YesC09BocelliCarlos(603) 522-6487389/20/20011015 Dalhousie Inc.2800 JackieSoupePresident & CEO(203) 456-7790 2233 Southgate AvenueSouthgateCT235553YesA14FinkPeter(860) 545-98233010/25/19991016 Larkspur Corp.950 JasonMonteCFO(201) 233-4567 4949 Douglas RoadPrincetonNJ122345YesB02BoseSally(207) 422-7411384/10/20001017 Pro-Dist Co.331 GaryTwomeyVice President(805) 999-1090 1121 Lorne DriveMontroseNC467778NoC11MastersonJanet(703) 342-43924011/30/19981017 Pro-Dist Co.332 BrianRossCEO(805) 999-1091 1121 Lorne DriveMontroseNC467778NoC11MastersonJanet(703) 342-43924011/30/19981017 Pro-Dist Co.333 MichaelJacksonCFO(805) 999-1092 1121 Lorne DriveMontroseNC467778NoC11MastersonJanet(703) 342-43924011/30/19981018 De Palma Supply2750 TimothyWarrenPresident(806) 333-4556 988 Laval CrescentPembertonSC534888YesC11MastersonJanet(703) 342-43924011/30/19981019 Cameron-Best3400 HarrietBillingsleyCFO(703) 233-5876 429 Mt Ida DriveEast GardomVA330687YesB05van der HamLawrence(202) 844-6033356/30/20011020 MPM Inc.1510 MarvinGardensPresident & CEO(508) 433-6543 3535 Bank RoadGardnerMA014401YesA02DukeArthur(617) 336-5547406/25/2002CustomerIDContact FirstNameContact LastNameSalesRep IDSales Rep LastNameSales RepFirst NameSales RepPhoneSales RepHoursSales RepDate Hired

Assignment for Week 61. Review chapters 8, 9, & 10 of the textbook.2. Do Final Database Project Assignment #3. Due by midnight Eastern Standard Time on SundayFebruary 28, 2016.This is the third of the 8 individual assignments that you'll be doing to create your owndatabase.In this assignment, you're going to make sure your relationships are set correctly so that theinformation in the Subdatasheets is displayed as desired. In addition, you will deFneproperties for the Felds in the tables and you will create some Value Lists to facilitate thedata-entry process.Here are the speciFcs of the assignment:1.All data MUST be fully displayed.2.Make sure your relationships are set correctly, so that when you click the plus sign tothe left of a record in a table you are able to see the desired data in theSubdatasheet. Iwould like to see the following datasheet/subdatasheet combinations of information:The contacts for the di±erent customers in the tblCustomers table. When you clickthe plus sign next to a customer, you should be able to view the contacts for that customer.The customers for each sales rep and the contacts for the displayed customer.The orders that have been placed for the di±erent products.The territories with the customers and contacts for each of the territories.3.DeFne the following Properties:Assign Input Masks for allPhoneFelds.DeFne all Zip Code Felds to ensure that they all are displayed with Fve digits.TheStateFeld data should automatically appear in uppercase.A maximum of 40 hours should be allowed in the Hours Feld for sales reps. If the end-user enters a value that is greater than 40, the following message should be displayed:The number of hours must not exceed 40.A required Sales Rep ID in the Customers table.Dates entered into theHire DateFeld must be today's date or earlier. If the userenters an invalid date, and Alert Box should display an appropriate message.TheActiveYes/No Feld in tblCustomers should default toYes.The Discount values (for the products) should be formatted to display with percentsymbols and 2 decimal places.Only values from 1 to 8 should be accepted in the Territory Code Feld. If a valueoutside this range is entered, an Alert Box should be displayed with an appropriate messageto the user.4.Create the following Value Lists to facilitate the data-entry process:Territories

Attachments:

• 1496723732-wk6assignment.docx
• 1496723732-Final Project Data_20101.xlsx