I encourage you to watch this 17 minute video to understand how Microsoft is integrating Access into Dataverse and the Power Apps platform. No, Access is NOT going away.
Watch 'I8E7-OD164-Bringing+Microsoft+Access+into+the+Future_+Introd' | Microsoft Stream