We are amongst top 1% global outsourcing providers. We have successfully finished over 430 projects in last 13 years.
ID : 11588499
Greetings,
We are interested to work on this project, please find my comments inline with yours,
1. Database Structure - Simply Answer Questions About How to Set Up Properly
=> OK, we can help you or do it for you.
2. I have never done any database work before so need advice on what database to use (SQL, MySQL, Access, something else?), how to structure the data to get the information I desire, how to effectively query the data (Access, Excel, something else?), where to store the data (offsite, on laptop, etc.).
=>Access database is more efficient because all the tables ,forms, macros ,reports ,queries are in single file. Whether to use Microsoft Access, Excel or MySQL/SQL Server depends on the no of users being using the database at any moment. For example if its single user you can use Excel or Microsoft Access. If its between 3 to 5 users Microsoft Access will be OK. But for more than 5 users con-currently one has to go with backend Server database like MySQL or MS SQL Server .
3. Must be able to add additional/new data to database while eliminating duplicates existing in the new data.
=>Yes ,what additional data to be add? How much data you want to add over the period ? for large data even though you are planning to use single user, it is better to use Server database like MySQL or MS SQL Server which are more reliable.
4. Must be able