Creating a new Database for orders

[sleeplessnightsothatitbecomesautomated]

I'm in the process of creating a new data base and using email to gather
purchase orders.
Now what I wonder about is if this idea is even possible.

Ok so I have a master key list with all available products and have a list
of about 10 people ordering a variety of products from this list.What I want
to do is create a form that is sent by email and this form will be linked to
the database and will make it possible for the person to search the database
and select what ever items they want & I want a query option in there to make
it fast for them to fill in the order. Once the order is placed and the form
is sent back I want the form to go into the database and automaticaly update
a master list with all orders for the year 2008.

Is this possible and any information or demos that might be useful I would
really appreciate it and any idea to make it simpler or anything would be
greatly appreciated.

Thank you

 

[Beetle]

Access forms have no existence outside of the application itself. In addition,
forms do not store or contain any data, they only display data, so it is not
possible to send someone an individual form and have them fill it out and
send it back.

If the users that are placing orders are part of your organization, they have
Access on their computers, and you are all connected via LAN, then you
could certainly set up a multi-user application that might solve your issue.
If your users are connected to your network via WAN (instead of LAN), it
can still be done, but your would need to use Terminal Services, or a
SQL Server backend, etc.

On the other hand, if you are trying to set up some sort of web based
ordering system for persons outside of your organization, then Access
is not the right application.