Sim1980
asked on
Office 365 and Microsoft Access
Hi all.
Someone mentioned Office 365 and Microsoft Access and I wanted to get your opinions on it. Mainly, why would someone want to use Microsoft Access and Office 365 and Sharepoint Online?
Are all of the features available for the regular Microsoft Access also available in Office 365/Sharepoint Online, or is it more basic (i.e. no VBA, no charts etc.).
Thank you in advance!
Someone mentioned Office 365 and Microsoft Access and I wanted to get your opinions on it. Mainly, why would someone want to use Microsoft Access and Office 365 and Sharepoint Online?
Are all of the features available for the regular Microsoft Access also available in Office 365/Sharepoint Online, or is it more basic (i.e. no VBA, no charts etc.).
Thank you in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oh and we also would need to run Access reports.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You do have to buy one of the more expensive editions of Office 365 to get the SharePoint hosting for Web apps. At the time I got a subscription, the E2 edition was the minimum one that had Web hosting.
<<So, would you recommend we stick with Access desktop instead of going to the cloud? We're a small office (about 10 users) and we would use some forms and reports, some may require VBA and queries with grouping etc. We do not have any remote users, everything is done in our office. >>
Tough call without knowing a lot more. Besides the additional points that Pat and Helen made, consider the following:
1. Your internet connection, is it fairly robust? You should even for a small Office have 5mb down and 1-3 up as a bare minimum.
2. What do you do for IT support now, DIY or pay someone? If the later, then you may save some money by moving to Office 365.
3. Do you need a server on-site for a local app? If yes and it can't be moved to the cloud, then you might as well keep everything in-house, especially if it's SBS.
Jim.
Tough call without knowing a lot more. Besides the additional points that Pat and Helen made, consider the following:
1. Your internet connection, is it fairly robust? You should even for a small Office have 5mb down and 1-3 up as a bare minimum.
2. What do you do for IT support now, DIY or pay someone? If the later, then you may save some money by moving to Office 365.
3. Do you need a server on-site for a local app? If yes and it can't be moved to the cloud, then you might as well keep everything in-house, especially if it's SBS.
Jim.
ASKER
So, would you recommend we stick with Access desktop instead of going to the cloud? We're a small office (about 10 users) and we would use some forms and reports, some may require VBA and queries with grouping etc. We do not have any remote users, everything is done in our office.