Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Insurance Tracie
 
Posts: n/a
Default 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   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I export information from excel to word, ie database of na. Harry Gill Excel Worksheet Functions 1 April 4th 05 02:25 PM
Sharing information between Access and Excel C.M. Warden Excel Discussion (Misc queries) 1 March 16th 05 01:38 PM
Database Information Nick Excel Worksheet Functions 1 March 7th 05 03:52 PM
Excel as a database and sorting information [email protected]##### Excel Discussion (Misc queries) 1 February 27th 05 10:50 PM
PLEASE HELP!? Creating a simple database with excel, minor setback Pre-construction Manager & Excel !? Excel Worksheet Functions 1 November 30th 04 09:59 PM


All times are GMT +1. The time now is 03:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"