| Exercise | Purpose |
| Control break | To illustrate how to create a control break report (MS Access) |
| Data generation | To generate table test data (MS Excel) |
| Data integration | Illustrating some key issues of data integration |
| Google maps | Adding locations to a Google map using the Google API |
| Google search | To learn some of the lesser known features of Google's search engine |
| Insert statements | To illustrate how to convert a spreadsheet (MS Excel) into INSERT statements for loading into a relational database |
| Normalization | Conversion of an unnormalized database to a normalized database |
| Pivot Table / Data Pilot | To demonstrate the concepts of OLAP |
If you have any ideas for lab exercises, contact me.
This page is part of the promotional and support material for Data Management (open edition) by Richard T. Watson |