Kirsten -
Disclaimer:  I have not ever used Sharepoint.  I don't know the ins and outs of it.

That said:
Microsoft announced quite some time ago that the were depreciating Access and Sharepoint for Microsoft 365 / Access 2019.
Sharepoint Roadmap Article

For that reason I quit going down that branch of my learning path.

So....
Can you describe your organization and it's needs?  What are your requirements based on ?

For instance, if you are all in the same building on the same LAN,  I would suggest differing alternatives than if you are in multiple buildings or even different cities wanting to access your database via web browser over the internet.  (The latter is way beyond my skill set at the moment by the way)

How many people are currently accessing the db.  What does the potential user needs look like in the next 5 years?

Last but not least.  If you were wanting to hire a developer to help you make this move.  This is the correct spot to place this question.

If you were asking questions prior to doing the work yourself, I will ask Richard or Alex to help us move this post to the appropriate forum.

@Scott Access still works with SharePoint, it's "Access-based web apps and Access web databases" that aren't supported anymore. They are quite different.

Well I learned something today.  Thanks Alex.
Can you help me understand the difference then? Or point me in the right direction.

MS were looking to make a new web app for Access, but with macro security and no vba in browser it didn't quite work out, not much up take either
They have started porting Excel macros/vba to Typescript so if it works well maybe they'll look back at it again, but I doubt it

Alex: thanks for the correction

Scott: yeah, Access Web Apps were horrible. I played with them for a bit and immediately hated them.

Kirsten: don't worry. Access and SharePoint will continue to work just fine together for the foreseeable future. And yes, you can bring your data back down from SharePoint and put it back in Access if you want. It's not as easy as moving UP to SharePoint, but it's still doable. I would keep copies of your old Access tables around just in case. It's easier to import the data into existing tables than to recreate the tables from scratch again.

Hi everyone - Thanks so much for the inputs and advice.  

To answer Scott's question above - I am planning to do the migration work myself as much as possible.... however, I would be willing to pay for a short consulting session or two to ensure I'm on the right track.  I really need this to work for sharing with the team (particularly the forms & queries), but I also really don't need to muck this up.

Richard - Thank you so much for the additional inputs.  I will definitely keep a backup copy of the original tables.  It's good to know that we could bring back the data into Access if need be.... but that importing the data is better than re-creating.  Awesome tip.  I'll keep watching the remaining videos in the Sharepoint seminar, as some of my question might already be answered there.