Table of Contents
Part I: Spreadsheet
Case 1: Milligan’s Backyard Storage Kits.................................................................. 1
Case 2: Piedmont Trailer Manufacturing Company................................................... 7
Case 3: Francisco’s Lawn Care................................................................................ 14
Case 4: Maxi’s Grocery Mart...................................................................................... 19
Case 5: Klein Technology Seminars......................................................................... 25
Case 6: Terrell & Terrell Property Management, Inc................................................ 37
Case 7: Mark’s Collectibles, Inc................................................................................. 43
Case 8: Megan Davis Convention Center................................................................ 48
Case 9: BJR Investments, Inc. ................................................................................... 53
Case 10: Madison’s Department Store....................................................................... 60
Case 11: Lake West University.................................................................................... 67
Case 12: Baylee Byrd Playsets, Inc............................................................................. 72
Case 13: Edmund Grant Pharmaceutical Company.................................................. 79
Case 14: Molly Mackenzie Boat Marina...................................................................... 86
Part II: Database
Case 15: KoKo’s Canine Pet Club.............................................................................. 97
Case 16: Susan’s Special Sauces............................................................................ 106
Case 17: Granny Joan’s Cookies.............................................................................. 116
Case 18: Friends In Need........................................................................................... 129
Case 19: Second Time Around Movies.................................................................... 138
Case 20: Elusive Moose RV Park............................................................................. 148
Case 21: Tyrone’s Arcade Games............................................................................ 158
Case 22: Keller Industries........................................................................................... 168
Case 23: ABC Inc.’s Health Benefits......................................................................... 180
Case 24: Wright Brothers’ Airport Shuttle Service................................................... 191
Case 25: Natalie’s Tours............................................................................................ 201
Case 26: Healthy Plant and Tree Nursery................................................................. 212
Case 27: Franklin University: Student Scholarship Management......................... 220
Case 28: Letty’s Costume Rentals............................................................................ 234
Part III: Web Page Development
Case 29: Mountain View Dental Clinic...................................................................... 244
Case 30: Family Veterinary Pet Care Clinic............................................................. 248
Part IV: Tutorials
Spreadsheet Tutorial.................................................................................................... 252
Database Tutorial......................................................................................................... 291
Web Page Tutorial........................................................................................................ 344
Part V: Glossaries
Spreadsheet Glossary.................................................................................................. 380
Database Glossary....................................................................................................... 417
Web Page Glossary..................................................................................................... 461