Setting up database

[Guest]

(e-mail address removed)

I would like a personal program that will do the following for my business.
The business is service oriented. I will be making cold calls and selling
magazines and other books. Can Act do the falling:



Keep track of my daily miliage

Keep tract of how many hours I work each day.

How many magazines, books, etc. I sold each day and the date of the magazine
and who I sold to.

A customer contact list. My best customers.

A form that will show the customer, time and date of visit, last visit,
publication sold, what we talked about customer profile etc. for any given
date so I can keep a history.

A form that shows my day at a glance and over a given period of time—day
week month year­ Total hours worked, total magazines sold, total miles. A
graph showing productivity over a given month etc.



Can I enter data on my Jornada 720?



Can you direct me on how I can set it up



Sincerely,



Larry Orth

 

[Joseph Meehan]

(e-mail address removed)

I would like a personal program that will do the following for my
business. The business is service oriented. I will be making cold
calls and selling magazines and other books. Can Act do the falling:

What is Act?? This is a Microsoft Access professional database
newsgroup.

I will answer your questions based on MS Access, as I don't know Act.

Keep track of my daily miliage - Yes

Keep tract of how many hours I work each day. - Yes

How many magazines, books, etc. I sold each day and the date of the
magazine and who I sold to. - Yes

A customer contact list. My best customers. - Yes

A form that will show the customer, time and date of visit, last
visit, publication sold, what we talked about customer profile etc.
for any given date so I can keep a history. - Yes

A form that shows my day at a glance and over a given period of
time-day week month year­ Total hours worked, total magazines sold,
total miles. A graph showing productivity over a given month etc. - Yes
(may require more than one form)



Can I enter data on my Jornada 720? I don't know what a Jornada 720 is.



Can you direct me on how I can set it up

Not in a newsgroup environment as what you are asking involves basic to
advanced techniques and the newsgroup form is not really a good choice for
that much instruction. I suggest you start with a good book on Access and
work up to it from there. Come back here with specific questions that the
book may not explain in a way you can understand.

 

[Jeff Boyce]

Larry

Have you looked at any of the templates or samples that come with Access
(you ARE in an MS Access newsgroup)? Have you searched Google.com on these
topics?