Lab exercises

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
For questions and comments please contact the author

Date revised: 02-Dec-2022