Problem Solving Cases In Microsoft Access & Excel

PART I: DATABASE CASES USING ACCESS. Tutorial A: Database Design. Tutorial B: Microsoftï½ Access. Case 1. Setting Up a Relational Database to Create Tables, Forms, Queries, and Reports. Preliminary Case: Feline Novelties. Case 2. Designing a Relational Database to Create Tables, Forms, Queries and Reports: The Travel Light Database. Case 3. Designing a Relational Database to Create Tables, Forms, Queries, and Reports: The Personal Trainer Database. Case 4. Designing a Relational Database to Create Tables, Forms, Queries, and Reports: The Rent UR Car Database. Case 5. Designing a Relational Database to Create Tables, Forms, Queries, and Reports: The Household Help Database. Part II: DECISION SUPPORT CASES USING EXCEL SCENARIO MANAGER. Tutorial C: Building a Decision Support System in Excel. Case 6. Decision Support Using Microsoft Excel: Philly Landscaping. Decision Support Using Microsoft Excel. Case 7. Decision Support Using Microsoft Excel: Electric Car Financial Analysis. Part III: DATA ANALYSIS CASES IN MICROSOFT ACCESS AND EXCEL.. Tutorial D. Data Analytics. Case 8. Data Analytics Using Microsoft Access and Excel: Data Analytics of Boutique Hotel Reservations. Case 9. Data Analytics Using Microsoft Access and Excel: Data Cleansing Task. Part IV: DECISION SUPPORT CASE USING BASIC EXCEL FUNCTIONALITY. Case 10. Decision Support Using Microsoft Excel: The State Pension Fund Analysis. Part V: INTEGRATION CASES USING ACCESS AND EXCEL. Case 11. Data Analysis and Research with Microsoft Access and Excel: FAA Wildlife Hazard Research. Case 12. Decision Support with Microsoft Access and Excel: The Engagement Analysis. Part VI: ADVANCED SKILLS USING EXCEL. Tutorial E: Guidance for Excel Cases. Part VII: PRESENTATION SKILLS. Tutorial F: Giving an Oral Presentation. Index.