Link to home
Start Free TrialLog in
Avatar of Sim1980
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!
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sim1980
Sim1980

ASKER

Thanks for your reply Jim.

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.
Avatar of Sim1980

ASKER

Oh and we also would need to run Access reports.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.