MS Access work
| ID | Surname | Given | Title | Department | Hired | Salary | Bonus | Gender | Vacation | Education |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Kitching | Cheralyn | Researcher | Research | 8/23/03 | ¤ 42,750.00 | F | 10.0 | B.Sc. | |
| 2 | Jaimeson | Aaron | Clerk | Marketing | 8/11/02 | ¤ 40,650.00 | 0.01 | M | 10.0 | B.Com. |
| 3 | Neumann | Kenyon | Editor | Production | 8/20/85 | ¤ 65,400.00 | M | 25.0 | B.Sc. | |
| 4 | Kunicki | Barbara | Clerk | Administration | 11/25/93 | ¤ 32,850.00 | F | 15.0 | ||
| 5 | Killian | Connie | Publisher | Management | 8/24/86 | ¤ 70,350.00 | F | 25.0 | B.Admin. | |
| 6 | Turgeon | Luce | Librarian | Administration | 12/13/04 | ¤ 34,650.00 | F | 15.0 | ||
| 7 | Buggey | Diana | Salesperson | Marketing | 9/23/89 | ¤ 75,000.00 | 0.03 | F | 20.0 | B.Admin. |
| 8 | McRae | Gail | Secretary | Management | 5/11/83 | ¤ 46,500.00 | F | 15.0 | ||
| 9 | Alexander | Mandy | Manager | Administration | 2/19/02 | ¤ 54,450.00 | F | 10.0 | B.A. | |
| 10 | Harris | Mindy | Researcher | Research | 2/8/88 | ¤ 55,350.00 | F | 20.0 | B.Sc. | |
| 11 | Souder | Robyn | Salesperson | Marketing | 4/7/97 | ¤ 63,750.00 | 0.03 | F | 15.0 | B.Com. |
| 12 | Stedman | Simon | Salesperson | Marketing | 6/18/94 | ¤ 67,500.00 | 0.03 | M | 15.0 | B.Admin. |
| 13 | Huber | Tessa | Foreman | Production | 3/24/91 | ¤ 73,200.00 | F | 20.0 | ||
| 14 | Cortez | Anna | Controller | Finance | 3/6/03 | ¤ 101,250.00 | F | 25.0 | B.A. | |
| 15 | Bradley | Brenda | Accountant | Finance | 11/23/92 | ¤ 60,000.00 | F | 20.0 | ||
| 16 | Strange | Douglas | Technician | Research | 6/22/94 | ¤ 54,750.00 | M | 15.0 | ||
| 17 | Palfrey | Ernie | Operator | Production | 4/13/92 | ¤ 63,750.00 | M | 15.0 | B.A. | |
| 18 | Hildebrand | Robert | Researcher | Research | 2/22/89 | ¤ 60,000.00 | M | 20.0 | B.A. | |
| 19 | Alomar | Sandra | Salesperson | Marketing | 12/21/03 | ¤ 78,750.00 | 0.03 | F | 20.0 | B.Com. |
| 20 | Read | Susan | Analyst | Research | 10/4/04 | ¤ 30,900.00 | F | 10.0 | ||
| 21 | Chow | Tina | Editor | Production | 10/27/93 | ¤ 63,150.00 | F | 15.0 | ||
| 22 | Jones | Elliot | Secretary | Administration | 2/2/99 | ¤ 42,150.00 | M | 10.0 | ||
| 23 | Johnson | Erika | Vice President | Finance | 12/23/87 | ¤ 99,450.00 | F | 20.0 | B.Com. | |
| 24 | Beaver | Geoffrey | Clerk | Administration | 7/13/88 | ¤ 37,200.00 | M | 20.0 | ||
| 25 | Pritchard | Samuel | Editor | Production | 9/19/93 | ¤ 63,150.00 | M | 15.0 | B.A. | |
| 26 | Instance | Stewart | Technician | Research | 8/18/97 | ¤ 56,250.00 | M | 15.0 | B.Sc. | |
| 27 | Fuller | Tony | Clerk | Administration | 12/26/02 | ¤ 32,850.00 | M | 15.0 | ||
| 28 | Johnson | Becky | Manager | Research | 5/23/95 | ¤ 71,250.00 | F | 15.0 | Ph.D. | |
| 29 | Robinson | Chad | Accountant | Finance | 2/15/88 | ¤ 63,750.00 | M | 20.0 | B.Sc. | |
| 30 | Akelaitis | Eric | Vice President | Management | 11/12/88 | ¤ 125,700.00 | M | 30.0 | MBA | |
| 31 | Whitehale | Gayle | Publisher | Production | 7/19/93 | ¤ 112,500.00 | F | 30.0 | M.Sc. | |
| 32 | Li | Jenni | Editor | Production | 12/21/99 | ¤ 60,000.00 | F | 15.0 | ||
| 33 | Fernandez | Rosa | Salesperson | Marketing | 9/29/93 | ¤ 86,250.00 | 0.03 | F | 25.0 | B.A. |
| 34 | O'Connell | Simon | Manager | Marketing | 9/29/93 | ¤ 78,750.00 | 0.03 | M | 20.0 | B.Com. |
| 35 | Chong | Tony | Editor | Production | 12/17/91 | ¤ 65,700.00 | M | 20.0 | B.A. | |
| 36 | Klimek | Bob | President | Management | 5/23/91 | ¤ 120,000.00 | 0.05 | M | 30.0 | MBA |
| 37 | Seinfeld | Casey | Vice President | Marketing | 8/20/84 | ¤ 112,500.00 | 0.05 | M | 30.0 | B.Com. |
| 38 | MacDonald | Jeff | Secretary | Management | 10/3/95 | ¤ 41,250.00 | M | 10.0 | B.Com. | |
| 39 | Windsor | Jeremy | Manager | Production | 5/19/97 | ¤ 78,750.00 | M | 15.0 | Ph.D. | |
| 40 | Stringer | Paul | Researcher | Research | 1/4/87 | ¤ 60,000.00 | M | 25.0 | ||
| 41 | Weirnicke | Brandi | Clerk | Administration | 4/19/89 | ¤ 41,250.00 | F | 20.0 | ||
| 42 | White | Bryan | Researcher | Research | 7/12/92 | ¤ 45,000.00 | M | 15.0 | ||
| 43 | Wong | James | Operator | Production | 9/27/91 | ¤ 65,100.00 | M | 20.0 | ||
| 44 | Park | Joonhae | Librarian | Research | 7/21/97 | ¤ 31,950.00 | F | 15.0 | ||
| 45 | Hernandez | Pete | Researcher | Marketing | 10/31/04 | ¤ 40,950.00 | 0.01 | M | 10.0 | B.A. |
| 46 | Bouchard | Guy | Publisher | Production | 7/21/89 | ¤ 67,950.00 | M | 20.0 | B.A. | |
| 47 | Mohr | Jude | Clerk | Marketing | 12/8/93 | ¤ 45,000.00 | F | 15.0 | ||
| 48 | Tamahashi | Phillip | Publisher | Management | 11/24/02 | ¤ 101,250.00 | 0.05 | M | 15.0 | Ph.D. |
| 49 | MacPherson | William | Editor | Research | 6/15/97 | ¤ 56,250.00 | 0.01 | M | 15.0 | M.Sc. |
| Code | Topic | Title | PubYear | Media | Grade | Cost |
|---|---|---|---|---|---|---|
| WB1024-11 | Mathematics | Ratios | 2009.0 | WEB | 10.0 | ¤ 24.00 |
| CD826-01 | Mathematics | Measurement | 2007.0 | DVD | 8.0 | ¤ 24.00 |
| DV1100-01 | Geography | What makes Rain? | 2006.0 | DVD | 11.0 | ¤ 22.00 |
| VH1011-03 | Geography | Ice and Sand | 2001.0 | VHS | 10.0 | ¤ 10.00 |
| WB1154-05 | Business | The Cash Flow Statement | 2007.0 | WEB | 11.0 | ¤ 23.00 |
| VH1142-01 | Language | James Joyce | 2003.0 | VHS | 11.0 | ¤ 12.00 |
| BD6974-78 | Business | Marketing Research | 2009.0 | BD | 11.0 | ¤ 32.00 |
| VH404-01 | Science | What is a Liquid? | 2001.0 | VHS | 4.0 | ¤ 10.00 |
| DV945-60 | Business | Managing Your Budget | 2001.0 | DVD | 9.0 | ¤ 13.50 |
| VH590-20 | Science | What is Light? | 2002.0 | VHS | 5.0 | ¤ 12.00 |
| CD1232-01 | Mathematics | The Hyperbola | 2004.0 | CDROM | 12.0 | ¤ 28.00 |
| CD965-01 | Language | Greek Myths | 2004.0 | CDROM | 9.0 | ¤ 34.00 |
| CD977-02 | Business | The Income Statement | 2000.0 | CDROM | 9.0 | ¤ 27.50 |
| WB5464-44 | Computing | Microsoft Project 2010 | 2010.0 | WEB | 12.0 | ¤ 19.00 |
| DV1105-01 | Geography | How Level is Sea Level? | 2005.0 | DVD | 11.0 | ¤ 32.00 |
| BD6045-12 | Language | George Bernard Shaw | 2009.0 | BD | 10.0 | ¤ 27.00 |
| WB1017-01 | Language | Edgar Allan Poe | 2006.0 | WEB | 10.0 | ¤ 16.00 |
| WB1209-01 | Language | Herman Melville | 2004.0 | WEB | 12.0 | ¤ 10.00 |
| DV2854-44 | Computing | Microsoft Access 2010 | 2010.0 | DVD | 10.0 | ¤ 23.00 |
| VH412-01 | Science | What is a Solid? | 2002.0 | VHS | 4.0 | ¤ 10.00 |
| VH640-02 | Science | What is Electricity? | 2004.0 | CDROM | 6.0 | ¤ 14.50 |
| BD9464-55 | Science | Global Warming | 2013.0 | BD | 7.0 | ¤ 26.00 |
| CD1234-02 | Mathematics | The Parabola | 2004.0 | CDROM | 12.0 | ¤ 28.00 |
| DV1022-01 | Mathematics | Estimation | 2006.0 | DVD | 10.0 | ¤ 40.00 |
| DV762-01 | Science | What is an Animal? | 2006.0 | DVD | 7.0 | ¤ 24.00 |
| VH1112-04 | Mathematics | The Intercepts | 2003.0 | VHS | 11.0 | ¤ 12.00 |
| DV1005-05 | Business | The Balance Sheet | 2011.0 | DVD | 10.0 | ¤ 22.00 |
| DV1230-02 | Language | The Lottery | 2004.0 | DVD | 12.0 | ¤ 44.00 |
| VH502-01 | Science | What is a Gas? | 2001.0 | VHS | 5.0 | ¤ 10.00 |
| DV2541-11 | Computing | Microsoft Excel 2010 | 2010.0 | DVD | 10.0 | ¤ 15.00 |
| BD6599-05 | Mathematics | Data Visualization | 2013.0 | BD | 12.0 | ¤ 55.00 |
| WB923-03 | Geography | Volcanoes | 2009.0 | WEB | 9.0 | ¤ 12.00 |
| CD810-01 | Science | What Makes Weather? | 2005.0 | CDROM | 8.0 | ¤ 18.50 |
| WB994-05 | Business | Journal Entries and Ledgers | 2008.0 | WEB | 11.0 | ¤ 24.00 |
| BD9774-54 | Language | Bibliographies and More | 2011.0 | BD | 12.0 | ¤ 22.00 |
| DV1054-01 | Language | George Orwell | 2007.0 | DVD | 10.0 | ¤ 40.00 |
| DV780-10 | Science | What is a Mammal? | 2008.0 | DVD | 7.0 | ¤ 32.00 |
| DV879-65 | Business | Debits and Credits | 2011.0 | DVD | 8.0 | ¤ 19.50 |
| DV2542-11 | Computing | Microsoft Word 2010 | 2010.0 | DVD | 10.0 | ¤ 18.00 |
| VH1132-01 | Language | Shakespeare | 2003.0 | VHS | 11.0 | ¤ 12.00 |
| VH511-01 | Science | What is Color? | 2002.0 | VHS | 5.0 | ¤ 12.00 |
| DV912-02 | Business | Keyboarding Basics | 2004.0 | DVD | 9.0 | ¤ 12.50 |
| VH933-02 | Language | Beowulf | 2005.0 | CDROM | 9.0 | ¤ 10.00 |
| CD820-03 | Science | What Makes Wind? | 2006.0 | CDROM | 8.0 | ¤ 22.00 |
| WB1091-01 | Geography | How Solid is Rock? | 2012.0 | WEB | 10.0 | ¤ 27.50 |
| DV816-02 | Mathematics | Circles | 2006.0 | DVD | 8.0 | ¤ 32.00 |
| VH1140-10 | Mathematics | The Equalizer | 2002.0 | VHS | 11.0 | ¤ 14.50 |
| VH403-02 | Science | What is Heat? | 2007.0 | DVD | 4.0 | ¤ 10.00 |
| VH115-06 | Business | How to write a cheque | 2004.0 | VHS | 9.0 | ¤ 12.00 |
| BD6549-01 | Geography | Indiana: America's Heartland | 2012.0 | BD | 10.0 | ¤ 19.50 |