There are 10 Users in my company. Each one has around 100 transactions which will be updated into an excel worksheet by the system. I need a form in MS Access. That form should be linked with the particular Excel sheet. So my people will open the form in Access DB and find the particular transaction ID in the form cell. If they want to change the status for the particular trans line. They should be able to do it.
Whenever I want to know the status I should be able to view it by clicking the button in MS-Access.
MS-Access should provide me a chart (graph) whenever I want to know the trend.
Need to create a Database form in MS access.
Hi,thanks for reading my bid, Excel and Access VBA expert here, hav understood your requirements, i can develop a dynamic access and excel application for u that are connected.
Hello -
I am interested in working with you to complete a MS Access database that will meet your needs today as well as be easily expandable to future needs.
I have worked with Excel and Access together for almost 15 years.
I'll need a sample of your excel sheet to get started.
I look forward to hearing from you soon.
Thanks -
Janet
Dear moimbu,
I can help you quickly and cost effectively design and develop a Microsoft Access database/system that satisfies all of your requirements for your Microsoft Access database/system for your business.
I have been designing and developing Microsoft Access database(s)/systems for over fifteen (15) years.
I look forward to hearing from you and working together with you towards the successful completion of your project soon!
- Michael S. DeVries
Greetings Client,
I will be able to help you with your project request.
I will provide you with a very robust and accurate project output.
I have over 7 years of experience in Excel,Access VBA. I have developed and managed database and automated reports for different projects.
Regards
Mukul
Dear Sir,
I am expert of MS Access. I did previously this kind of database lots. If you give me the chance I will do it properly as your said time and also as per your requirement.
Pls see my PM.
Thanks
Pradip
I have recently done a very similar project - let me do this one right for you. It kept a list of Excel worksheet quotes in Access. I am new to this freelancer site but have been working sucessfully as a freelancer under the Digressoft name for 15+ years.
I have done forms in both Access and Excel. Creating the forms and importing the data into the database is easy enough. Defining the parameters of the database is where most of the work would be. I have fifteen years of database design and management, and have set up both large and small systems. Feel free to contact me for a free consult. Once I know more about the project I will be able to give a proper bid with a more realistic timeline.