Table of Contents
PART 1 DEVELOPING A DATABASE APPLICATION 1 CHAPTER 1 Access—Tables and Forms 3
Case 1 Up the Hill Bakery 3
Case 2 Dr. Garrett’s Chiropractic Office 10
Case 3 Home Town Realty 16
CHAPTER 2 Access—Queries and Reports 24
Case 4 Up the Hill Bakery 24
Case 5 Earth Foods Grocery Store 33
Case 6 Destination Corporate Event
Planning, Inc. 40
CHAPTER 3 Access—Advanced Queries and Reports 47
Case 7 Up the Hill Bakery 47
Case 8 Sun and Beach Clothing 55
Case 9 Just Breathe Yoga Center 62
PART 2 DEVELOPING A SPREADSHEET APPLICATION 79
CHAPTER 4 Excel—Spreadsheet Basics 81
Case 10 Up the Hill Bakery 81
Case 11 Celebrations for Charity 87
Case 12 Dr. William Gardner’s Dental Office 92
CHAPTER 5 Excel—Intermediate Design Techniques 98
Case 13 Up the Hill Bakery 98
Case 14 JB Bike Rental 108
Case 15 Torero Tennis Team 114
CHAPTER 6 Excel—Advanced Design Techniques 121
Case 16 Up the Hill Bakery 121
Case 17 Maxine’s Travel Agency 131
Case 18 Thomas Paul Investment, Inc. 137
PART 3 DEVELOPING A WEBSITE APPLICATION 143
CHAPTER 7 Website Design 145
Case 19 Up the Hill Bakery 145
Case 20 Bella Spa 150
Case 21 Legends 153
Index 157