CMC
Technology and Academic Integrity
E-COMMUNICATION PRESENTATION E-PAPER DATA ANALYSIS E-RESEARCH E-ETHICS DATABASE
 
banner
welcome more menu
intro to dbs
design more menu
simple db more menu
queries more menu
forms more menu
reports more menu
miscellaneous more menu
conclusion more menu
Go to Database Design next

Introduction

What are databases?

Database tools such as Microsoft Access are excellently suited to storing and working with complex data, especially if it has many relationships. For example, if you want to make a list of the members in your club, then of course a spreadsheet will work—unless you also want to make a list of club events, associate members with events, and be able to quickly see which events are run by which members or which events a particular member participated in. A database could also be used to find which members haven’t met a minimum level of participation, or which members have been so helpful that they deserve extra recognition.

Databases provide a similar set of benefits if you want to manage a collection of CDs. Of course you could store the list in a spreadsheet, but what if you want to be able to easily store ratings for songs and make a list of all of the bands whose music you like or whose CDs you’ve purchased in the past year? Again, a database will fit the ticket nicely.

On first blush a database will seem to be just like a spreadsheet; when you create your first database in the next section it will look suspiciously like an Excel worksheet. However, databases have one key additional feature: you can create relationships between different tables and perform queries on tables or groups of queries. As a result, a database allows you to represent concrete objects such as a slacking club member or a song. The key, as you will see, resides in the Start Menu .

back Back to Outline

Copyright © 2007 Claremont McKenna College