I figured out a preliminary database to build in MS-access. I didn’t have my MS-access database setup though properly and decided to just make screenshot annotations

I am not 100% sure how I will handle adding unique formula driven primary key. Like TRER-100 for TRER shortname brand + generic number identifier

Perhaps I should keep it simple and just combine it with the actual model#.

I need a way to generate unique values for model#s somehow PER manufacturer (autonumber)

Not sure how that works

Or calculated totals

I will also check out MySQL sample databases to see if it has more powerful intuitive tools (mySQL workbench)

I haven’t figured out how to add and update data and maintain consistency either

Probably through an excel workflow (reprocess garbage data) into access / mysql (highly refined data)

Resources

  • None

Vincent Tang

Comments