1. Import data from a structured multi tab excel sheet into access database
2. One tab will contain equipment data, the second tab will contain the questions per equipment, the third tab will contain the field names of the first tab ( max. 20 )
3. The filed names in the third tab of the excel must become the labels of the field on the input screen ( max 20 )
4. After import there must be one or more input screen displaying all of the questions. These questions must be answered by OK , NOK , N/A , with each question remarks must be possible
5. The number of questions on the input screen must be dived
6. After all the questions are answered the logged in person must decide to store the data or not, if the data is saved it must have a date stamp and a person attached to it.
7. After the run all the data must be exported to a same excel sheet with all the found data, a tab per equipment giving all of the questions with the result s. Also an overview tab listing all the equipments with a statement if it has been inspected or not.
8. The first screen must show a choice between languages ( Dutch / French / English / German ). One time only. According to this choice 40 standard questions must be loaded.
9. The questions from the excel sheet must be loaded afterwards totalling the questions to 40 + the number in the excel sheet.
10. Output must be to excel format giving all results of all equipment .
11. After initial opening of the program the login must be personalized.
We can work in your Questions Program . I am a leader of the team. I have 14 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT. Please contact me to clarify all details. You can see an example of our work in [login to view URL] User: admin Password: admin2012.
€190 EUR in 7 days
4.5 (18 reviews)
5.4
5.4
21 freelancers are bidding on average €161 EUR for this job
Hi,
I have gone through your requirement and I am glad that We can accomplish
this task, Please give us opportunity to work with you.
Please check PM .
Thanks,
TTS Team
Hello. I am an MS Access and Excel expert with a UK BSc. Computing degree, and over eight years of professional IT work experience. Please refer to my private message for further information. Thank you. Kind regards.
I can help you out on this.
To me it seems that only VBA code in Excel and Access will do.
One of my last projects contained an import and export functionality from Access to Excel and vice versa. Also different languages were included and the solution had a log on screen and authorization possibilities.
So you are asking for a program that reads labels and questions from an excel file and displays them to the user. And then the user inputs the answers and they are recorded in the same excel file in a specified format. It'll be our pleasure to do this for you :)
Hi,
I have a large experience in working on .net, acess database ans excel files, I am working with these tech. since three years every day. I can garantee for you a good quality of work.
I am looking forward to begin working for you.
We have good exposure in online exam website. Already we have created same online exam website which you are expecting. Please visit the below website which we developed.
I didn't completely understand the process but it won't affect my bid. I need to see an example of a real spreadsheet to understand how it will work. Access and Excel work seamlessly through VBA so however the process should work I'll work it out to your complete satisfaction with G-d' help.
I have ten years experience in Access Databases. I studied your project description. I Can do this job. For more details I am available on chat.
Waiting for your response. Thanks