![]() |
how do i set up a customer profile table?
i want to make like a data base for work. I am a sales consultant at a real
estate company. for every customer that i meet and have his/her bussiness card, i have to put all the information; example: name, phone #, email, city, country, website, organization, ect... please try to help me make one.... thank you |
how do i set up a customer profile table?
You have already answered your question?
In row 1, enter the headings that you want to incorporate in your database, such as Surname(A), Name(B), Street Address(C), Suburb(D), City(E), Country/State(F), Phone(G), E Mail(H), Organization(I), Website(J) and so forth. In Rwo 2 dwon, enter the information as per these headings. Once done, sort the list according to Surname, then Name. You can then find any record by pressin <Ctrl<F, and typing in the info you have, be it the contact's name, surname, company, email or whatever. -- Hth Kassie Kasselman Change xxx to hotmail "dsfasdfsadf" wrote: i want to make like a data base for work. I am a sales consultant at a real estate company. for every customer that i meet and have his/her bussiness card, i have to put all the information; example: name, phone #, email, city, country, website, organization, ect... please try to help me make one.... thank you |
how do i set up a customer profile table?
Basically, as you defined it in your posting:
For example .... A1=First Name B1=Last name C1= First address line D1= Second address line E1=City F1=Zip code / Post Code G1=Country etc Consider home addresses & company addresses, and similarly for telephone numbers. List all the possible customer information you think you want and then organise your table. Consider also how you might want to manipulate the date e.g. sorts, extracts, mailing lists as these will (should!) be reflected in how you format/organise the data. HTH "dsfasdfsadf" wrote: i want to make like a data base for work. I am a sales consultant at a real estate company. for every customer that i meet and have his/her bussiness card, i have to put all the information; example: name, phone #, email, city, country, website, organization, ect... please try to help me make one.... thank you |
All times are GMT +1. The time now is 03:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com