Help With Scouting Databases

[jamie_1930]

Scouting is going pretty smooth for us right now, and we have an online database to store any and all information we need. The problem I have with it right now is that I didn't write it and am not sure how to work all of it personally, we have other people doing that.

I'm mainly looking for help on making a scouting database in excel, so I'm wondering if anyone has any advice or tutorials on making them.As far as features go I want to be able to have one sheet for pit and another for match scouting that I can open up put in team number and match number then enter in all the information in drop down boxes, or radio buttons, and text. Then submit that file and have it be logged into a database that will add this onto existing records that I can view for instance pull up a sheet that has the number of balls a team has scored over the regional or how many times they've hung total. I would also like to be able to pull up the sheet that was filled out for each individual match, but have it be basically read only so that nothing can be changed to it, and also be able to archive photos of the team for a better view of them than just a list of features. This is a long list of things, but things I feel are basic to any other similar scouting system, and I hope it gives you guys a better feel of what I'm looking for

Also if anyone has something else that they use I would be glad to hear about it. Any help is appreciated.