Help with creating database

[SamP]

Hopefully someone might be able to help me or tell me if what I'm hoping to do is even possible.



I'm a part of a sporting organisation that uses online player registrations. We are moving to a new system and the brains behind it all have decided to not transfer existing data to the new system. I have exported the data that I need out as an Excel spreadsheet, but what I'd really like to do if it is possible is have an Access database that can't be updated as the data is only for historical purposes, but when I (or anyone else I need to give it to) open the file it automatically opens with a search screen where I can search on columns of the player surname, first name, ID number and maybe even team. Is this even possible? I'm sure I've seen something like this somewhere, which is where I got the idea from.

[June7]

It's certainly possible. The effort could be a substantial investment of time.

You can import the spreadsheet into Access. Then see if this gives you ideas: http://www.datapigtechnologies.com/f...earchform.html

[SamP]

Thanks for that. If my big idea is a bit grand, is there a simplier way to do it? Sorry I'm not great with Access and in fact haven't used it for probably 15 years.

[June7]

Actually, if you have only the one table (big flat file) and don't have need to normalize data, might not be too involved after all. No, I don't know a simpler way.