Database Introduction

Basic concepts visualized
Excel grade list file (view in web browswer [left-click]; download to explore [right-click])
Spreadsheets as flat databases
Charting options
Statistical functions (interoperable with Access)
Excel pivot table file (right-click to download)
Pivot table for visualization
Practice with Access (true relational database; steep learning curve)
Tables and Queries
Relational databases
Web options
ExampleDB040925.mdb (right-click to download)
(Practice with FileMaker (quasi-relational database; shallow learning curve)
(Starting with a template (e.g., Recipe file)
(Starting with a blank file (e.g., class database)
(Enabling Web sharing
(Moving Data from FileMaker to Access
(FileMaker Pro 3 functioning as presentation/training software [right-click to download 1.8M])
 
 
Copyright © 2003-2008 Eric S. Rabkin