Interactive Excel Database?

Question

I have a question about using excel as a simple database and publishing it to the web to allow other to interact with it. Please bare with me as I try to explain this:

I need to create a database of IDs for tracking purposes. Here is an example, UNICOL1001. The unique ID is composed of University Names (UNI), Colleges within the University (COL), department within the college (100), and class number (1).

So on excel I would create a worksheet with all the universities and their three-letter unique id. Then I would create another worksheet with all the colleges and their three-letter unique id and so on. Finally, I will have a "master" worksheet that will pull data from the other worksheet to create the ID (UNICOL1001).

So far so good right. My question is would it be possible to publish this to the web or intranet, so that other people in my group can get IDs generated for them by answering some questions.

Also, there needs for them to add new records to excel file.

Answer 1

I've never worked with excel on the web or intranet, so I do not know how well that would work



You can certainly make a database, enter new records and generate ID numbers

You will need to have some experience in VBA, or time to learn a few VBA tricks to make it work smoothly

Answer 2

I made one. Click on the cat (my picture) and send an email. I can send it as an attachment. It should fit on one page. Goes up to 200 bags with larger font. I suggest buying a plastic sheet or laminate it for longer use.

Answer 3

The 'relational' link between your data types strongly points to you using Microsoft Access instead of Excel. your interface would be easier, etc.

Answer 4

Do yourself a favor and don't use Excel as a database.