Tag Archives: Access

Poster – Microsoft Access to Cloud Migration

Recently I reviewed options for how to migrate Access databases to the Microsoft cloud.  There are multiple target platforms to consider.  

At a high level I see four category of MS Access databases.  Each had it’s own target platform to match.

  1. Simple (SharePoint List) – Table storage with rows and columns.  Data entry such as a tracker, log, or flat input.
  2. Relational (Dynamics 365) – Multiple entities with relationships such as one-to-many and many-to-many.  Navigate data and advanced reporting.
  3. Application (Azure App) – Advanced input, form validation, triggers, scripting, and code.   Need flexbility of Azure Web App, SQL Azure, and PowerShell runbook to accommodate all features.
  4. Reporting (Power BI) – Presentation of data into chart and table format.   Drill down, filter, merge data sources, etc.

Cheers!  shades_smile

Download PDF

Download VSDX

image

Office 365 missing Datasheet – Use Access ACCDB

For bulk editing of SharePoint list data, we used to have Datasheet (ActiveX control) in the old MOSS 2007 / SP2010 days.   SP2013 gave us Quick Edit (JavaScript based) with compatibility across multiple browsers and works well for simple edits.

However, sometimes we want a more robust bulk edit.  Sort, filter, keyboard navigation, copy/paste, and more full features.   MS Access can help with the “External Data” feature.

Now we can make changes to SPList with MS Access for a faster advanced user experience than Quick Edit in the browser.

Cheers!  shades_smile

Steps

  1. Open MS Access
  2. Create new database
  3. Click “External Data”
  4. More: SharePoint List
  5. Type in your site URL:  https://tenant.sharepoint.com/sites/team
  6. Link to the Data Source
  7. Next
  8. Select the list
  9. OK

Screenshots

clip_image001

image

image

image

References

Return to Top ▲Return to Top ▲