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.

[Fennig247]

I know this sounds weird, but my team Da' Bears, we use a hand made program from Visual Basics that I made that would do all of that. But it is custom made for us because we only need to scout so much but I was using that with a database file made from microsoft access and that worked like a charm.

[Ben Martin]

I agree, Access can do all of those things without having to deal with VBA coding, which you might need to use if you want to do all the things you mentioned with Excel.

Access tutorials are all over the internet -- you will probably learn what you need to meet your requirements list faster for Access than you would for Excel.

If you would still like Excel scouting samples though, CD media is full of them.

[Cartwright]

The database that you are describing sounds almost exactly like the one that we on Cyber Blue are using. It has the pictures, the match breakdown, the pit scouting, everything. If your interested in seeing it, I can send you the file. It works best with Office 2007. What's really nice about the database (actually we have to give credos to BMartin 234 because he did the grunt work on it), is that it can be changed to scout any first game with the 3 vs. 3 style of play.

[Rion Atkinson]

Originally Posted by Cartwright

The database that you are describing sounds almost exactly like the one that we on Cyber Blue are using. It has the pictures, the match breakdown, the pit scouting, everything. If your interested in seeing it, I can send you the file. It works best with Office 2007. What's really nice about the database (actually we have to give credos to BMartin 234 because he did the grunt work on it), is that it can be changed to scout any first game with the 3 vs. 3 style of play.

I may not be the OP, but I would be very interested in seeing this. I have been considering how to make a scouting program this year and I am looking for examples. Do you think you could email it to me as well?

[jamie_1930]

Originally Posted by Cartwright

The database that you are describing sounds almost exactly like the one that we on Cyber Blue are using. It has the pictures, the match breakdown, the pit scouting, everything. If your interested in seeing it, I can send you the file. It works best with Office 2007. What's really nice about the database (actually we have to give credos to BMartin 234 because he did the grunt work on it), is that it can be changed to scout any first game with the 3 vs. 3 style of play.

I imagine it would be similar great minds think alike, and I would love it if you would send me the files.