Unanswered: What to use to collect data whilst SQL database being created
I have just started in a brand new role where I need to collect a large amount of diverse data. Part of this data is whether the steps in a guideline has been followed ( a simple check box or yes/no) (but there are maybe 100 guidelines)
My IT department have suggested we use SQL to create the database, but this will obviously take time. In the meantime my boss is keen that I get on with the data collection before the database is ready. I do not want to repeat steps when I create the SQL database so is there any format you would recommend I collect my data in now that can be easily applied to the SQL database - ie if I used Excel, would that be best, and should I then try to keep potential SQL table data separate?
Sorry if that does not quite make sense - I'll happily answer questions to make it clearer
I would recommend using EXCEL. Setting up and utilizing the spreadsheet should also help in the creation/design of the SQL database structure. Then when all is done, the Excel Spreadsheet should closely match the SQL database, allowing for easy import.