Data Base Management with Excel

Data Base Management; using the computer to create data files (e.g. a simple list of your commonly called phone numbers, a doctors patient records, a schools student transcripts, IRS tax files, etc.) and then accessing, manipulating and using the data files for finding information, billing, creating mail labels, mail merge advertising, etc.

Data base concepts

fields/categories - variables, items of information you want in your data base (e.g. for a personal phone list you would likely have categories like Last Name, First Name, Home Phone, Work Phone, E-mail Address,  Address,  City,  State,  Zip,  Birthday, Title,  Company

record - the set of categories for one unit of your data base. The fields for one person in your phone list;

Last Name  Ross
First Name Jim
Home Phone (661) 555-1212
Work Phone (661) 664-2384
E-mail Address jross@csub.edu
Address 9001 Stockdale Highway
City Bakersfield
State CA
Zip Code 93301
Birthday July 4, 1999
Title Dr.
Company california State University Bakersfield

file - all records of your data base (e.g. all the individuals and their categories in your phone list, all student transcripts at C.S.U.B.)

A sample data base files (1) an address and phone list created in Excel: PhoneDB, Sample Christmas letter to merge with the Phone DB SampFormLett.doc. (2) Simple Mtdterm Grade data base _SampleGdeDB.xls,  Sample Mtdterm Grade letter to merge with the Grade data base.