Access Help

elader 

First, good luck with the project. I'm sure you'll find that a properly designed Relational Database Application using Microsoft Access is a great way to accomplish your goals.

That said, let's start with a caveat: Excel worksheets are generally NOT a good model to work from when you need to create a Relational Database Application (whether you use Access or another database program to do it). The key is in the "Relational" part. Excel worksheets don't lend themselves well to relational designs, so we need to be pretty cautious about going that route.

Also, we need to be careful about "sharing to the web". That can mean a couple of different things, but it generally refers to web pages in a browser interface. Is that what you intend here? If so, you need to keep in mind that Access does not support web interfaces directly. (We have had two or three now-abandoned attempts to implement that over the last couple of decades.) Your "sharing to the web" would, therefore, need to be done via an appropriate web technology, and that's a big subject in itself. But for now, that'll be on the back burner.

Step one is to invest some time in learning more about how Relational Database Applications work. And that means learning about proper table design and the process of Normalization. I've published a handful of YouTube videos on this general topic that might help you get your feet under you. In addition, you'll find a lot of useful information by searching for "Normalization" in your favorite search engine.