Nancy Davolio
Employees row where EmployeeID = 1. Blue values are foreign keys: click one to jump to the row it points at.
Record
- EmployeeIDPK
- 1
- LastName
- Davolio
- FirstName
- Nancy
- Title
- Sales Representative
- TitleOfCourtesy
- Ms.
- BirthDate
- 1948-12-08
- HireDate
- 1992-05-01
- Address
- 507 - 20th Ave. E.Apt. 2A
- City
- Seattle
- Region
- WA
- PostalCode
- 98122
- Country
- USA
- HomePhone
- (206) 555-9857
- Extension
- 5467
- Photo
BLOB, 21626 bytes. The image is a Windows bitmap behind a 78-byte OLE header that Microsoft Access added; it is shown here converted to PNG.- Notes
- Education includes a BA in psychology from Colorado State University in 1970. She also completed "The Art of the Cold Call." Nancy is a member of Toastmasters International.
- ReportsToFK
- 2
- PhotoPath
- http://accweb/emmployees/davolio.bmp
Employees via ReportsTo
No Employees rows point at this employees row.
Orders via EmployeeID
| OrderID | CustomerID | EmployeeID | OrderDate | RequiredDate | ShippedDate | ShipVia | Freight | ShipName | ShipAddress | ShipCity | ShipRegion | ShipPostalCode | ShipCountry |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10258 | ERNSH | 1 | 1996-07-17 | 1996-08-14 | 1996-07-23 | 1 | 140.51 | Ernst Handel | Kirchgasse 6 | Graz | NULL | 8010 | Austria |
| 10270 | WARTH | 1 | 1996-08-01 | 1996-08-29 | 1996-08-02 | 1 | 136.54 | Wartian Herkku | Torikatu 38 | Oulu | NULL | 90110 | Finland |
| 10275 | MAGAA | 1 | 1996-08-07 | 1996-09-04 | 1996-08-09 | 1 | 26.93 | Magazzini Alimentari Riuniti | Via Ludovico il Moro 22 | Bergamo | NULL | 24100 | Italy |
| 10285 | QUICK | 1 | 1996-08-20 | 1996-09-17 | 1996-08-26 | 2 | 76.83 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10292 | TRADH | 1 | 1996-08-28 | 1996-09-25 | 1996-09-02 | 2 | 1.35 | Tradiçao Hipermercados | Av. Inês de Castro, 414 | Sao Paulo | SP | 05634-030 | Brazil |
| 10293 | TORTU | 1 | 1996-08-29 | 1996-09-26 | 1996-09-11 | 3 | 21.18 | Tortuga Restaurante | Avda. Azteca 123 | México D.F. | NULL | 05033 | Mexico |
| 10304 | TORTU | 1 | 1996-09-12 | 1996-10-10 | 1996-09-17 | 2 | 63.79 | Tortuga Restaurante | Avda. Azteca 123 | México D.F. | NULL | 05033 | Mexico |
| 10306 | ROMEY | 1 | 1996-09-16 | 1996-10-14 | 1996-09-23 | 3 | 7.56 | Romero y tomillo | Gran Vía, 1 | Madrid | NULL | 28001 | Spain |
| 10311 | DUMON | 1 | 1996-09-20 | 1996-10-04 | 1996-09-26 | 3 | 24.69 | Du monde entier | 67, rue des Cinquante Otages | Nantes | NULL | 44000 | France |
| 10314 | RATTC | 1 | 1996-09-25 | 1996-10-23 | 1996-10-04 | 2 | 74.16 | Rattlesnake Canyon Grocery | 2817 Milton Dr. | Albuquerque | NM | 87110 | USA |
| 10316 | RATTC | 1 | 1996-09-27 | 1996-10-25 | 1996-10-08 | 3 | 150.15 | Rattlesnake Canyon Grocery | 2817 Milton Dr. | Albuquerque | NM | 87110 | USA |
| 10325 | KOENE | 1 | 1996-10-09 | 1996-10-23 | 1996-10-14 | 3 | 64.86 | Königlich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10340 | BONAP | 1 | 1996-10-29 | 1996-11-26 | 1996-11-08 | 3 | 166.31 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10351 | ERNSH | 1 | 1996-11-11 | 1996-12-09 | 1996-11-20 | 1 | 162.33 | Ernst Handel | Kirchgasse 6 | Graz | NULL | 8010 | Austria |
| 10357 | LILAS | 1 | 1996-11-19 | 1996-12-17 | 1996-12-02 | 3 | 34.88 | LILA-Supermercado | Carrera 52 con Ave. Bolívar #65-98 Llano Largo | Barquisimeto | Lara | 3508 | Venezuela |
| 10361 | QUICK | 1 | 1996-11-22 | 1996-12-20 | 1996-12-03 | 2 | 183.17 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10364 | EASTC | 1 | 1996-11-26 | 1997-01-07 | 1996-12-04 | 1 | 71.97 | Eastern Connection | 35 King George | London | NULL | WX3 6FW | UK |
| 10371 | LAMAI | 1 | 1996-12-03 | 1996-12-31 | 1996-12-24 | 1 | 0.45 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10374 | WOLZA | 1 | 1996-12-05 | 1997-01-02 | 1996-12-09 | 3 | 3.94 | Wolski Zajazd | ul. Filtrowa 68 | Warszawa | NULL | 01-012 | Poland |
| 10376 | MEREP | 1 | 1996-12-09 | 1997-01-06 | 1996-12-13 | 2 | 20.39 | Mère Paillarde | 43 rue St. Laurent | Montréal | Québec | H1J 1C3 | Canada |
| 10377 | SEVES | 1 | 1996-12-09 | 1997-01-06 | 1996-12-13 | 3 | 22.21 | Seven Seas Imports | 90 Wadhurst Rd. | London | NULL | OX15 4NB | UK |
| 10385 | SPLIR | 1 | 1996-12-17 | 1997-01-14 | 1996-12-23 | 2 | 30.96 | Split Rail Beer & Ale | P.O. Box 555 | Lander | WY | 82520 | USA |
| 10387 | SANTG | 1 | 1996-12-18 | 1997-01-15 | 1996-12-20 | 2 | 93.63 | Santé Gourmet | Erling Skakkes gate 78 | Stavern | NULL | 4110 | Norway |
| 10393 | SAVEA | 1 | 1996-12-25 | 1997-01-22 | 1997-01-03 | 3 | 126.56 | Save-a-lot Markets | 187 Suffolk Ln. | Boise | ID | 83720 | USA |
| 10394 | HUNGC | 1 | 1996-12-25 | 1997-01-22 | 1997-01-03 | 3 | 30.34 | Hungry Coyote Import Store | City Center Plaza 516 Main St. | Elgin | OR | 97827 | USA |
| 10396 | FRANK | 1 | 1996-12-27 | 1997-01-10 | 1997-01-06 | 3 | 135.35 | Frankenversand | Berliner Platz 43 | München | NULL | 80805 | Germany |
| 10400 | EASTC | 1 | 1997-01-01 | 1997-01-29 | 1997-01-16 | 3 | 83.93 | Eastern Connection | 35 King George | London | NULL | WX3 6FW | UK |
| 10401 | RATTC | 1 | 1997-01-01 | 1997-01-29 | 1997-01-10 | 1 | 12.51 | Rattlesnake Canyon Grocery | 2817 Milton Dr. | Albuquerque | NM | 87110 | USA |
| 10405 | LINOD | 1 | 1997-01-06 | 1997-02-03 | 1997-01-22 | 1 | 34.82 | LINO-Delicateses | Ave. 5 de Mayo Porlamar | I. de Margarita | Nueva Esparta | 4980 | Venezuela |
| 10453 | AROUT | 1 | 1997-02-21 | 1997-03-21 | 1997-02-26 | 2 | 25.36 | Around the Horn | Brook Farm Stratford St. Mary | Colchester | Essex | CO7 6JX | UK |
| 10461 | LILAS | 1 | 1997-02-28 | 1997-03-28 | 1997-03-05 | 3 | 148.61 | LILA-Supermercado | Carrera 52 con Ave. Bolívar #65-98 Llano Largo | Barquisimeto | Lara | 3508 | Venezuela |
| 10465 | VAFFE | 1 | 1997-03-05 | 1997-04-02 | 1997-03-14 | 3 | 145.04 | Vaffeljernet | Smagsloget 45 | Århus | NULL | 8200 | Denmark |
| 10469 | WHITC | 1 | 1997-03-10 | 1997-04-07 | 1997-03-14 | 1 | 60.18 | White Clover Markets | 1029 - 12th Ave. S. | Seattle | WA | 98124 | USA |
| 10473 | ISLAT | 1 | 1997-03-13 | 1997-03-27 | 1997-03-21 | 3 | 16.37 | Island Trading | Garden House Crowther Way | Cowes | Isle of Wight | PO31 7PJ | UK |
| 10482 | LAZYK | 1 | 1997-03-21 | 1997-04-18 | 1997-04-10 | 3 | 7.48 | Lazy K Kountry Store | 12 Orchestra Terrace | Walla Walla | WA | 99362 | USA |
| 10486 | HILAA | 1 | 1997-03-26 | 1997-04-23 | 1997-04-02 | 2 | 30.53 | HILARION-Abastos | Carrera 22 con Ave. Carlos Soublette #8-35 | San Cristóbal | Táchira | 5022 | Venezuela |
| 10508 | OTTIK | 1 | 1997-04-16 | 1997-05-14 | 1997-05-13 | 2 | 4.99 | Ottilies Käseladen | Mehrheimerstr. 369 | Köln | NULL | 50739 | Germany |
| 10524 | BERGS | 1 | 1997-05-01 | 1997-05-29 | 1997-05-07 | 2 | 244.79 | Berglunds snabbköp | Berguvsvägen 8 | Luleå | NULL | S-958 22 | Sweden |
| 10525 | BONAP | 1 | 1997-05-02 | 1997-05-30 | 1997-05-23 | 2 | 11.06 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10537 | RICSU | 1 | 1997-05-14 | 1997-05-28 | 1997-05-19 | 1 | 78.85 | Richter Supermarkt | Starenweg 5 | Genève | NULL | 1204 | Switzerland |
| 10542 | KOENE | 1 | 1997-05-20 | 1997-06-17 | 1997-05-26 | 3 | 10.95 | Königlich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10546 | VICTE | 1 | 1997-05-23 | 1997-06-20 | 1997-05-27 | 3 | 194.72 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10558 | AROUT | 1 | 1997-06-04 | 1997-07-02 | 1997-06-10 | 2 | 72.97 | Around the Horn | Brook Farm Stratford St. Mary | Colchester | Essex | CO7 6JX | UK |
| 10562 | REGGC | 1 | 1997-06-09 | 1997-07-07 | 1997-06-12 | 1 | 22.95 | Reggiani Caseifici | Strada Provinciale 124 | Reggio Emilia | NULL | 42100 | Italy |
| 10567 | HUNGO | 1 | 1997-06-12 | 1997-07-10 | 1997-06-17 | 1 | 33.97 | Hungry Owl All-Night Grocers | 8 Johnstown Road | Cork | Co. Cork | NULL | Ireland |
| 10579 | LETSS | 1 | 1997-06-25 | 1997-07-23 | 1997-07-04 | 2 | 13.73 | Let's Stop N Shop | 87 Polk St. Suite 5 | San Francisco | CA | 94117 | USA |
| 10587 | QUEDE | 1 | 1997-07-02 | 1997-07-30 | 1997-07-09 | 1 | 62.52 | Que Delícia | Rua da Panificadora, 12 | Rio de Janeiro | RJ | 02389-673 | Brazil |
| 10591 | VAFFE | 1 | 1997-07-07 | 1997-07-21 | 1997-07-16 | 1 | 55.92 | Vaffeljernet | Smagsloget 45 | Århus | NULL | 8200 | Denmark |
| 10598 | RATTC | 1 | 1997-07-14 | 1997-08-11 | 1997-07-18 | 3 | 44.42 | Rattlesnake Canyon Grocery | 2817 Milton Dr. | Albuquerque | NM | 87110 | USA |
| 10604 | FURIB | 1 | 1997-07-18 | 1997-08-15 | 1997-07-29 | 1 | 7.46 | Furia Bacalhau e Frutos do Mar | Jardim das rosas n. 32 | Lisboa | NULL | 1675 | Portugal |