Need Resources for Migrating Access to SQL Server

I am forced to begin a crash course in migrating a dozen (or so) Access 2016 MDB backends to SQL Server 2016.  (The SQL Server version may change to a more-recent one in the midterm, but 2016 is what I have for now.)

Does Experts Exchange have a curated section on "Access-to-SQL-Server Migration for Dummies"?  I have decades of Access/DAO experience, just none migrating Access backends to SQL Server (or administering them, once migrated).

Can any experts here recommend (reliable) third-party books or online resources to hold hands and baby-step veteran Access developers through the process?

Thanks!

PS: I realize this is a HUGE subject, but here is an example of the type of practical question (among so many others) for which I hope to find answers: Is there a Microsoft library I can reference from the VBA project in Access, which exposes the SQL Server "object model" of a backend database -- like the DAO object model -- and allows code to iterate though table, column, key, constraint, trigger, and index objects (and reference their properties)?