CONTENTS
CASE 1|Integrated Case Study: The Totally Fit
Wellness Center
Objectives 1
Totally Fit Revenue Workbook and Chart (Excel) 2
Report to the President (Word and Excel) 3
Presentation to the President (Powerpoint
and Excel) 4
Last-Minute Change (Word, Excel,
and Powerpoint) 5
Importing Data (Access And Excel) 7
A Relational Database (Access) 8
Access Objects: Queries and Reports (Access) 9
Worksheet Tables (Excel) 10
Worksheet Calculations (Excel) 11
Presentation to the Board (Powerpoint
and Excel) 12
Letter to the Board (Word and Excel) 13
Mailing Labels (Access) 14
Create a Home Page (Excel) 15
Submission Checklist (Word) 16
CASE 2|Integrated Case Study: Alternate Airways 18
Objectives 18
Alternate Airways Revenue Workbook
and Chart (Excel) 19
Report to the President (Word and Excel) 20
Presentation to the President (Powerpoint
and Excel) 21
Last-Minute Change (Word, Excel,
and Powerpoint) 23
Importing Data (Access and Excel) 24
A Relational Database (Access) 25
Access Objects: Queries and Reports (Access) 26
Worksheet Tables (Excel) 27
Worksheet Calculations (Excel) 28
Presentation to the Board (Powerpoint
and Excel) 29
Letter to the Board (Word and Excel) 30
Mailing Labels (Access) 31
Create a Home Page (Excel) 32
Submission Checklist (Word) 33
CASE 3|Integrated Case Study: University Housing 35
Objectives 35
University Housing Revenue Workbook
and Chart (Excel) 36
Report to the Provost (Word and Excel) 37
Presentation to the Provost (Powerpoint
and Excel) 38
Last-Minute Change (Word, Excel, and
Powerpoint) 39
Importing Data (Access and Excel) 41
A Relational Database (Access) 42
Access Objects: Queries and Reports (Access) 43
Worksheet Tables (Excel) 44
Worksheet Calculations (Excel) 45
Presentation to the Trustees (Powerpoint
and Excel) 46
Letter to the Trustees (Word and Excel) 47
Mailing Labels (Access) 48
Create a Home Page (Excel) 49
Submission Checklist (Word) 50
INDEX
