Data base and queryCustomer CustomerID FirstName LastName StreetAddress City PostalCode Phone...

Question

Data base and queryCustomer 	CustomerID	FirstName	LastName	StreetAddress	City	PostalCode	Phone 	10000	Melody	Warde	60 DRUMMOND Avenue	Red Deer	T4N 1L8	4035556775 	10001	King	Osmond	15-73 ADDINGTON Drive	Red Deer	T4N 2G3	4035556502 	10002	Vassili	Bourdice	301-5925 63 Street	Red Deer	T4N 0B3	4035557393 	10003	Jo	Sweetmore	6114 51 Avenue	Red Deer	T4N 1L6	4035559532 	10004	Carlotta	Sleeny	95 LIVINGSTON Close	Red Deer	T4N 1W7	4035557128 	10005	Jeanna	Cattell	4040 78 Street Crescent	Red Deer	T4N 0I2	4035556714 	10006	Jemmie	Laister	2-5541 45 Avenue	Lacombe	T4N 2E6	4035557978 	10007	Addia	Westphalen	3609 51 Avenue	Lacombe	T4N 1X3	4035555185 	10008	Myrtice	Heaseman	599-100 JORDAN Parkway	Red Deer	T4N 2S6	4035559257 	10009	Gilberte	Brasted	30 GROVE Close	Red Deer	T4N 1K6	4035555719 	10010	Myrta	Attwood	215 JENKINS Drive	Red Deer	T4N 1O3	4035558402 	10011	Theo	Srutton	5614 58A Avenue	Red Deer	T4N 2S9	4035559447 	10012	Aubert	Gregine	P8-6 MICHENER Boulevard P	Red Deer	T4N 0S5	4035555448 	10013	Cherri	Hail	15 HALMAN Crescent	Red Deer	T4N 1U5	4035558910 	10014	Essy	Vaughan	8 FAIRWAY Avenue	Lacombe	T4N 0C2	4035559262 	10015	Darren	Penwright	41-33 DONLEVY Avenue	Red Deer	T4N 0K8	4035556294 	10016	Lew	Crutcher	25 GAIR Close	Red Deer	T4N 0G2	4035555806 	10017	Jamima	Noah	44 SISSON Avenue	Red Deer	T4N 1E5	4035555706 	10018	Bertina	Ajsik	1000-5001 19 Street	Red Deer	T4N 1R4	4035557705 	10019	Orland	Rikard	95 NORDEGG Crescent	Red Deer	T4N 1Q7	4035559211 	10020	Daloris	Alway	3813 59 Avenue Crescent	Red Deer	T4N 2B1	4035557884 	10021	Flin	Marflitt	651-6940 63 Avenue	Red Deer	T4N 1X4	4035557559 	10022	Leupold	Mitchley	113-6 DAYKIN Street	Red Deer	T4N 1Q1	4035555720 	10023	Misha	Garz	127 TIMBERSTONE Way	Red Deer	T4N 1M4	4035559412 	10024	Ysabel	Panter	26 NASH Street	Lacombe	T4N 0Z6	4035556507 	10025	Fulton	Benterman	3924 46 Street	Red Deer	T4N 1Y5	4035558315 	10026	Mead	Brodeau	42 EARL Close	Red Deer	T4N 1U8	4035557260 	10027	Hebert	Gellier	119-54 BELL Street	Red Deer	T4N 1A4	4035557126 	10028	Ario	Vreede	2-3502 49 Avenue	Red Deer	T4N 0N9	4035555333 	10029	Joly	Heiton	52 ISAACSON Crescent	Red Deer	T4N 2L6	4035558129 	10030	Vincenty	Killcross	308-6 STANTON Street	Red Deer	T4N 0A5 	10031	Javier	Widmore	306-19 BENNETT Street	Sylvan Lake	T4N 0H1	4035556949 	10032	Allard	Tortice	29 DURAND Crescent	Red Deer	T4N 1M4	4035559442 	10033	Othella	Sloyan	5937 68 Street Close	Red Deer	T4N 2Z5	4035558157 	10034	Joelie	Buse	75 MCLEVIN Crescent	Red Deer	T4N 2R7	4035559767 	10035	Winna	Joe	4526 47 Street	Red Deer	T4N 1T2	4035559753 	10036	Kristen	Langtree	7-6540 71 Street	Lacombe	T4N 1X1	4035557439 	10037	Gertie	D'Enrico	17 HUGET Crescent	Red Deer	T4N 2U8	4035559060 	10038	Diannne	Loughlin	27048 TWP Road	Red Deer	T4N 0M2	4035557079 	10039	Winifield	Aaronsohn	35 GOODALL Avenue	Red Deer	T4N 0J8	4035558372 	10040	Matilde	Collins	84 CRAWFORD Street	Red Deer	T4N 0V7	4035558229 	10041	Jania	Revie	301-4733 54 Street	Sylvan Lake	T4N 1J2	4035558042 	10042	Burlie	Catlin	67 DORAN Crescent	Red Deer	T4N 2D7	4035558743 	10043	Mel	McKeand	12-7471 EDGAR INDUSTRIAL Bend	Red Deer	T4N 1G1	4035556375 	10044	Salaidh	Echlin	15 CHURCHILL Close	Red Deer	T4N 2B6	4035558877 	10045	Kendall	McEvay	306 TERRACE Park	Sylvan Lake	T4N 2H2	4035555611 	10046	Griffin	Kempton	3915 38 Avenue	Red Deer	T4N 1Q2	4035558073 	10047	Reade	Perazzo	32-45 IRONSTONE Drive	Sylvan Lake	T4N 0R8	4035558555 	10048	Sauveur	Drinkeld	1-6326 58 Avenue	Red Deer	T4N 2J5	4035558248 	10049	Maxie	Sucre	48 DUFFY Close	Red Deer	T4N 0L9	4035555760 	10050	Klemens	Charlon	101-5344 76 Street	Red Deer	T4N 2A4	4035557997 	10051	Frans	Dowey	204-4728 50 Street	Red Deer	T4N 2L4	4035558403 	10052	Bibi	Winsome	133 JENNINGS Crescent	Red Deer	T4N 0O5	4035558383 	10053	Rebecca	Barthrop	6250 HORN Street	Red Deer	T4N 1T4	4035557533 	10054	Carrie	Meldrum	305-50 GILCHRIST Crescent	Red Deer	T4N 0D7	4035558519 	10055	Tudor	Lapham	191 LONG Close	Red Deer	T4N 0N6	4035559642 	10056	Elbert	Ebbetts	20 OHIO Close	Red Deer	T4N 2G7	4035557975 	10057	Erasmus	Durn	5813 WEST PARK Crescent	Red Deer	T4N 0F7	4035557777 	10058	Margarethe	Callard	3818 39 Street	Red Deer	T4N 1A6	4035559935 	10059	Miller	Blewmen	53 METCALF Avenue	Red Deer	T4N 2O7	4035555106 	10060	Cari	Vennard	407-6834 59 Avenue	Red Deer	T4N 2M7	4035557849 	10061	Salvatore	Blenkinsop	2235 50 Avenue	Red Deer	T4N 2Z9	4035557678 	10062	Sargent	Boik	84 IVERSON Close	Red Deer	T4N 2X7	4035557439 	10063	Colan	Delacourt	10 CODY Place	Red Deer	T4N 0N8	4035558618 	10064	Barnaby	Kuhwald	15 ISSARD Close	Red Deer	T4N 0O2	4035559331 	10065	Darrick	O'Coskerry	34 KENDREW Drive	Red Deer	T4N 1B4	4035556502 	10066	Carie	Causer	4711 60 Street	Red Deer	T4N 0P7	4035559200 	10067	Parsifal	Donlon	12-4700 FOUNTAIN Drive	Red Deer	T4N 2W7	4035559425 	10068	Kelwin	Klimek	243 DAVISON Drive	Red Deer	T4N 0L6	4035557858 	10069	Violetta	Jancey	70 VOISIN Close	Red Deer	T4N 1C7	4035556644 	10070	Shanna	Salomon	836-6834 59 Avenue	Red Deer	T4N 1B4	4035557089 	10071	Chery	Pead	6 LUTZ Court	Red Deer	T4N 2C2	4035559789 	10072	Amalia	Punchard	1-35 NYBERG Avenue	Red Deer	T4N 2C4	4035558186 	10073	Guido	Iacavone	146 ELY Close	Red Deer	T4N 1V1	4035555352 	10074	Emmi	Laddle	4209 35 Street	Red Deer	T4N 2K6	4035557402 	10075	Karrah	Lascelles	4 ARTHUR Close	Red Deer	T4N 2I1	4035557227 	10076	Camilla	Brasner	27 ASHTON Close	Red Deer	T4N 2Y1	4035559918 	10077	Babita	Handrock	7 ASHLEY Close	Red Deer	T4N 0O8	4035557581 	10078	Giorgio	Wroe	83 DODGE Avenue	Red Deer	T4N 2D5	4035557732 	10079	Junia	Schultze	300 INGLEWOOD Drive	Red Deer	T4N 2N4	4035556312 	10080	Roldan	Jeeks	19D-36 COLLEGE Circle D	Red Deer	T4N 2O4	4035556821 	10081	Ron	Baud	101-4805 48 Avenue	Red Deer	T4N 0U6	4035555930 	10082	Miriam	Tiebe	6-4821 46 Street	Red Deer	T4N 2A4	4035557304 	10083	Nelle	Wardhough	78 GISH Street	Red Deer	T4N 1J7	4035557571 	10084	Hillary	Cotillard	75 LAWFORD Avenue	Red Deer	T4N 1T4	4035558734 	10085	Moe	Kwietak	14 WHITESIDE Crescent	Red Deer	T4N 0B1	4035558304 	10086	Samaria	Le land	32 HOLMES Street	Red Deer	T4N 2V2	4035556354 	10087	Nico	Rubertelli	102-5920 50 Avenue	Red Deer	T4N 0Q3	4035555584 	10088	Jedediah	Yosifov	112-3535 55 Avenue	Red Deer	T4N 2L4	4035556973 	10089	Penelopa	Tebbit	4940 51 Street	Red Deer	T4N 1I1	4035556001 	10090	Agustin	Trusler	127 JEPSEN Crescent	Red Deer	T4N 1H6	4035559135 	10091	Birk	O'Caine	B6-2319 TAYLOR Drive B	Red Deer	T4N 2V2	4035555877 	10092	Wendie	Perillo	207-4733 54 Street	Red Deer	T4N 2J3	4035555948 	10093	Zena	Micklem	100-4825 47 Street	Red Deer	T4N 2N9	4035556925 	10094	Devora	Atlee	98 ADDINGTON Drive	Red Deer	T4N 2M9	4035558612 	10095	Derek	Molan	211-5029 34 Street	Red Deer	T4N 0Q8	4035559801 	10096	Beverly	Parnaby	9 SUTHERLAND Close	Red Deer	T4N 2H8	4035555999 	10097	Gerianna	Legonidec	534-100 JORDAN Parkway	Red Deer	T4N 2G7	4035557045 	10098	Byran	Aleshkov	51 NYMAN Crescent	Red Deer	T4N 0M9	4035557360 	10099	Olympe	Gawler	47 LANGFORD Crescent	Red Deer	T4N 2Z1	4035555664 	10100	Shea	Finnes	804-6834 59 Avenue	Red Deer	T4N 0V3	4035557376 	10101	Henrieta	Ambrozik	323-6 MICHENER Boulevard	Red Deer	T4N 0D7	4035555203 	10102	Hannie	Syddie	208-1 SPRINGFIELD Avenue	Red Deer	T4N 0K7	4035557739 	10103	Francklyn	Dring	19 IRVING Crescent	Red Deer	T4N 1G4	4035557297 	10104	Morley	Patrickson	56 JOHNS Street	Red Deer	T4N 2H3	4035557190 	10105	Kaia	Geldart	30002320060 ROLL 30002320060	Red Deer	T4N 2U1	4035556089 	10106	Nicoline	Frackiewicz	3237 55 Avenue	Red Deer	T4N 0E2	4035559861 	10107	Anabelle	Koubu	47 RANDALL Street	Red Deer	T4N 2I3	4035557203 	10108	Rodrique	Kynastone	7036 59 Avenue	Red Deer	T4N 1U9	4035558452 	10109	Geraldine	Piel	120 ALLWRIGHT Close	Red Deer	T4N 1R3	4035558593 	10110	Dmitri	Goodinson	12-5305 47A Avenue	Red Deer	T4N 2J2	4035558385 	10111	Zuzana	Brandon	22 TRAVIS Close	Red Deer	T4N 0N5	4035559829 	10112	Konstance	Trassler	30 ELINE Street	Red Deer	T4N 2T8	4035555548 	10113	Stuart	Wynett	8 SAGEWOOD Close	Red Deer	T4N 1Q6	4035558496 	10114	Lethia	Davidson	7 NICHOLS Crescent	Sylvan Lake	T4N 0O2	4035556672 	10115	Nickolai	Carlo	12-3606 57 Avenue	Red Deer	T4N 2Y3	4035559323 	10116	Tybie	Kleinhaut	11 ASHLEY Close	Red Deer	T4N 0X5	4035559802 	10117	Vernon	Laban	5009 45 Street	Red Deer	T4N 0X2	4035557022 	10118	Aristotle	Lenaghen	303-3815 54 Avenue	Red Deer	T4N 1Y7	4035557331 	10119	Georgeanne	Kelloch	A-25 GILCHRIST Crescent A	Red Deer	T4N 1C9	4035557341 	10120	Chanda	Welch	215 LIVINGSTON Close	Red Deer	T4N 0Y9	4035558554 	10121	Valentine	McLellan	20 BARRETT Drive	Red Deer	T4N 2N9	4035556059 	10122	Merla	Fearneley	5420 48 Avenue	Red Deer	T4N 2U8	4035558373 	10123	Lillis	McQuillin	18 LINN Close	Red Deer	T4N 2I1	4035559898 	10124	Babbie	Glawsop	15 RITSON Close	Red Deer	T4N 0F4	4035558714 	10125	Lorrayne	Widdup	272 KENDREW Drive	Red Deer	T4N 1Q8	4035557765 	10126	Madelena	Scone	5817 44 Avenue	Red Deer	T4N 1K7	4035556858 	10127	Rena	Salasar	30 GAIR Close	Red Deer	T4N 2W1	4035556512 	10128	Maybelle	Cassell	164 VAN SLYKE Way	Lacombe	T4N 0E3	4035556269 	10129	Linnea	Cappleman	402-5213 61 Street	Red Deer	T4N 0M5	4035559440 	10130	Amandi	Hercock	161 LAZARO Close	Red Deer	T4N 0I8	4035555975 	10131	Judye	Adamolli	85 KIRSCH Close	Lacombe	T4N 0M9	4035558936 	10132	Allison	Dugald	B-22 KENDREW Drive B	Red Deer	T4N 0E3	4035559072 	10133	Vera	Enden	5-3501 51 Avenue	Red Deer	T4N 1D1	4035557236 	10134	Patric	Tithecote	33 KEEN Crescent	Red Deer	T4N 1O5	4035555522 	10135	Noelyn	Van Salzberger	8324 CHILES IND Avenue	Red Deer	T4N 2R9	4035556047 	10136	Kirstyn	Larimer	5854 WEST PARK Crescent	Sylvan Lake	T4N 1A1	4035559492 	10137	Beryl	Gerretsen	301-7021 GRAY Drive	Red Deer	T4N 1T3	4035557441 	10138	Merrill	Doddridge	153 CONNAUGHT Crescent	Red Deer	T4N 0C5	4035556576 	10139	Brooks	Sanderson	136 GARRISON Circle	Red Deer	T4N 0I1	4035556389 	10140	Joice	Salway	219-3722 57 Avenue	Red Deer	T4N 2E7	4035556474 	10141	Felike	Petran	54 ALEXANDER Crescent	Red Deer	T4N 2U4	4035558694 	10142	Arni	Faro	216 LANCASTER Drive	Red Deer	T4N 0Q6	4035557684 	10143	Candida	Jindra	45 GREENHOUSE Place	Red Deer	T4N 1G1	4035556450 	10144	Jean	Cheal	P125-18 AVERILL Street P	Red Deer	T4N 1T6	4035556362 	10145	Kerrill	Broomfield	124 OLDRING Crescent	Red Deer	T4N 1I3	4035559148 	10146	Ulysses	Casson	E-4909 48 Street E	Lacombe	T4N 1X1	4035556542 	10147	Drucie	Andreasen	11 KANE Close	Red Deer	T4N 0Q2	4035555930 	10148	Leone	Swatheridge	22 ABRAHAM Close	Red Deer	T4N 0X3	4035558513 	10149	Reena	Venable	79 NOLAN Street	Lacombe	T4N 2F1	4035556577 	10150	Arnuad	Straw	135-33 DONLEVY Avenue	Red Deer	T4N 0J4	4035557610 	10151	Gerardo	Wiggans	7-5425 47A Avenue	Red Deer	T4N 0R7	4035557858 	10152	Melissa	Wotherspoon	394 TOWNSEND Street	Red Deer	T4N 1X8	4035558387 	10153	Herve	Sandry	108-4900 MOLLY BANISTER Drive	Red Deer	T4N 2D4	4035559130 	10154	Kacey	Krollman	22 SPRINGFIELD Avenue	Red Deer	T4N 2U9	4035557798 	10155	Jamesy	Rearie	4408 34 Street	Red Deer	T4N 2X7	4035555016 	10156	Haleigh	Kinney	85 INGLEWOOD Drive	Red Deer	T4N 0U1	4035557228 	10157	Malchy	Turgoose	17 ASHMORE Close	Red Deer	T4N 0C8	4035555399 	10158	Inger	MacTrustram	132 OSWALD Close	Red Deer	T4N 1H8	4035559043 	10159	Lloyd	Aicheson	35 LAROSE Crescent	Red Deer	T4N 0S1	4035557398 	10160	Tibold	Heddan	5710 60 Avenue	Red Deer	T4N 0B2	4035556957 	10161	Ozzy	Ditty	25 GROTE Crescent	Red Deer	T4N 1V3	4035557178 	10162	Maury	Crambie	1D-7957 49 Avenue D	Red Deer	T4N 0Y7	4035555470 	10163	Ilse	Bestwerthick	1A-2085 50 Avenue A	Red Deer	T4N 0U6	4035555673 	10164	Rasla	Bompas	166 KELLOWAY Crescent	Red Deer	T4N 1X8	4035555408 	10165	Alexandra	Dodgshon	120 JORDAN Parkway	Red Deer	T4N 1K1	4035557699 	10166	Cherlyn	Brookes	25 GORDON Street	Red Deer	T4N 0Z8	4035558919 	10167	Shepard	Reynish	P56-5211 39 Street P	Red Deer	T4N 0D3	4035559503 	10168	Barbaraanne	Fraczek	79 BANNERMAN Close	Red Deer	T4N 0F8	4035557386 	10169	Aggi	Hissie	268-5201 43 Street	Red Deer	T4N 2T2	4035557508 	10170	Aubry	Rawlings	22 SUTHERLAND Close	Red Deer	T4N 2A4	4035555635 	10171	Karlotta	Frank	A-3 GIBSON Close A	Red Deer	T4N 2L4	4035559221 	10172	Taddeusz	Titford	175 KELLOWAY Crescent	Red Deer	T4N 0V8	4035556137 	10173	Trev	Chadd	10 DAINES Avenue	Red Deer	T4N 0R2	4035556602 	10174	Nydia	Cassella	4 MCPHEE Street	Red Deer	T4N 2D8	4035555374 	10175	Ave	Euesden	107 LANDRY Bend	Red Deer	T4N 0L8	4035558946 	10176	Mattie	Syred	7969 49 Avenue	Red Deer	T4N 2X3	4035557840 	10177	El	Gillman	4 CLEARVIEW MARKET Way	Red Deer	T4N 1O2	4035558552 	10178	Rosalynd	Eckery	129 CASTLE Crescent	Red Deer	T4N 1V5	4035558638 	10179	Frieda	Troubridge	B-5906 56 Avenue B	Red Deer	T4N 1W9	4035559569 	10180	Carey	Barfitt	2 REEVES Crescent	Red Deer	T4N 2O4	4035556763 	10181	Cassi	Kleanthous	24 ANQUETEL Street	Red Deer	T4N 0J5	4035555045 	10182	Shaylah	Lydford	103-5425 48 Avenue	Red Deer	T4N 2B7	4035555760 	10183	Nelia	Bagg	74 RUTLEDGE Crescent	Red Deer	T4N 1U5	4035559124 	10184	Pembroke	Spyby	5411 38 Street	Red Deer	T4N 0I9	4035558387 	10185	Farand	Coale	34 STEPHENSON Crescent	Lacombe	T4N 0R9	4035556249 	10186	Kory	Assante	204-3413 51 Avenue	Red Deer	T4N 1Q6	4035559102 	10187	Arne	Gamet	P138-5213 61 Street P	Sylvan Lake	T4N 2C3	4035556818 	10188	Geordie	Ledstone	13 OATES Green	Red Deer	T4N 1S8	4035557168 	10189	Kristyn	Veltmann	22 LOCKWOOD Avenue	Red Deer	T4N 1H7	4035558353 	10190	Tessa	Inett	44 DUCKERING Close	Red Deer	T4N 1A9	4035555136 	10191	Dorotea	Cristoforetti	B-22 CARDINAL Avenue B	Red Deer	T4N 1D4	4035559964 	10192	Kally	Frankel	1012-4902 37 Street	Red Deer	T4N 1E7	4035556695 	10193	Granger	Beckensall	81 AINSWORTH Crescent	Red Deer	T4N 0O1	4035556096 	10194	Terrell	Sutch	121-3535 55 Avenue	Lacombe	T4N 1B8	4035559418 	10195	Sarette	Legge	118 LYONS Close	Red Deer	T4N 0E6	4035559260 	10196	Curtis	Trevaskiss	113-42 TIMBERSTONE Way	Red Deer	T4N 2I4	4035559472 	10197	Kassia	Gallymore	140-4710 51 Avenue	Red Deer	T4N 1V9	4035555999 	10198	Steffi	Colbeck	2101-499 TIMBERLANDS Drive	Red Deer	T4N 2D8	4035556361 	10199	Yvette	Benard	4313 18 Street	Red Deer	T4N 0C1	4035557473 	10200	Brit	Fidian	19 NEWLANDS Avenue	Lacombe	T4N 1H8	4035558846 	10201	Bud	Mc Elory	309-128 GLENDALE Boulevard	Red Deer	T4N 2F5	4035556638 	10202	Guilbert	Noraway	54 OBERLIN Avenue	Red Deer	T4N 0E2	4035559018 	10203	Travus	Peinke	3924 38 Avenue	Red Deer	T4N 2N2	4035559064 	10204	Hagan	Hewell	15 JASPAR Close	Red Deer	T4N 2Q2	4035555039 	10205	Chris	Yakubovich	6-7659 EDGAR INDUSTRIAL Drive	Red Deer	T4N 2I3	4035556013 	10206	Philly	Danielou	202-4785 45 Street	Red Deer	T4N 0Q3	4035555704 	10207	Bobbe	Niblett	4924 52 Street	Sylvan Lake	T4N 2V1	4035558253 	10208	Lauraine	Scothron	48 NOBLE Avenue	Red Deer	T4N 0R6	4035558260 	10209	Gannon	Spellissy	B-53 EASTMAN Crescent B	Red Deer	T4N 1Z7	4035555182 	10210	Inna	McWhorter	12 SULLIVAN Close	Red Deer	T4N 0W9	4035555505 	10211	Lavina	Maffiotti	110 JONES Crescent	Red Deer	T4N 1H5	4035558283 	10212	Jannel	Salzburger	115 REICHLEY Street	Red Deer	T4N 1W2	4035559348 	10213	Von	Bradnick	276 JORDAN Parkway	Red Deer	T4N 1S1	4035559093 	10214	Janella	Clapison	8121 49 Avenue Close	Red Deer	T4N 0N5	4035555991 	10215	Yoko	Deelay	10-5579 47 Street	Red Deer	T4N 2D5	4035556177 	10216	Brunhilde	Dadd	207-17A NORQUAY Street A	Red Deer	T4N 2E8	4035559888 	10217	Dorian	Linnett	18-5425 47A Avenue	Red Deer	T4N 0X4	4035558456 	10218	Vere	Loutheane	117-260 DUSTON Street	Red Deer	T4N 2Q9	4035555552 	10219	Brandais	Coates	7 FREEMONT Close	Red Deer	T4N 1H7	4035556717 	10220	Marne	De Simone	18 VOLD Close	Red Deer	T4N 1I8	4035559023 	10221	Felizio	Valeri	106-50B LIVINGSTON Close B	Lacombe	T4N 2E3	4035559528 	10222	Linoel	Swift	437-6 MICHENER Boulevard	Red Deer	T4N 2Q4	4035558599 	10223	Claudian	Rodson	B-112 INGLEWOOD Drive B	Sylvan Lake	T4N 1V1	4035555427 	10224	Minerva	Knevit	B-158 DONNELLY Crescent B	Red Deer	T4N 1L2	4035559804 	10225	Molly	Benzi	115 CARPENTER Street	Red Deer	T4N 1Z2	4035555064 	10226	Gerianne	Carlens	126 VANCOUVER Crescent	Red Deer	T4N 0K6	4035555650 	10227	Karylin	McCullagh	623 600 RAMAGE Close	Red Deer	T4N 2T1	4035556567 	10228	Bell	Trow	B09-87 COLLEGE Circle B	Red Deer	T4N 0E7	4035556389 	10229	Derby	Stickings	191 NORTHEY Avenue	Red Deer	T4N 0B9	4035557671 	10230	Winne	Lenormand	110-100 JORDAN Parkway	Red Deer	T4N 2W4	4035559364 	10231	Guendolen	Shackesby	101 NICHOLS Crescent	Red Deer	T4N 0D5	4035556344 	10232	Fonz	Babbidge	99 STEPHENSON Crescent	Red Deer	T4N 0U1	4035556575 	10233	Adaline	Hencke	5920 51 Avenue	Red Deer	T4N 1P9	4035559362 	10234	Orella	Woodnutt	105-4807 50 Avenue	Red Deer	T4N 1L2	4035559405 	10235	Katrinka	Barwood	C-6 CARDINAL Avenue C	Red Deer	T4N 2I7	4035557826 	10236	Deeyn	Wiffen	1 ABEL Close	Red Deer	T4N 0I8	4035558692 	10237	Lind	Heap	103-5617 60 Avenue	Red Deer	T4N 0O7	4035557496 	10238	Agathe	Glyn	203-49 GREIG Drive	Red Deer	T4N 2P3	4035555516 	10239	Maurizia	Picard	B-4122 36 Street B	Red Deer	T4N 0X7	4035555815 	10240	Gwyn	Vassman	74 KIDD Close	Red Deer	T4N 0W2	4035558380 	10241	Luise	Howell	BLDG 11000-499 TIMBERLANDS Drive BLDG	Red Deer	T4N 1H3	4035556570 	10242	Jennie	Lauridsen	3905 56 Avenue	Red Deer	T4N 0W9	4035558778 	10243	Ethelind	Cammacke	7932 EDGAR INDUSTRIAL Way	Red Deer	T4N 2S8	4035559683 	10244	Emmett	MacFall	20 ARNOLD Close	Red Deer	T4N 0Q6	4035559144 	10245	Bentley	Stiggers	23-4021 50A Street	Red Deer	T4N 0P6	4035556169 	10246	Wendie	Betts	86 VOISIN Close	Red Deer	T4N 0Y8	4035555596 	10247	Cristobal	Labroue	9 GARRISON Place	Red Deer	T4N 2T7	4035558718 	10248	Timothy	Stothert	44 AIKMAN Close	Sylvan Lake	T4N 0J3	4035557292 	10249	Corette	Van der Son	102-4714A 55 Street A	Red Deer	T4N 1E6	4035555133 	10250	Louise	Stollhofer	116-2450A 22 Street A	Red Deer	T4N 2M6	4035556443 	10251	Connie	Haythorne	100 KIDD Close	Red Deer	T4N 1M2	4035556153 	10252	Amity	Brickell	11-20 JACOBS Close	Red Deer	T4N 2S7	4035558718 	10253	Kevon	Pettiford	78 ANDERS Street	Red Deer	T4N 2D2	4035555348 	10254	Tallie	Fentem	10 WISHART Street	Red Deer	T4N 1E6	4035559491 	10255	Matthieu	MacKomb	B-5827 57 Avenue B	Lacombe	T4N 1K2	4035559713 	10256	Jethro	Trineman	316-301B TIMOTHY Drive B	Red Deer	T4N 0B8	4035556919 	10257	Aldis	Eccleston	6-3602 57 Avenue	Sylvan Lake	T4N 0Y4	4035559025 	10258	Tera	Golds	3929 43 Avenue	Red Deer	T4N 2S9	4035556149 	10259	Leonora	Linggood	1-5914 52 Avenue	Red Deer	T4N 1R9	4035556765 	10260	Cynthia	Ailward	318 DUSTON Street	Red Deer	T4N 2B4	4035555749 	10261	Dall	Pichan	5-5816 53 Avenue	Red Deer	T4N 2Y8	4035557061 	10262	Sarene	Patterson	202-3920 44 Street	Red Deer	T4N 2P2	4035559519 	10263	Joline	Bedrosian	208-5120 62 Street	Red Deer	T4N 2Z8	4035559666 	10264	Bev	Burnup	212-4810 54 Street	Red Deer	T4N 2Y8	4035557929 	10265	Case	Ivermee	118-42 TIMBERSTONE Way	Red Deer	T4N 1Y8	4035555184 	10266	Sanders	Teasell	660 LANCASTER Drive	Red Deer	T4N 0S2	4035559314 	10267	Jada	Michelmore	2-20 JACOBS Close	Red Deer	T4N 0D1	4035559526 	10268	Rollins	Jenks	3 LANDRY Bend	Red Deer	T4N 1T4	4035557343 	10269	Menard	Pentelow	107 VANIER Drive	Red Deer	T4N 1Y3	4035555681 	10270	Tracie	Stuckley	5729 41 Street Crescent	Red Deer	T4N 2F1	4035555310 	10271	Jinny	Broske	1738 49 Avenue	Red Deer	T4N 0A4	4035559945 	10272	Jodee	Langstone	118 TURNER Crescent	Red Deer	T4N 2I9	4035555841 	10273	Kelbee	Simnell	34-4240 46A Avenue Crescent	Red Deer	T4N 1D7	4035557124 	10274	Peyton	Silverstone	4715 43A Avenue	Red Deer	T4N 1P2	4035559187 	10275	Jeanette	Aldhous	128 VALENTINE Crescent	Red Deer	T4N 0K8	4035558148 	10276	Ramon	Parish	18 BANNERMAN Close	Red Deer	T4N 0L6	4035559096 	10277	Brenna	Konmann	3 GREENE Close	Red Deer	T4N 2H2	4035556527 	10278	Abigail	Jereatt	BMT-5809 56 Avenue BMT	Red Deer	T4N 1O6	4035555744 	10279	Kara-lynn	Eads	22 ALEXIS Street	Red Deer	T4N 2L3	4035555902 	10280	Hervey	Feedome	25 VICTOR Close	Red Deer	T4N 0A2	4035557452 	10281	Shepherd	O' Cloney	3-3901 50A Avenue	Red Deer	T4N 2U1	4035557379 	10282	Pen	Coggan	7159 50 Avenue	Red Deer	T4N 2B2	4035557117 	10283	Blanca	Wearn	304-4912 54 Street	Red Deer	T4N 2O6	4035555949 	10284	Wenona	Greatex	Lease B-7769 EDGAR INDUSTRIAL Way	Red Deer	T4N 1L9	4035555756 	10285	Ramon	Aggis	191 LOUGHEED Close	Red Deer	T4N 2E4	4035555380 	10286	Albert	Overlow	127-4277 46A Avenue	Red Deer	T4N 0F1	4035556611 	10287	Patsy	Maggs	9-60 LAWFORD Avenue	Red Deer	T4N 2Y7	4035557141 	10288	Forster	Kidner	417-60 LAWFORD Avenue	Red Deer	T4N 1G7	4035558049 	10289	Rikki	Billanie	3599 55 Street	Red Deer	T4N 2Y8	4035556210 	10290	Maddi	Tweedle	235-4512 52 Avenue	Red Deer	T4N 2K5	4035556524 	10291	Chicky	Masding	104-5110 36 Street	Red Deer	T4N 0R6	4035558455 	10292	Curtis	Lory	6-18 MICHENER Way	Red Deer	T4N 1I6	4035558814 	10293	Quincey	Trustie	P76-5217 39 Street P	Red Deer	T4N 1I4	4035559483 	10294	Philippa	Glozman	29-4250 54 Avenue	Lacombe	T4N 2R6	4035558075 	10295	Hettie	Sproule	MN-4806 53 Street MN	Red Deer	T4N 2W8	4035555789 	10296	Marylin	Severwright	316-4501 48 Avenue	Red Deer	T4N 2G7	4035555965 	10297	Joby	Malsher	78 TRAPTOW Close	Red Deer	T4N 2R3	4035559914 	10298	Nolan	Ditts	130-56 CARROLL Crescent	Red Deer	T4N 0P9	4035556499 	10299	Maurene	Olechnowicz	5-3722 57 Avenue	Red Deer	T4N 2A1	4035556473 	10300	Link	Sheen	116 GRANT Street	Red Deer	T4N 1H8	4035557081 	10301	Ira	Tallent	3-4605 62 Street	Red Deer	T4N 2F2	4035556546 	10302	Cristabel	Chamberlain	18-20 ALFORD Avenue	Red Deer	T4N 0Q7	4035557784 	10303	Bail	Scrogges	110-6300 CRONQUIST Drive	Red Deer	T4N 0P1	4035558309 	10304	Janene	Mahody	5304 46 Avenue	Red Deer	T4N 1J9	4035558679 	10305	Maura	Hazelton	15 THOMLISON Avenue	Red Deer	T4N 2H2	4035559763 	10306	Cheston	Eyer	28 ALTON Close	Red Deer	T4N 0B8	4035559924 	10307	Barbabra	Blacklidge	B-3306 49 Avenue B	Red Deer	T4N 1N6	4035556088 	10308	Jerome	Del Monte	2107-12 IRONSIDE Street	Red Deer	T4N 1B6	4035556119 	10309	Porty	Swaffer	54-103 ADDINGTON Drive	Red Deer	T4N 2C1	4035558908 	10310	Jojo	Dorken	5621 55 Street	Red Deer	T4N 1U1	4035556580 	10311	Ethelda	Pressland	C-7983 EDGAR INDUSTRIAL Drive	Red Deer	T4N 0Q4	4035558132 	10312	Kaylyn	Flook	217 JENNINGS Crescent	Red Deer	T4N 2R8	4035558846 	10313	Sherry	Blackham	34 TURNER Crescent	Red Deer	T4N 0R7	4035558202 	10314	Marcelo	Robertsson	37 ROVERS Avenue	Lacombe	T4N 2F9	4035559778 	10315	Bernelle	Zimmermeister	88 CARTER Close	Red Deer	T4N 2P5	4035557654 	10316	Christy	Maberley	P2212-12 IRONSIDE Street P	Red Deer	T4N 0X4	4035559048 	10317	Winthrop	Meriott	2142 DANIELLE Drive	Red Deer	T4N 1K3	4035555974 	10318	Virgie	Dri	41 GILBERT Crescent	Red Deer	T4N 0P5	4035556263 	10319	Carl	Meddick	7 MICHENER Place	Red Deer	T4N 2H2	4035556699 	10320	Tomasina	Sansun	226 GLENDALE Boulevard	Red Deer	T4N 0U2	4035558063 	10321	Aloysius	Worsell	55 ABEL Close	Red Deer	T4N 2A5	4035557520 	10322	Rianon	Fairhurst	201-5415 48 Avenue	Red Deer	T4N 0Z9	4035555178 	10323	Matthaeus	Hearnden	6204 46 Avenue	Red Deer	T4N 1Q6	4035559381 	10324	Agustin	Urlich	100-4781 49 Street	Red Deer	T4N 1X6	4035555606 	10325	Lelia	Arling	302-5207 39 Street	Red Deer	T4N 2V5	4035555996 	10326	Cyrill	O'Gavin	4122 51A Street	Red Deer	T4N 0Y6	4035556212 	10327	Cindy	McColley	149 WILSON Crescent	Red Deer	T4N 2I6	4035559210 	10328	Carolee	Beining	5939 60 Avenue	Red Deer	T4N 1F2	4035555007 	10329	Syman	Chasmar	4445 EMBURY Crescent	Red Deer	T4N 0Z3	4035555747 	10330	Ardisj	Soggee	140-25 CHAMBERS Avenue	Red Deer	T4N 1G6	4035556370 	10331	Tonia	Milch	105-4277 46A Avenue	Red Deer	T4N 1S5	4035558078 	10332	Edgar	Paradise	6 JASPAR Crescent	Red Deer	T4N 2D9	4035559019 	10333	Alard	Jeakins	5802 57 Avenue	Red Deer	T4N 0K4	4035558546 	10334	Randee	Chatters	51 ELLIS Street	Red Deer	T4N 1U1	4035558937 	10335	Fredrick	Dionsetti	83 ARMITAGE Close	Red Deer	T4N 1J9	4035558492 	10336	Karel	Peattie	802-4719 33 Street	Red Deer	T4N 2R9	4035559598 	10337	Doralin	Birrel	A-39 WILEY Crescent A	Red Deer	T4N 1D3	4035556247 	10338	Culley	Ferroni	P172-6 MICHENER Boulevard P	Red Deer	T4N 2G5	4035559608 	10339	Bertrand	Westhoff	38 AVERY Street	Red Deer	T4N 0Y8	4035558189 	10340	Addy	Rassell	5008 48 Street	Red Deer	T4N 0P6	4035558139 	10341	Cherianne	Puncher	208-5100 60 Street	Red Deer	T4N 1A1	4035558127 	10342	Riley	Ghiriardelli	4620 62 Street	Red Deer	T4N 0T6	4035556838 	10343	Rudyard	Piggins	32 WILEY Crescent	Red Deer	T4N 2Y3	4035557164 	10344	Georas	Attenbrow	202 EMERALD Drive	Lacombe	T4N 1M7	4035558970 	10345	Paquito	Hogbourne	5606 60 Avenue	Red Deer	T4N 1F5	4035559907 	10346	Elberta	McGougan	74 DUNCAN Crescent	Red Deer	T4N 1W5	4035559239 	10347	Pace	MacCurlye	32 KENNY Close	Red Deer	T4N 1Q8	4035559094 	10348	Emanuele	Schustl	25 NAGEL Avenue	Red Deer	T4N 2B3	4035559964 	10349	Curtice	Leber	27 ASSINGER Avenue	Red Deer	T4N 2U3	4035558796 	10350	Lexie	Loveguard	57 CUNNINGHAM Crescent	Red Deer	T4N 0V9	4035555294 	10351	Odette	Cass	301-80A KELLOWAY Crescent A	Red Deer	T4N 1K9	4035557776 	10352	Luciana	Shurrock	16 KERSHAW Close	Red Deer	T4N 2N8	4035559120 	10353	Gwynne	Tungate	15 EAST Close	Red Deer	T4N 1Q1	4035557318 	10354	Norton	Paske	30 ANSETT Crescent	Red Deer	T4N 2W9	4035559511 	10355	Emelen	Nimmo	51 AYERS Avenue	Red Deer	T4N 1C8	4035558890 	10356	Darby	Halward	148 GARRISON Circle	Red Deer	T4N 2D3	4035556996 	10357	Stephana	Kilmister	4921 48 Street	Red Deer	T4N 2L1	4035559714 	10358	Magdalen	Lesper	4126 35 Street	Red Deer	T4N 2Q6	4035558709 	10359	Brit	Gertz	42 ASSINGER Avenue	Red Deer	T4N 2M4	4035555980 	10360	Obidiah	De Lascy	P64-3730 50 Avenue P	Red Deer	T4N 0X8	4035557550 	10361	Lorelei	Haker	P179-6 MICHENER Boulevard P	Red Deer	T4N 2T4	4035559562 	10362	Elwyn	Stiffell	5853 WEST PARK Crescent	Red Deer	T4N 0M8	4035557550 	10363	Willy	Rippingall	204-1 SPRINGFIELD Avenue	Red Deer	T4N 0W2	4035558443 	10364	Ferdinande	Fletcher	141 RUPERT Crescent	Red Deer	T4N 0C6	4035558883 	10365	Rube	Hamberstone	3920 46 Street	Red Deer	T4N 1R1	4035557108 	10366	Alikee	Soulsby	7463 EDGAR INDUSTRIAL Drive	Red Deer	T4N 2Y5	4035555109 	10367	Raimundo	Yurocjkin	B-138 KIRKLAND Close B	Red Deer	T4N 0S1	4035556624 	10368	Hedwig	Gallelli	3218 49 Avenue	Red Deer	T4N 1K6	4035558465 	10369	Noel	Harlick	76 PARSONS Close	Red Deer	T4N 0C4	4035556770 	10370	Netty	McAlindon	27 PARKSIDE Drive	Red Deer	T4N 1J1	4035557992 	10371	Shelton	Silverlock	4912 DONCASTER Avenue	Red Deer	T4N 2J8	4035556519 	10372	Sean	Canedo	30 EAKINS Crescent	Red Deer	T4N 0S3	4035559555 	10373	Babita	Wilson	1-7471 EDGAR INDUSTRIAL Bend	Red Deer	T4N 2E7	4035558756 	10374	Chic	de Vaen	18 GRIMSON Street	Red Deer	T4N 1F4	4035556784 	10375	Gibby	Acres	439-6 MICHENER Boulevard	Red Deer	T4N 1F1	4035557565 	10376	Haily	Florez	2-4608 62 Street	Red Deer	T4N 0O4	4035555237 	10377	Madelyn	Heake	D-76 OAK Street D	Red Deer	T4N 0C8	4035557185 	10378	Hayley	Inston	299 LAMPARD Crescent	Red Deer	T4N 0V3	4035558044 	10379	Jeffie	Checcucci	25 JUNIPER Close	Red Deer	T4N 1N3	4035557599 	10380	Arda	Pettegre	21 MUNRO Crescent	Red Deer	T4N 0V9	4035558117 	10381	Myriam	Skirrow	P12-260 DUSTON Street P	Red Deer	T4N 0X4	4035557660 	10382	Gerick	Polotti	21 SOMERSET Close	Red Deer	T4N 1E1	4035559099 	10383	Rosaleen	Caudrelier	49 WADE Close	Red Deer	T4N 1D5	4035557607 	10384	Jacob	Muress	42 LANDRY Bend	Red Deer	T4N 2J8	4035559284 	10385	Osbourne	Minall	49 JENKINS Drive	Red Deer	T4N 0P2	4035558792 	10386	Crissie	Danielli	143 JEPSEN Crescent	Red Deer	T4N 0B1	4035556521 	10387	Roddie	Lowson	113-4512 52 Avenue	Lacombe	T4N 1M1	4035556256 	10388	Farrand	Kinsett	328-260 DUSTON Street	Red

