Exp19_Access_Ch07_Cap_Replacement_Parts.accdb
| CustomerID |
CompanyName |
ContactName |
ContactTitle |
Address |
City |
Region |
PostalCode |
Country |
Phone |
Fax |
mSysRowId |
| ALFKI |
Alfreds Futterkiste |
Maria Anders |
Sales Representative |
Obere Str. 57 |
Berlin |
| 12209 |
Germany |
030-0074321 |
030-0076545 |
svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| ANATR |
Ana Trujillo Emparedados y helados |
Ana Trujillo |
Owner |
Avda. de la Constitución 2222 |
México D.F. |
| 05021 |
Mexico |
(5) 555-4729 |
(5) 555-3745 |
svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| ANTON |
Antonio Moreno Taquería |
Antonio Moreno |
Owner |
Mataderos 2312 |
México D.F. |
| 05023 |
Mexico |
(5) 555-3932 |
| svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| AROUT |
Around the Horn |
Thomas Hardy |
Sales Representative |
120 Hanover Sq. |
London |
| WA1 1DP |
UK |
(171) 555-7788 |
(171) 555-6750 |
svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| BERGS |
Berglunds snabbköp |
Christina Berglund |
Order Administrator |
Berguvsvägen 8 |
Luleå |
| S-958 22 |
Sweden |
0921-12 34 65 |
0921-12 34 67 |
svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| BLAUS |
Blauer See Delikatessen |
Hanna Moos |
Sales Representative |
Forsterstr. 57 |
Mannheim |
| 68306 |
Germany |
0621-08460 |
0621-08924 |
svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| BLONP |
Blondel père et fils |
Frédérique Citeaux |
Marketing Manager |
24, place Kléber |
Strasbourg |
| 67000 |
France |
88.60.15.31 |
88.60.15.32 |
svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| BOLID |
Bólido Comidas preparadas |
Martín Sommer |
Owner |
C/ Araquil, 67 |
Madrid |
| 28023 |
Spain |
(91) 555 22 82 |
(91) 555 91 99 |
svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| BONAP |
Bon app' |
Laurence Lebihan |
Owner |
12, rue des Bouchers |
Marseille |
| 13008 |
France |
91.24.45.40 |
91.24.45.41 |
svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| BOTTM |
Bottom-Dollar Markets |
Elizabeth Lincoln |
Accounting Manager |
23 Tsawassen Blvd. |
Tsawassen |
BC |
T2F 8M4 |
Canada |
(604) 555-4729 |
(604) 555-3745 |
svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| BSBEV |
B's Beverages |
Victoria Ashworth |
Sales Representative |
Fauntleroy Circus |
London |
| EC2 5NT |
UK |
(171) 555-1212 |
| svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| CACTU |
Cactus Comidas para llevar |
Patricio Simpson |
Sales Agent |
Cerrito 333 |
Buenos Aires |
| 1010 |
Argentina |
(1) 135-5555 |
(1) 135-4892 |
svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| CENTC |
Centro comercial Moctezuma |
Francisco Chang |
Marketing Manager |
Sierras de Granada 9993 |
México D.F. |
| 05022 |
Mexico |
(5) 555-3392 |
(5) 555-7293 |
svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| CHOPS |
Chop-suey Chinese |
Yang Wang |
Owner |
Hauptstr. 29 |
Bern |
| 3012 |
Switzerland |
0452-076545 |
| svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| COMMI |
Comércio Mineiro |
Pedro Afonso |
Sales Associate |
Av. dos Lusíadas, 23 |
São Paulo |
SP |
05432-043 |
Brazil |
(11) 555-7647 |
| svUOq3GsMeZOM1Vc7m7sTRmBFVE/28gBBXRv+pBqRWQ=-~fkYEeZZdQiDa+jNtvHCW3A== |
| EmployeeID |
LastName |
FirstName |
Title |
TitleOfCourtesy |
BirthDate |
HireDate |
Address |
City |
Region |
PostalCode |
Country |
HomePhone |
Extension |
Notes |
ReportsTo |
| 1 |
Horton |
Sylvia |
Sales Representative |
Ms. |
1971-09-04 |
2016-01-26 |
507 - 20th Ave. E.
Apt. 2A |
Seattle |
WA |
98122 |
USA |
(206) 555-9857 |
5467 |
Education includes a BA in psychology from Colorado State University. She also completed "The Art of the Cold Call." Sylvia is a member of Toastmasters International. |
2 |
| 2 |
Neal |
Jenny |
Vice President, Sales |
Dr. |
1954-11-15 |
2016-05-11 |
908 W. Capital Way |
Tacoma |
WA |
98401 |
USA |
(206) 555-9482 |
3457 |
Jenny received her BTS commercial and a Ph.D. in international marketing from the University of Dallas. She is fluent in French and Italian and reads German. She joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales. Jenny is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association. |
|
| 3 |
Conner |
Frank |
Sales Representative |
Mr. |
1966-05-26 |
2012-12-27 |
722 Moss Bay Blvd. |
Kirkland |
WA |
98033 |
USA |
(206) 555-3412 |
3355 |
Frank has a BS degree in chemistry from Boston College. He has also completed a certificate program in food retailing management. Frank was hired as a sales associate and was promoted to sales representative. |
2 |
| 4 |
Collier |
Marlene |
Sales Representative |
Mrs. |
1961-06-15 |
2012-01-28 |
4110 Old Redmond Rd. |
Redmond |
WA |
98052 |
USA |
(206) 555-8122 |
5176 |
Marlene holds a BA in English literature from Concordia College and an MA from the American Institute of Culinary Arts. She was temporarily assigned to the London office before returning to her permanent post in Seattle. |
2 |
| 5 |
Welch |
Kenneth |
Sales Manager |
Mr. |
1957-11-28 |
2017-07-13 |
14 Garrett Hill |
London |
| SW1 8JR |
UK |
(71) 555-4848 |
3453 |
Kenneth Welch graduated from St. Andrews University, Scotland, with a BSC degree. Upon joining the company as a sales representative, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London, where he was promoted to sales manager. Mr. Welch has completed the courses "Successful Telemarketing" and "International Sales Management." He is fluent in French. |
2 |
| 6 |
Webb |
Seth |
Sales Representative |
Mr. |
1966-03-28 |
2010-07-13 |
12 Miner Rd. |
London |
| EC2 7JR |
UK |
(71) 555-7773 |
428 |
Seth is a graduate of Sussex University (MA, economics) and the University of California at Los Angeles (MBA, marketing). He has also taken the courses "Multi-Cultural Selling" and "Time Management for the Sales Professional." He is fluent in Japanese and can read and write French, Portuguese, and Spanish. |
5 |
| 7 |
Rios |
Edith |
Sales Representative |
Mrs. |
1963-02-23 |
2008-09-29 |
99 Winchester Way |
London |
| RG1 9SP |
UK |
(71) 555-5598 |
465 |
Edith Rios served in the Peace Corps and traveled extensively before completing her degree in English at the University of Michigan and then joining the company. After completing a course entitled "Selling in Europe," she was transferred to the London office. |
5 |
| 8 |
Reese |
Jesse |
Inside Sales Coordinator |
Mr. |
1960-10-05 |
2014-11-29 |
4726 - 11th Ave. N.E. |
Seattle |
WA |
98105 |
USA |
(206) 555-1189 |
2344 |
Jesse received a BA in psychology from the University of Washington. He has also completed a course in business French. He reads and writes French. |
2 |
| 9 |
Zimmerman |
Renee |
Sales Representative |
Ms. |
1972-03-28 |
2014-08-11 |
7 Houndstooth Rd. |
London |
| WG2 7LT |
UK |
(71) 555-4444 |
452 |
Renee has a BA degree in English from St. Lawrence College. She is fluent in French and German. |
5 |
| ID |
mSysRowId |
| 1 |
oLIo1alYy1xpMXLQ0KYCKesUAVyNqsZgiKlzYi6TcY8=-~cVLQJNHKdVUZTybiNDRWEQ== |
| OrderID |
CustomerID |
EmployeeID |
OrderDate |
RequiredDate |
ShippedDate |
ShipVia |
Freight |
ShipName |
ShipAddress |
ShipCity |
ShipRegion |
ShipPostalCode |
ShipCountry |
mSysRowId |
| 10254 |
CHOPS |
5 |
2020-05-13 |
2020-06-03 |
2020-06-10 |
1 |
¤ 0.75 |
Wilman Kala |
Keskuskatu 45 |
Helsinki |
| 21240 |
Finland |
|
| 10259 |
CENTC |
4 |
2020-05-20 |
2020-06-10 |
2020-06-12 |
3 |
¤ 38.11 |
Wilman Kala |
Keskuskatu 45 |
Helsinki |
| 21240 |
Finland |
|
| 10265 |
BLONP |
2 |
2020-05-27 |
2020-06-17 |
2020-06-30 |
2 |
¤ 4.62 |
Santé Gourmet |
Erling Skakkes gate 78 |
Stavern |
| 4110 |
Norway |
|
| 10278 |
BERGS |
8 |
2020-06-14 |
2020-07-05 |
2020-07-04 |
2 |
¤ 9.26 |
Victuailles en stock |
2, rue du Commerce |
Lyon |
| 69004 |
France |
|
| 10280 |
BERGS |
2 |
2020-06-16 |
2020-07-07 |
2020-07-31 |
1 |
¤ 47.84 |
Chop-suey Chinese |
Hauptstr. 31 |
Bern |
| 3012 |
Switzerland |
|
| 10289 |
BSBEV |
7 |
2020-06-28 |
2020-07-19 |
2020-07-16 |
2 |
¤ 27.33 |
Seven Seas Imports |
90 Wadhurst Rd. |
London |
| OX15 4NB |
UK |
|
| 10290 |
COMMI |
8 |
2020-06-29 |
2020-07-20 |
2020-07-22 |
1 |
¤ 21.19 |
Queen Cozinha |
Alameda dos Canàrios, 891 |
São Paulo |
SP |
05487-020 |
Brazil |
|
| 10297 |
BLONP |
5 |
2020-07-07 |
2020-07-28 |
2020-07-29 |
2 |
¤ 51.87 |
Godos Cocina Típica |
C/ Romero, 33 |
Sevilla |
| 41101 |
Spain |
|
| 10308 |
ANATR |
7 |
2020-07-21 |
2020-08-11 |
2020-08-12 |
1 |
¤ 32.76 |
Du monde entier |
67, rue des Cinquante Otages |
Nantes |
| 44000 |
France |
|
| 10326 |
BOLID |
4 |
2020-08-12 |
2020-09-02 |
2020-09-01 |
2 |
¤ 25.22 |
Piccolo und mehr |
Geislweg 14 |
Salzburg |
| 5020 |
Austria |
|
| 10331 |
BONAP |
9 |
2020-08-18 |
2020-09-08 |
2020-09-08 |
2 |
¤ 3.04 |
Around the Horn |
Brook Farm
Stratford St. Mary |
Colchester |
Essex |
CO7 6JX |
UK |
|
| 10340 |
BONAP |
1 |
2020-08-31 |
2020-09-21 |
2020-09-26 |
3 |
¤ 117.61 |
Ernst Handel |
Kirchgasse 6 |
Graz |
| 8010 |
Austria |
|
| 10355 |
AROUT |
7 |
2020-09-17 |
2020-10-08 |
2020-10-08 |
1 |
¤ 1.93 |
Lonesome Pine Restaurant |
89 Chiaroscuro Rd. |
Portland |
OR |
97219 |
USA |
|
| 10360 |
BLONP |
4 |
2020-09-24 |
2020-10-15 |
2020-10-20 |
1 |
¤ 38.51 |
QUICK-Stop |
Taucherstraße 10 |
Cunewalde |
| 01307 |
Germany |
|
| 10362 |
BONAP |
3 |
2020-09-27 |
2020-10-18 |
2020-10-16 |
1 |
¤ 7.09 |
Blondel père et fils |
24, place Kléber |
Strasbourg |
| 67000 |
France |
|
| 10365 |
ANTON |
3 |
2020-09-29 |
2020-10-20 |
2020-10-20 |
1 |
¤ 143.28 |
Seven Seas Imports |
90 Wadhurst Rd. |
London |
| OX15 4NB |
UK |
|
| 10370 |
CHOPS |
8 |
2020-10-05 |
2020-10-26 |
2020-11-14 |
1 |
¤ 47.09 |
Franchi S.p.A. |
Via Monte Bianco 34 |
Torino |
| 10100 |
Italy |
|
| 10383 |
AROUT |
8 |
2020-10-18 |
2020-11-08 |
2020-11-05 |
3 |
¤ 4.33 |
Laughing Bacchus Wine Cellars |
2319 Elm St. |
Vancouver |
BC |
V3F 2K1 |
Canada |
|
| 10384 |
BERGS |
3 |
2020-10-18 |
2020-11-08 |
2020-11-07 |
1 |
¤ 174.05 |
Rattlesnake Canyon Grocery |
2817 Milton Dr. |
Albuquerque |
NM |
87110 |
USA |
|
| 10389 |
BOTTM |
4 |
2020-10-22 |
2020-11-12 |
2020-11-11 |
2 |
¤ 53.83 |
Blauer See Delikatessen |
Forsterstr. 57 |
Mannheim |
| 68306 |
Germany |
|
| 10410 |
BOTTM |
3 |
2020-11-12 |
2020-12-03 |
2020-12-03 |
1 |
¤ 0.82 |
Wilman Kala |
Keskuskatu 45 |
Helsinki |
| 21240 |
Finland |
|
| 10411 |
BOTTM |
9 |
2020-11-12 |
2020-12-03 |
2020-12-09 |
1 |
¤ 141.16 |
Save-a-lot Markets |
187 Suffolk Ln. |
Boise |
ID |
83720 |
USA |
|
| 10431 |
BOTTM |
4 |
2020-12-02 |
2020-12-23 |
2020-12-26 |
1 |
¤ 104.47 |
Queen Cozinha |
Alameda dos Canàrios, 891 |
São Paulo |
SP |
05487-020 |
Brazil |
|
| 10436 |
BLONP |
3 |
2020-12-08 |
2020-12-29 |
2020-12-30 |
3 |
¤ 36.71 |
Hanari Carnes |
Rua do Paço, 67 |
Rio de Janeiro |
RJ |
05454-876 |
Brazil |
|
| 10444 |
BERGS |
3 |
2020-12-15 |
2021-01-05 |
2021-01-09 |
1 |
¤ 14.01 |
Bottom-Dollar Markets |
23 Tsawassen Blvd. |
Tsawassen |
BC |
T2F 8M4 |
Canada |
|
| 10445 |
BERGS |
3 |
2020-12-16 |
2021-01-06 |
2021-01-08 |
3 |
¤ 47.59 |
Wellington Importadora |
Rua do Mercado, 12 |
Resende |
SP |
08737-363 |
Brazil |
|
| 10449 |
BLONP |
3 |
2020-12-21 |
2021-01-11 |
2021-01-18 |
2 |
¤ 657.54 |
Save-a-lot Markets |
187 Suffolk Ln. |
Boise |
ID |
83720 |
USA |
|
| 10453 |
AROUT |
1 |
2020-12-24 |
2021-01-14 |
2021-01-21 |
2 |
¤ 32.37 |
Berglunds snabbköp |
Berguvsvägen 8 |
Luleå |
| S-958 22 |
Sweden |
|
| 10466 |
COMMI |
4 |
2021-01-06 |
2021-01-27 |
2021-02-03 |
2 |
¤ 31.89 |
QUICK-Stop |
Taucherstraße 10 |
Cunewalde |
| 01307 |
Germany |
|
| 10470 |
BONAP |
4 |
2020-01-10 |
2020-01-31 |
2020-02-07 |
1 |
¤ 411.88 |
Ernst Handel |
Kirchgasse 6 |
Graz |
| 8010 |
Austria |
|
| 10471 |
BSBEV |
2 |
2020-01-10 |
2020-01-31 |
2020-02-07 |
2 |
¤ 76.33 |
Magazzini Alimentari Riuniti |
Via Ludovico il Moro 22 |
Bergamo |
| 24100 |
Italy |
|
| 10484 |
BSBEV |
3 |
2020-01-23 |
2020-02-13 |
2020-02-20 |
2 |
¤ 62.22 |
Toms Spezialitäten |
Luisenstr. 48 |
Münster |
| 44087 |
Germany |
|
| 10492 |
BOTTM |
3 |
2020-02-16 |
2020-03-09 |
2020-02-26 |
3 |
¤ 135.63 |
Old World Delicatessen |
2743 Bering St. |
Anchorage |
AK |
99508 |
USA |
|
| 10494 |
COMMI |
4 |
2020-02-14 |
2020-03-07 |
2020-02-24 |
1 |
¤ 0.48 |
Reggiani Caseifici |
Strada Provinciale 124 |
Reggio Emilia |
| 42100 |
Italy |
|
| 10501 |
BLAUS |
9 |
2020-02-21 |
2020-03-14 |
2020-03-03 |
1 |
¤ 62.52 |
Que Delícia |
Rua da Panificadora, 12 |
Rio de Janeiro |
RJ |
02389-673 |
Brazil |
|
| 10507 |
ANTON |
7 |
2020-02-26 |
2020-03-19 |
2020-03-08 |
2 |
¤ 244.79 |
Berglunds snabbköp |
Berguvsvägen 8 |
Luleå |
| S-958 22 |
Sweden |
|
| 10509 |
BLAUS |
4 |
2020-03-05 |
2020-03-26 |
2020-03-16 |
3 |
¤ 24.49 |
Save-a-lot Markets |
187 Suffolk Ln. |
Boise |
ID |
83720 |
USA |
|
| 10511 |
BONAP |
4 |
2020-02-25 |
2020-03-18 |
2020-03-07 |
2 |
¤ 249.06 |
QUICK-Stop |
Taucherstraße 10 |
Cunewalde |
| 01307 |
Germany |
|
| 10519 |
CHOPS |
5 |
2020-03-07 |
2020-03-28 |
2020-03-18 |
3 |
¤ 3.10 |
Familia Arquibaldo |
Rua Orós, 92 |
São Paulo |
SP |
05442-030 |
Brazil |
|
| 10521 |
CACTU |
8 |
2020-03-08 |
2020-03-29 |
2020-03-19 |
2 |
¤ 0.78 |
Die Wandernde Kuh |
Adenauerallee 900 |
Stuttgart |
| 70563 |
Germany |
|
| 10524 |
BERGS |
1 |
2020-03-14 |
2020-04-04 |
2020-03-24 |
3 |
¤ 44.12 |
Königlich Essen |
Maubelstr. 90 |
Brandenburg |
| 14776 |
Germany |
|
| 10525 |
BONAP |
1 |
2020-03-30 |
2020-04-20 |
2020-04-09 |
2 |
¤ 16.71 |
Bon app' |
12, rue des Bouchers |
Marseille |
| 13008 |
France |
|
| 10535 |
ANTON |
4 |
2020-03-28 |
2020-04-18 |
2020-04-07 |
3 |
¤ 194.67 |
QUICK-Stop |
Taucherstraße 10 |
Cunewalde |
| 01307 |
Germany |
|
| 10538 |
BSBEV |
9 |
2020-03-23 |
2020-04-13 |
2020-04-02 |
2 |
¤ 29.76 |
Ricardo Adocicados |
Av. Copacabana, 267 |
Rio de Janeiro |
RJ |
02389-890 |
Brazil |
|
| 10539 |
BSBEV |
7 |
2020-03-30 |
2020-04-20 |
2020-04-09 |
2 |
¤ 58.59 |
Wartian Herkku |
Torikatu 38 |
Oulu |
| 90110 |
Finland |
|
| 10558 |
AROUT |
1 |
2020-04-17 |
2020-05-08 |
2020-04-27 |
3 |
¤ 45.59 |
B's Beverages |
Fauntleroy Circus |
London |
| EC2 5NT |
UK |
|
| 10559 |
BLONP |
8 |
2020-04-20 |
2020-05-11 |
2020-04-30 |
2 |
¤ 4.42 |
Great Lakes Food Market |
2732 Baker Blvd. |
Eugene |
OR |
97403 |
USA |
|
| 10566 |
BLONP |
9 |
2020-04-25 |
2020-05-16 |
2020-05-05 |
3 |
¤ 16.37 |
Island Trading |
Garden House
Crowther Way |
Cowes |
Isle of Wight |
PO31 7PJ |
UK |
|
| 10572 |
BERGS |
3 |
2020-05-02 |
2020-05-23 |
2020-05-12 |
2 |
¤ 339.22 |
Piccolo und mehr |
Geislweg 14 |
Salzburg |
| 5020 |
Austria |
|
| 10573 |
ANTON |
7 |
2020-04-27 |
2020-05-18 |
2020-05-07 |
2 |
¤ 17.68 |
Magazzini Alimentari Riuniti |
Via Ludovico il Moro 22 |
Bergamo |
| 24100 |
Italy |
|
SELECT Employees.EmployeeID, [LastName] & ", " & [FirstName] AS Name
FROM Employees
ORDER BY Employees.LastName, Employees.FirstName;
SELECT DISTINCTROW *
FROM Orders;
SELECT DISTINCTROW *
FROM Employees;
k2llllaag
