Contact Address Database

[Guest]

I need to create Contact Database. Fields are : number, name,
tel_number,email,mobile_number,department.

I need this database department basis.

Could you please tell me a very good method to create this. What tables I
have to included? I need to get access data on department basis and
individual basis.
What are the facilities I have to create in this database? I need your
suggestion.

Thanks in advance.

 

[John Vinson]

I need to create Contact Database. Fields are : number, name,
tel_number,email,mobile_number,department.

I need this database department basis.

Could you please tell me a very good method to create this. What tables I
have to included? I need to get access data on department basis and
individual basis.
What are the facilities I have to create in this database? I need your
suggestion.

Thanks in advance.

Ummm... you just designed it.

Create a table with these fields.

You can create a Query searching it by department, or by individual.

I would strongly suggest that you get - and study, carefully - a good
book on Access. Teaching you all about Access on a newsgroup is a bit
unreasonable. John Viescas' _Building Microsoft Access Applications_
is a newer book and a very good one; there are many others on various
levels and different teaching styles.

John W. Vinson[MVP]

 

[Guest]

Please just tell me how can I do this. I want to make this in form. I know
how to do. But I need your advise on how to do best only. Would appreciate
your advise.
Just tell me in brief as you help me for my several other question. Thanks
in advance.

 

[John Vinson]

Please just tell me how can I do this. I want to make this in form. I know
how to do. But I need your advise on how to do best only. Would appreciate
your advise.
Just tell me in brief as you help me for my several other question. Thanks
in advance.

Kutty...

You're not listening. I'm trying to help, but you are asking the same
questions over and over and not responding to the answers you're
getting.

You do NOT STORE DATA IN FORMS.

A Form is just a tool, a window. You store data in Tables. Design your
tables first; then design the form to fit the tables.

Again - *study*. Get a book. Read it. This newsgroup is not the place
for a complete Access development training course, it's for answering
specific, detailed questions.

John W. Vinson[MVP]