| Author |
 Replies: 9 / Views: 7,003 |
|
|
Pillar of the Community
United States
3402 Posts |
Hello  Group: I'm considering using MS Access as a database for my world coins. I would also like to include pics associated with some coins. I have a book on Access which I plan for summer reading, but am very open to pre-reading insight from group members. I have about 20,000 or so coins, many have duplicates with different grades and therefore different values. Ultimately I would like to create a website  which would be designed around my MS Access data base, with a shopping cart for purchases. Can this be done, possibly using a web template design (Wordpress, Wix, Square, etc.?)  Thanks KK  OOPS, forgot to ask...would excel be easier to do this with? Edited by Kopper Ken
03/22/2018 11:38 am
|
|
|
|
Rest in Peace
United States
17900 Posts |
I've use excel especially constructed by my wife who is a whiz at database programs.
I tried to make one that worked and after many hours of frustration asked my wife who set it up in about three minutes.
I'm fortunate.
|
|
Forum Dad
 United States
24154 Posts |
It absolutely can be done, the first year this website was active we used an access DB, outgrew it quickly though. They get squirrelly as they get bigger. MySQL DB usually comes free with basic hosting accounts and it's a much better choice.
|
|
New Member
United States
25 Posts |
I use a product called Coin Manage by Liberty Street Software for my USA collection. It is based on MS Access. You may be able to expand it to meet your needs saving you a boat-load of programming and coding time. It has specific tables and fields for various countries. Just a thought.
|
|
Pillar of the Community
United States
1745 Posts |
I use MS Access as my coin database. I do not incorporate pictures. Along with a unique ID, I keep track of: Year, MM, Type, where kept (2x2, album, etc), denomination, Notes, Grade, qty, price paid, retail price, Sell?, selling price. I use this with my eCrater site to manage my herd. When I want to sell, I take pictures and post to eCrater. Right now, I have around 3200 records. It has worked well for me, I can create reports and views tailored to what I'm interested in.
|
|
Forum Dad
United States
24154 Posts |
The OP is looking at using it for a website eventually though.
|
|
Pillar of the Community
United States
589 Posts |
Where a website is concerned, PHP with a MySQL or SQLite database works. MySQL is arguably better, but SQLite can be worked with offline by use of SQLite Browser.
And then build a website around that.
|
|
Forum Dad
United States
24154 Posts |
SQLYog can do MySQL locally. I use it all the time.
|
|
Pillar of the Community
United States
507 Posts |
I use mysql as a database, and have learned some basic PHP to make webpages to display my collection. For now it is just local but could be shared as a regular webpage easily.
It's not easy in that you have to get the SQL and website hosting programs, not to mention spend a lot of time learning basic code writing. But it is very versatile and expandable.
I use it to search if I have a coin in my collection at all, and if I have a photo I can tell if the coin I'm interested in is better or worse than the photo.
The photos themselves are not in the database but the pathway to the photo is.
I can pull up reports like all coins of a certain time frame, denomination, country, composition, square, holed, bimetallic, etc. Basically once you make a database category you will be able to use it in searches.
I can also use it to print flip inserts.
I never used MS Access so it may be able to do all of those things but if you read about mysql you will see that it is made to work well with webpages. It is also free, and most of the code or plugins you find will work with it.
-wheatiefan
|
|
Pillar of the Community
 United States
3402 Posts |
Thank you all for the advice. I will look into mysql.
regards,
KK
|
| |
Replies: 9 / Views: 7,003 |
|
Posted 03/22/2018 11:37 am
