Hi,
I've recently been thrown into Access again and haven't touched it for years. They need an Access form that rides off some data that I import from a massive excel spreadsheet.
Although I know that you can share excel spreadsheets between two or more people, can this be done in Microsoft Access? Or am I going to have to purchase something like SQL Anywhere?
Also, in terms of relationships...if I create a single table, then create queries from it, and users fill in the information in a form drive off of the queries, will this update only the query, or will it also update the table? Is this something I would have to setup in relationships right off the bat? Cause I'd like to have all data saved back to the main table to run reports from it.
Goal -> small and simple.
Thanks for your help!
I've recently been thrown into Access again and haven't touched it for years. They need an Access form that rides off some data that I import from a massive excel spreadsheet.
Although I know that you can share excel spreadsheets between two or more people, can this be done in Microsoft Access? Or am I going to have to purchase something like SQL Anywhere?
Also, in terms of relationships...if I create a single table, then create queries from it, and users fill in the information in a form drive off of the queries, will this update only the query, or will it also update the table? Is this something I would have to setup in relationships right off the bat? Cause I'd like to have all data saved back to the main table to run reports from it.
Goal -> small and simple.

Thanks for your help!