We need a database that will combine several current Excel reports while allowing easy input of information and restricting what certain employees can input. We want this database to be functional with SharePoint so Access isn't required on every computer; currently we are using SharePoint 2007 but want to upgrade to SharePoint 2010. Custom queries and forms.
We need help understanding what we need. We have several Excel reports being generated out of different departments that is duplicated work. We need to streamline our data input and reporting.