Notes

[Countrylady]

I am trying to decide if Access is the right database for me to use. I want
a database where I can keep notes on all phone conversations/correspondance
that I have my organizations members. Is this available in Access?

 

[Roger Converse]

It depends what you are planning on doing with the notes, but Access would
work for that. It just depends on how you want it to work.

Thanks,
Roger

 

[Linq Adams via AccessMonster.com]

Data has a Memo Field datatype with a field size of approximately 64k, but as
Roger said, it depends of you are planning to do with these "notes!" A Memo
Field is designed for just this purpose, to store "memos" or notes. It is not
designed to store data if you ever expect to have to manipulate that data! If
you're going to review your notes or simply print them out , a Memo Field is
fine; I've used them in medical databases for years! If you need to do
anything else with them they're problematical, because In Access most things
done to data is done thru Queries, and Queries don't like Memo Fields!

Allen Browne has an excellent white paper on the subject at

http://allenbrowne.com/ser-63.html

Good Luck!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Larry Daugherty]

You may already have a Contact Management template included with your
version of Access. Open Access and rather than open a file, check the
radio button on the upper part of the dialogue window that has
"wizards" in it.

If you didn't find anything there, go to the Microsoft site and search
on templates. Eventually you'll get to the Office templates. With a
little poking you may even find things for your version of Access.

HTH