Help with Access & Forms

[gnatgnats]

Hello,

I'm more familiar with Excel than Access and need some input. I recently took some Access courses to get me started, but not yet sure if the application can do what I want.

I have just taken over an application inventory processs. Over the past 3 years, users previously had to complete application inventory surveys (in Word) and then someone would manually re-enter the results into Excel (this was not MY process).



My goal is to automate this as much as possible.

Here's what I would like to be able to do:
1) Post the form as a webpage
2) Users should be able to bring up prior year application survey info NOTE: If there is a new application, then users should be able to create a new record
3) Users should be able to edit their record and apply any changes to it for the current year (I will need to add a field called "year" to identify which year the survey was completed for)
4) Users should only be able to pull up the selected application or new record (I don't want users being able to scroll through all the applications)
5) And finally, users should be able to save their data via the webpage

Is the above possible in Access?
The courses I took were VERY basic and it appeared like Access only expected one person to enter data... however in my case I need to let about 400 users enter data.

Thanks, Mary-Lou

[dahand]

Yes you can do this. But if you want several people to enter data using Access, it needs to be on an intranet, rather than the internet. For internet data management, you need a SQL based system.

[gnatgnats]

Thanks for the information.