If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I set up a database for client information
I need to create a database (would like to do it in Excel) that would compile
client information such as name, address, birthdate, retirement date, phone, assigned rep, e-mail address, etc. then be able to pull out only the information needed and from only certian assinged reps. I have never done a spreadsheet or database before. So I need explecit details. Thank you Tracie |
#2
|
|||
|
|||
You can enter all the data in a list on the worksheet, with column
headings to indicate what information is stored in each column. Then, you can use an AutoFilter to view the data for one rep, or a specific date range. There are instructions in Excel's Help, and he http://www.contextures.com/xlautofilter01.html To summarize the data, e.g. count the number of clients assigned to each rep, you can use a Pivot Table. There are instructions in Excel's Help, and Jon Peltier has information and links: http://peltiertech.com/Excel/Pivots/pivotstart.htm Insurance Tracie wrote: I need to create a database (would like to do it in Excel) that would compile client information such as name, address, birthdate, retirement date, phone, assigned rep, e-mail address, etc. then be able to pull out only the information needed and from only certian assinged reps. I have never done a spreadsheet or database before. So I need explecit details. Thank you Tracie -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Make information "autocomplete" in a database | Miked | Database Design | 1 | April 14th, 2005 02:02 PM |
Exclusive access to the database | Steve Huff | General Discussion | 17 | December 24th, 2004 06:23 PM |
What is MDE | Charlie | General Discussion | 4 | August 24th, 2004 04:15 PM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |