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.