1. You’ll need to create tables, then use the import functions in Access to load the data. You’ll probably need to normalize the data in the Access database as Excel data usually isn’t normalized.
2. Moving an Access form from Access to Excel, will be pretty tough as Excel doesn’t have a form mode.
3. You can have more than one user open a single access database at the same time. Your performance will not be very good, as Access isn’t designed to be a multi-user database. I would recommend using SQL Server 2005 Express as the back end, then use Microsoft Access to create forms which are linked to the SQL Server 2005 Express database. This way the data storage is handled by a system which is designed to handle multiple users at the same time and the front end is easy to design and build.
If you need more info on SQL Server 2005 Express check out the <a href=”http://www.microsoft.com/sql/editions/express/default.mspx”>Microsoft SQL Express web site</a> as well as <a href=”http://itknowledgeexchange.techtarget.com/sql-server/”>SQL Server with Mr. Denny</a>.