Access and SharePoint
By combining the computing power of a data base like Microsoft Access with the ease of use of delivery system as Microsoft SharePoint, you are able to manage real time shared information between individuals and departments.
SharePoint Lists can be opened and updated on a line by line basis without having to check out, edit or resave information. Changes made by one person can be seen by all instantaneously without having to send emails.
Information entered into the SharePoint list is available immediately in an Access Database for report development.
Changes to statuses are immediately available to all working on the list. By centrally downloading updates and applying the information in Access, the SharePoint list and the people working with them are kept up to date. Work becomes dynamic and not static as with Excel Workbooks shared between groups.
Information available only in Excel Workbooks, can be linked to Access and then instantly shared over SharePoint list.
Access Database can also be developed so that there are programic controls on the data being worked on. This allows a system developed for multiple people with the ability to monitor and control the access.