Generally dataflow for work, RDBMS setup usingn MSaccess/excel for small manual data input, excel for processing garbage data into nicely refined data, and Microsoft SQL 2016 locally to manage queries for data

Some information not entirely sure of, such as the relationships between MSaccess vs. Microsoft SQL 2016 and general querying structures

Will figure it out as I need too

Layout of RDBMS and relationships of data, I’ll keep it mostly done via MSaccess since I’m the only user using it. Most queries controlled here if exporting to excel.

MS-SQL is mostly to run ETL for databases to get updated list prices, and if needed manage ODBC connection to adobe indesign/ 65 bit software

I do not intend to have any relationships between Excel to MySQL most likely to keep it simple (KISS)

Resources

  • None

Vincent Tang

Comments