Getting Started with Integrated Projects Book

CONTENTS

CASE 1Integrated 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 2Integrated 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 3Integrated 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