Does anyone know of a good database template for personal collection tracking? Either Access or SQL preferably. Looking for Model, Serial #, purchase date, price, round count, etc.
Sorry. On a PC and local only.Need more info.
You Want to run this yourself on...
pc, Mac, need it Internet based, iPad or phone friendly?
Do you just need a database only or do you need the user interface?
Are you going to do manual entry directly with sql or do you need a program or website running locally with a user interface?I appreciate the advice guys but I specifically wanted a db.
1. I wanted a local copy only and nothing in cloud.
2. I need to brush up on my db skills and this would be a database I would enjoy.
That is really what I was looking for.Sounds to me like he just wanted a project so he could practice. Easy enough to create a table and use Access or other as a front end. Definitely a lot just to track inventory and rounds counts but it will allow him to brush up a little.
There are probably templates you can use but, if you know how to build tables, queries, and ODBC calls it would probably take less time to build from scratch than to modify someone else's stuff for the few fields you mentioned. Might also be good practice.That is really what I was looking for.