Ali Asgar · Accepted Answer

Object Definition
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 1Table: BuildProduct
Properties
AlternateBackShade: 100 AlternateBackThemeColorInd -1
AlternateBackTint: 100 BackShade: 100
BackTint: 100 DatasheetForeThemeColorIn -1
DatasheetGridlinesThemeCol -1 DateCreated: 11/03/2021 19:08:02
DefaultView: 2 DisplayViewsOnSharePointSit 1
FilterOnLoad: False GUID: {guid {7593D323-AC81-46A0-
943D-442C0D22EF08}}
HideNewField: False LastUpdated: 11/03/2021 23:22:31
NameMap: Long binary data OrderByOn: False
OrderByOnLoad: True Orientation: Left-to-Right
PublishToWeb: 1 ReadOnlyWhenDisconnected False
RecordCount: 1473 ThemeFontIndex: -1
TotalsRow: False Updatable: True
Columns
Name Type Size
ProductID Short Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
Format: @
GUID: {guid {70BF222E-E6DE-4197-9BF6-8F45267EDAA8}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 0
Required: True
ResultType: 0
SourceField: ProductID
SourceTable: BuildProduct
TextAlign: General
UnicodeCompression: False
BuildID Long Integer 4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 2Table: BuildProduct
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {27926ED4-77B6-4C34-974D-82758FFE5ADE}}
OrdinalPosition: 1
Required: True
ResultType: 0
SourceField: BuildID
SourceTable: BuildProduct
TextAlign: General
InService Date Date With Time 8
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
Format: dd/mm/yyyy
GUID: {guid {D611634D-3E9A-46AC-A879-20766C9FD788}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 2
Required: False
ResultType: 0
ShowDatePicker: For dates
SourceField: InService Date
SourceTable: BuildProduct
TextAlign: General
Relationships
Customer BuildBuildProduct
Customer Build BuildProduct
1BuildID BuildID
Attributes: Enforced
RelationshipType: One-To-Many
Product CatalogBuildProduct
Product Catalog BuildProduct
1ProductID ProductID
Attributes: Enforced
RelationshipType: One-To-Many
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 3Table: BuildProduct
User Permissions
Table Indexes
Name Number of Fields
Customer BuildBuildProduct 1
Clustered: False
DistinctCount: 1473
Foreign: True
IgnoreNulls: False
Name: Customer BuildBuildProduct
Primary: False
Required: False
Unique: False
Fields:
AscendingBuildID
PrimaryKey 2
Clustered: False
DistinctCount: 1473
Foreign: False
IgnoreNulls: False
Name: PrimaryKey
Primary: True
Required: True
Unique: True
Fields:
AscendingProductID
AscendingBuildID
Product CatalogBuildProduct 1
Clustered: False
DistinctCount: 9
Foreign: True
IgnoreNulls: False
Name: Product CatalogBuildProduct
Primary: False
Required: False
Unique: False
Fields:
AscendingProductID
ProductID 1
Clustered: False
DistinctCount: 9
Foreign: False
IgnoreNulls: False
Name: ProductID
Primary: False
Required: False
Unique: False
Fields:
AscendingProductID
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 4Table: BuildProduct
admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, 
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Group Permissions
Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, 
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, 
Write Definition, Read Data, Insert Data, Update Data, Delete Data
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 5Table: Cable Data Usage
Properties
AlternateBackShade: 100 AlternateBackThemeColorInd -1
AlternateBackTint: 100 BackShade: 100
BackTint: 100 DatasheetForeThemeColorIn -1
DatasheetGridlinesThemeCol -1 DateCreated: 11/03/2021 21:28:10
DefaultView: 2 DisplayViewsOnSharePointSit 1
FCMinDesignVer: 16.0.7124.1000 FCMinReadVer: 16.0.7124.1000
FCMinWriteVer: 16.0.7124.1000 FilterOnLoad: False
GUID: {guid {DA2DA3D9-C684-4B78-
BC82-B4CCF3C0B7FF}}
HideNewField: False
LastUpdated: 11/03/2021 23:25:22 NameMap: Long binary data
OrderByOn: False OrderByOnLoad: True
Orientation: Left-to-Right PublishToWeb: 1
ReadOnlyWhenDisconnected False RecordCount: 20622
ThemeFontIndex: -1 TotalsRow: False
Updatable: True
Columns
Name Type Size
CableDataID Integer 2
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {3470DC7D-2D0C-414D-836D-3182D53DF21B}}
OrdinalPosition: 0
Required: True
ResultType: 0
SourceField: CableDataID
SourceTable: Cable Data Usage
TextAlign: General
DataMonth Integer 2
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 6Table: Cable Data Usage
DecimalPlaces: Auto
DisplayControl: Text Box
Format: General Number
GUID: {guid {DF9D696A-C508-4ECE-AFD6-27AF3AB16D10}}
OrdinalPosition: 1
Required: False
ResultType: 0
SourceField: DataMonth
SourceTable: Cable Data Usage
TextAlign: General
DataYear Integer 2
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
Format: General Number
GUID: {guid {FB4FE15E-FDE7-48A3-BBCE-C13389F4183A}}
OrdinalPosition: 2
Required: False
ResultType: 0
SourceField: DataYear
SourceTable: Cable Data Usage
TextAlign: General
ITVDataByGB Double 8
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
Format: General Number
GUID: {guid {FAFCEDEC-5493-46FC-9E03-B47C8BF26D62}}
OrdinalPosition: 3
Required: False
ResultType: 0
SourceField: ITVDataByGB
SourceTable: Cable Data Usage
TextAlign: General
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 7Table: Cable Data Usage
CustomerID Number (Floating Decimal) 8
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {CD202289-972B-4B0A-BCEE-102F89A1EA0F}}
OrdinalPosition: 4
Required: False
ResultType: 0
SourceField: CustomerID
SourceTable: Cable Data Usage
TextAlign: General
Relationships
CustomerCable Data Usage
Customer Cable Data Usage
1CustomerID CustomerID
Attributes: Enforced
RelationshipType: One-To-Many
Table Indexes
Name Number of Fields
CableDataID 1
Clustered: False
DistinctCount: 20622
Foreign: False
IgnoreNulls: False
Name: CableDataID
Primary: True
Required: True
Unique: True
Fields:
AscendingCableDataID
CustomerCable Data Usage 1
Clustered: False
DistinctCount: 878
Foreign: True
IgnoreNulls: False
Name: CustomerCable Data Usage
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 8Table: Cable Data Usage
User Permissions
admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, 
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Group Permissions
Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, 
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, 
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Primary: False
Required: False
Unique: False
Fields:
AscendingCustomerID
CustomerID 1
Clustered: False
DistinctCount: 878
Foreign: False
IgnoreNulls: False
Name: CustomerID
Primary: False
Required: False
Unique: False
Fields:
AscendingCustomerID
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 9Table: Call Display Records
Properties
AlternateBackShade: 100 AlternateBackThemeColorInd -1
AlternateBackTint: 100 BackShade: 100
BackTint: 100 DatasheetForeThemeColorIn -1
DatasheetGridlinesThemeCol -1 DateCreated: 11/03/2021 21:29:30
DefaultView: 2 DisplayViewsOnSharePointSit 1
FCMinDesignVer: 16.0.7124.1000 FCMinReadVer: 16.0.7124.1000
FCMinWriteVer: 16.0.7124.1000 FilterOnLoad: False
GUID: {guid {57A2E9C5-79C6-47F3-
98F3-DFD9B5462C9B}}
HideNewField: False
LastUpdated: 11/03/2021 23:26:50 NameMap: Long binary data
OrderByOn: False OrderByOnLoad: True
Orientation: Left-to-Right PublishToWeb: 1
ReadOnlyWhenDisconnected False RecordCount: 198051
ThemeFontIndex: -1 TotalsRow: False
Updatable: True
Columns
Name Type Size
CDR_ID Long Integer 4
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {FDAF1BC1-6322-4B1A-A404-34FD6229AF3F}}
OrdinalPosition: 0
Required: True
ResultType: 0
SourceField: CDR_ID
SourceTable: Call Display Records
TextAlign: General
CallDay Integer 2
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 10Table: Call Display Records
DecimalPlaces: Auto
DisplayControl: Text Box
Format: General Number
GUID: {guid {20F4CF46-72D1-4C2F-8126-B63FB8F686B6}}
OrdinalPosition: 1
Required: False
ResultType: 0
SourceField: CallDay
SourceTable: Call Display Records
TextAlign: General
CallMonth Integer 2
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
Format: General Number
GUID: {guid {1BE019C4-BC50-4CCE-A3AD-93E1C9D4F3A4}}
OrdinalPosition: 2
Required: False
ResultType: 0
SourceField: CallMonth
SourceTable: Call Display Records
TextAlign: General
CallYear Integer 2
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
Format: General Number
GUID: {guid {6A5218F3-E0E0-4457-A773-35E32BA2BD78}}
OrdinalPosition: 3
Required: False
ResultType: 0
SourceField: CallYear
SourceTable: Call Display Records
TextAlign: General
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 11Table: Call Display Records
CallMinutes Double 8
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
Format: General Number
GUID: {guid {7AE28F55-69D6-4DEA-A824-251569BFDBC8}}
OrdinalPosition: 4
Required: False
ResultType: 0
SourceField: CallMinutes
SourceTable: Call Display Records
TextAlign: General
PhoneNumber Number (Floating Decimal) 8
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {B9C42FC3-6352-4088-9BEC-85ACC756E142}}
OrdinalPosition: 5
Required: False
ResultType: 0
SourceField: PhoneNumber
SourceTable: Call Display Records
TextAlign: General
Relationships
Phone Number PoolCall Display Records
Phone Number Pool Call Display Records
1PhoneNumber PhoneNumber
Attributes: Enforced
RelationshipType: One-To-Many
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 12Table: Call Display Records
User Permissions
admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, 
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Group Permissions
Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, 
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, 
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Table Indexes
Name Number of Fields
CDR_ID 1
Clustered: False
DistinctCount: 198051
Foreign: False
IgnoreNulls: False
Name: CDR_ID
Primary: True
Required: True
Unique: True
Fields:
AscendingCDR_ID
Phone Number PoolCall Display Records 1
Clustered: False
DistinctCount: 466
Foreign: True
IgnoreNulls: False
Name: Phone Number PoolCall Display Records
Primary: False
Required: False
Unique: False
Fields:
AscendingPhoneNumber
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 13Table: Customer
Properties
AlternateBackShade: 100 AlternateBackThemeColorInd -1
AlternateBackTint: 100 BackShade: 100
BackTint: 100 DatasheetForeThemeColorIn -1
DatasheetGridlinesThemeCol -1 DateCreated: 11/03/2021 16:54:39
DefaultView: 2 DisplayViewsOnSharePointSit 1
FCMinDesignVer: 16.0.7124.1000 FCMinReadVer: 16.0.7124.1000
FCMinWriteVer: 16.0.7124.1000 FilterOnLoad: False
GUID: {guid {2B3C6845-C838-4FBD-
9AB3-2ABE083E4AF2}}
HideNewField: False
LastUpdated: 12/03/2021 00:05:45 NameMap: Long binary data
OrderByOn: False OrderByOnLoad: True
Orientation: Left-to-Right PublishToWeb: 1
ReadOnlyWhenDisconnected False RecordCount: 1000
ThemeFontIndex: -1 TotalsRow: False
Updatable: True
Columns
Name Type Size
CustomerID Number (Floating Decimal) 8
AggregateType: -1
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {EC8E70F2-E57D-4768-9597-A9E854C6A308}}
OrdinalPosition: 0
Required: True
ResultType: 0
SourceField: CustomerID
SourceTable: Customer
TextAlign: General
FirstName Short Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 14Table: Customer
DisplayControl: Text Box
Format: @
GUID: {guid {F7954931-F71E-494B-A2CF-59082AA59DEE}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 1
Required: False
ResultType: 0
SourceField: FirstName
SourceTable: Customer
TextAlign: General
UnicodeCompression: False
LastName Short Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
Format: @
GUID: {guid {2E3FDF92-09D3-487D-ACCC-4665ACD40D52}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 2
Required: False
ResultType: 0
SourceField: LastName
SourceTable: Customer
TextAlign: General
UnicodeCompression: False
StreetAddress Long Text -
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
GUID: {guid {46855989-0F40-4786-B7DF-66D9A088BD19}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 3
Required: False
ResultType: 0
SourceField: StreetAddress
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 15Table: Customer
SourceTable: Customer
TextAlign: General
TextFormat: Plain Text
UnicodeCompression: False
City Short Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
Format: 0
GUID: {guid {EB94C4E8-F4D8-4794-A55B-4E5A1011F1C6}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 4
Required: False
ResultType: 0
SourceField: City
SourceTable: Customer
TextAlign: General
UnicodeCompression: False
PostalCode Short Text 255
AggregateType: -1
AllowZeroLength: True
AppendOnly: False
Attributes: Variable Length
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DisplayControl: Text Box
Format: @
GUID: {guid {502D3B31-13FC-4845-84DD-084BB0D580B6}}
IMEMode: 0
IMESentenceMode: 3
OrdinalPosition: 5
Required: False
ResultType: 0
SourceField: PostalCode
SourceTable: Customer
TextAlign: General
UnicodeCompression: False
Phone Number (Floating Decimal) 8
AggregateType: -1
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 16Table: Customer
AllowZeroLength: False
AppendOnly: False
Attributes: Fixed Size
CollatingOrder: General
ColumnHidden: False
ColumnOrder: Default
ColumnWidth: Default
CurrencyLCID: 0
DataUpdatable: False
DecimalPlaces: Auto
DisplayControl: Text Box
GUID: {guid {26D92A96-7BC3-4CA4-9569-5782012A6D45}}
OrdinalPosition: 6
Required: False
ResultType: 0
SourceField: Phone
SourceTable: Customer
TextAlign: General
Relationships
CustomerCable Data Usage
Customer Cable Data Usage
1CustomerID CustomerID
Attributes: Enforced
RelationshipType: One-To-Many
CustomerCustomer Build
Customer Customer Build
1CustomerID CustomerID
Attributes: Enforced
RelationshipType: One-To-Many
Table Indexes
Name Number of Fields
City 1
Clustered: False
DistinctCount: 3
Foreign: False
IgnoreNulls: False
Name: City
Primary: False
Required: False
Unique: False
C:\Users\Public\Documents\BNC.accdb 12 March 2021
Page: 17Table: Customer
User Permissions
admin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, 
Write Definition, Read Data, Insert Data, Update Data, Delete Data
Fields:
AscendingCity
CustomerID 1
Clustered: False
DistinctCount:

Customer CustomerIDFirstNameLastNameStreetAddressCityPostalCodePhone 10000MelodyWarde60 DRUMMOND AvenueRed DeerT4N 1L8 XXXXXXXXXX 10001KingOsmond15-73 ADDINGTON DriveRed DeerT4N 2G3...

Answer To: Customer CustomerIDFirstNameLastNameStreetAddressCityPostalCodePhone 10000MelodyWarde60...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment