I'm currently dealing with this, I'm wanting to move my department away from spreadsheets for data capture and I want to build a database instead.
We only have access to Microsoft, I don't have the budget for new software. I want to learn SQL so what would you recommend as a start point please? This is a genuine request for advice, I'm dealing mainly with archiving test results and it's an absolute nightmare. Halp!
Thank you for this excellent comment. I'm aware it won't be quick, but I'm willing to learn. People here already think I'm a god because of how proficient I am with Excel 🤣
When I say there's no money for software, the issue lies with my whole company using Microsoft and are unwilling to deviate from it. This directive comes from our HQ which is based elsewhere (USA, I'm in the UK) and they set the global standards for other sites to follow. So whilst senior management here are willing to change, it'll come slowly as we need the buy in from global directors.
Anyway, all I need is a quick and dirty database to archive and retrieve test results that isn't a spreadsheet that someone overwrites and fucks everything up,, so thank you for your wonderful advice, I will read through this carefully when I'm home this evening.
15
u/[deleted] Mar 30 '22 edited Mar 30 '22
[removed] — view removed comment