Recommendation/Questions

[Kenny G]

I have MS Office 2003 to use for this project.

The current plan is to have an Access DB out there on the network and assign
users (360) throughout the organization access to the folder housing the
database for data entry purposes.

Over the next twelve weeks data will be collected and reported on. Every
week there will be 12 new questions with Y, N, or NA responses with a Comment
(Memo) below each question. Every week I get a new set of questions and need
to build some new forms for data entry because I won't know the questions to
build it all a once.

Is there a better way to go about collecting the data? Transfer the data
from Word to Access? or Excel spreadsheet to Access?

Is Info Path a better tool for this in the future when we upgrade to 2007?

Thanks,

 

[John Spencer]

Take a look.

Duane Hookom has a sample survey database "At Your Survey" at

http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=4

This fully functional application uses a small collection of tables, queries,
forms, reports, and code to manage multiple surveys. Users can create a
survey, define questions, enter pre-defined answers, limit to list, report
results, create crosstabs, and other features without changing the design of
any objects.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Kenny G]

John,

Thanks, I'll check it out.

--
Kenny G

Take a look.

Duane Hookom has a sample survey database "At Your Survey" at

http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=4

This fully functional application uses a small collection of tables, queries,
forms, reports, and code to manage multiple surveys. Users can create a
survey, define questions, enter pre-defined answers, limit to list, report
results, create crosstabs, and other features without changing the design of
any objects.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Tony Toews [MVP]]

The current plan is to have an Access DB out there on the network and assign
users (360) throughout the organization access to the folder housing the
database for data entry purposes.

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. The FE is copied to each network
users computer. The FE MDB is linked to the tables in the back end
MDB which resides on a server. You make updates to the FE MDB and
distribute them to the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

Over the next twelve weeks data will be collected and reported on. Every
week there will be 12 new questions with Y, N, or NA responses with a Comment
(Memo) below each question. Every week I get a new set of questions and need
to build some new forms for data entry because I won't know the questions to
build it all a once.

You've already got a good answer there.

Is there a better way to go about collecting the data? Transfer the data
from Word to Access? or Excel spreadsheet to Access?

No. As pulling data out of Word and Excel is more work. Also users
will occasionally much with the files and add/delete columns and such.

Is Info Path a better tool for this in the future when we upgrade to 2007?

Possibly but there is a per seat license unless you purchase a runtime
for it. Last I heard someone sold an InfoPath runtime for $5,000.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/