For a short intro see RDBMS in Excel
http://www.tushar-mehta.com/excel/ne...cel/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I'm having trouble creating a simple-to-use/looking database that contains
the following information:
Date
Event
Names of people who attended (there are about 350 people in the "club" [it's
an event organization for the mentally ill], it gets annoying to type each
name individually)
Addresses of attendees (also annoying to re-type per worksheet in each book
Number of people who attended each event (there are multiple within a month)
An unduplicated number of people who attended events that month
The number of people with devolpmental disabilities
Individual payees and how they paid (cash, check... ect.)