When we first created Access Services in Share Point, we set out on a mission to enable both information workers and developers to quickly create data centric web applications with little or no programming.
Over the last several years it has become clear that the needs of our customers have grown beyond the scope of what Access Services can offer, such as mobile device support, integration with line of business data, and professional developer extensions.
Power Apps offers a comprehensive set of application building tools, connection to custom web APIs, and a wide array of database options including Share Point lists, SQL Azure databases, Common Data Service and third-party data sources.
We will include Access Services and Access Web Apps in the next version of Share Point Server.
Access Web Apps and Access Services will continue to be supported in all current versions of on-premises Share Point servers for the remainder of the product lifecycle. ACCDB files) will not be impacted by this decision.
An example of this would be a table for teachers and classes.
A class will contain a teacher so a table for classes will contain a field for teachers.