How to Use SharePoint Online Access Services - dummies

How to Use SharePoint Online Access Services

By Ken Withee, Jennifer Reed

Access Services is a component of SharePoint Online, which is part of the Office 365 suite of products, that allows you to publish your Access application to a SharePoint site. All the forms, data, and reports that you created in Access are imported into SharePoint, and the application instantly becomes a multiuser web-based application that is hosted in the SharePoint environment.

Access is an application that is part of the Microsoft Office productivity suite. Access is a data management application that allows you to create databases, forms, and reports in one single file. The issue that Access files have run into in the past is that they are not easily shared among multiple people.

For example, you may create a contact-tracking Access application consisting of a database, data entry forms, and reports. If you need to share this application (it is a file with the extension .accdb), you may either e-mail it to someone or put it out on a shared folder. To limit access, you may need to mess with folder permissions or only send it to trusted individuals.

This scenario may be fine for a handful of users, but what happens when you need to share the application with hundreds of people throughout the organization? That’s where Access Services comes in.