Monitor Sales activity with MS Access

[adfo]

I need to create a data entry user interface hooked to Access database to allow salesmen record their sales activity. The salesman will pull the Client from a drop-down menu, which is reading from the “clients” table. The client's contact information will show up to call.
The salesman should be able to record a notes (summary) of the call output, follow up date and time (if required), and save in the database.

The application shall allow up to 40 activities (calls) for each client .. I should be able to generate a report every week by salesman such as showing history of all calls and summary of all notes made with each client..

I appreciate if somebody suggests a database structure to start with and sample code as a starting help if possible

 

[Golom]

Isn't doing something like this approximately the equivalent of deciding to write your very own word processor or spreadsheet program?

A simple Google search for "Contact Manager Software" produced about 332,000,000 hits of which this review of a selection of top 10 such products is presented.

For a modest cost you get full-featured, tested, supported products that probably address your current needs and any that you develop in the future ... and you get it now ... not after weeks or months of in-house development.