TM Tornado
Single factor sensitivity analysis to help evaluate risk and uncertainty
Julie's Market
Get Ca$hBack from THOUSANDS of Partner Stores including WalMart & Target!
Total Web Solution
Enhance your Web Presence! Get your customized FREE demo.
You are on the Home/Excel/Tutorials/RDBMS in Excel page
Google
Web This Site
TM Custom Radar Chart
Radar Chart with independent and, optionally, normalized axes
TM Timer for PowerPoint
Countdown, Time of Day, or Elapsed Time in a PowerPoint Presentation
TM Chart Utilities
Various utiities to enhance chart use in Microsoft Excel

Building and using a relational database in Excel (with a little help from MS Query)

Introduction to a relational database

Five management queries

A list of customers and their accounts

A list of account types and the average balance in each type

A cross-table of the number of accounts by customer city and account type

A list of customers in a zip code that is specified dynamically

A list of customers in a zip code selected from a drop down list of valid zip codes

Building the queries

Query 1 -- A simple table linking multiple tables in the relational database

Query 2 -- A PivotTable from data in the relational database

Query 3 -- A PivotTable cross-tabulation using data in the relational database

Query 4 -- A parameterized query to list of customers in a zip code that is specified dynamically

Query 5 -- A parameterized query to list of customers in a zip code selected from a drop down list of valid zip codes