How to design data entry forms for sales reps and how to import them in large numbers

  • Thread starter Thread starter zaskodnik
  • Start date Start date
Z

zaskodnik

Hi everybody,

I just started to learn about Access since my boss wants me to creat
foolproof data entry forms that will be emailed to our sales reps an
they will fill them and send them back to us. I will have to proces
the data and create reports.

1) First, I need to decide what file format the forms will be in
Should it be an Excel spreadsheet or is there some different kind o
file format in Access..... so that I don't have to import it fro
Excel?

2) How to import them automatically when I receive them via email? I
other words, how to process multiple files stored in one folder?

Thank you all, I really appreciate your advices.

Petr
 
One option you might consider is to use InfoPath. Alternatively, sending
your employees some small databases with forms could be an option, then
you'd just have to import the fields from the access database - which is
quite easy.
 
Firstly it is bad form to be impatient in news groups

seccondly
Excel cannot be "foolproofed" to my knowledge
my suggestions would be
1) Access Runtime with a simple data entry form
2) Vb frontend with a simple data entry form (access backend)
3) A web page

Solution 1 & 2 would have to be set up with a transport mechanism (read
email) - you could export the data in excel, text,xml or whatever
It is not difficult to program the import from either
Solution 3 could be linked directly too the Db

to ask for more specifics would be asking if somebody were willing to do the
programming/research for you for free ;-)

HTH

--
Pieter Wijnen

When all else fail try:
http://www.mvps.org/access
http://www.granite.ab.ca
http://allenbrowne.com/
 
Back
Top