how do i set up a customer profile table?

D

dsfasdfsadf

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
 
K

kassie

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.
 
T

Toppers

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top