Tuesday, September 1, 2020

* Index to Roger’s Access Blog *

Access Basics
Compacting Databases
Domain Functions Demystified
Date Stuff
 Database Design Basics
What’s Wrong With Repeated Columns?
Normalizing Repeating Columns

Queries
Select Queries Series:
Subqueries

Union Query
Data Definition Language (DDL) Queries:

Top Queries Revealed:
Count Distinct In Access Series:
Miscellaneous
Reports
VBA/Programming
Automation




Web Databases
Unfortunately, as of Access 2019, Access Web Apps have been discontinued.  From the March 2017 announcement from Microsoft:

“We no longer recommend Access Services for new apps. This feature will be retired from Office 365. We will stop creation of new Access-based apps in SharePoint Online starting June 2017 and shut down any remaining apps by April 2018.”