SharePoint Designer Features and Site-Creation Tools
Manage Content with SharePoint Online Document Sets
Export an Access Table to a SharePoint Online List

Translate Access Lingo into SharePoint Online Terms

Before embarking on an integration project between SharePoint Online and Access, it’s best to understand some geek terminologies to ensure success and, of course, to impress your co-workers.

In Access, you have fields and records. In SharePoint, fields translate as columns, and records are rows.

If you are using the desktop application of Access 2010, take note that an Access database contains forms, reports, queries, macros, and tables. These are called objects. Each of these objects can either be a Web Object or a Client Object.

As the name implies, Web Objects is web compatible and, therefore, what you see in your desktop application translates well when you view it from a web browser. Client Objects can only be used in the client or desktop application.

An object can only be either a web object or a client object. You can’t convert one into the other. You can, however, save a web object as a new client object.

An Access database can only contain either web tables or client tables — not both. It can, however, contain both web and client forms, queries, and reports.

Knowing this is important because if you plan to publish a database to your SharePoint site, you need to create a web database (as opposed to a client database) to ensure data integrity and compatibility.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
How to Use SharePoint Online Visio and InfoPath Form Services
Integrate SharePoint Online with Access 2010
SharePoint Online Farm Multitenancy
Why You Don't Want to Administer the SharePoint Farm
Microsoft Office 365 Backstage View