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.
- Simple (SharePoint List) – Table storage with rows and columns. Data entry such as a tracker, log, or flat input.
- Relational (Dynamics 365) – Multiple entities with relationships such as one-to-many and many-to-many. Navigate data and advanced reporting.
- 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.
- Reporting (Power BI) – Presentation of data into chart and table format. Drill down, filter, merge data sources, etc.
Cheers! 
Download PDF
Download VSDX
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! 
Steps
- Open MS Access
- Create new database
- Click “External Data”
- More: SharePoint List
- Type in your site URL: https://tenant.sharepoint.com/sites/team
- Link to the Data Source
- Next
- Select the list
- OK
Screenshots
