You are on the Home/Excel/Tutorials/RDBMS in Excel page
Google
Web This Site

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