Closed

Create a Tool for Data collection

We require a tool to capture some information and to retrieve the required information (using search criteria) as and when needed. Ideally, the front-end of the tool will be a VBA form with fields to capture the required information and the backend will be Microsoft Access Database(2007). The VBA form will need to have a “Submit” button, so that once the user fills in all the fields and clicks it, all the information will go to the Access Database. The form will also need to have a search field so that we could fetch the data using any of the search criteria (eg: First Name, Last Name, Address 1 etc.) and could be exported in the form of an excel spreadsheet. In addition, the tool will need a user credential system in place, so that only the admin(s) could fetch the reports and others could only do data-entry

More details will be provided soon

Skills: Microsoft Access, SQL, Visual Basic for Apps

See more: sql data entry form, microsoft access data entry form, excel data entry form 2007, data entry in excel 2007, data entry in access 2007, data entry form access 2007, create excel form for data entry, create data entry form in excel, create data entry form excel 2007, create data entry form access 2007, create data entry form access, create an access form for data entry, create a data entry form, access database data entry form, microsoft excel VBA, vba access excel, microsoft access vba, fetch data, excel vba data entry form, data entry SQL , data collection needed, create a excel, create data entry form sql, access reports data entry, create access database reports

About the Employer:
( 0 reviews ) Kerala, India

Project ID: #7644661

17 freelancers are bidding on average $82 for this job

illuminesoft

ID : 7644661 Greetings, We are interested to work on this project, please find my comments inline with yours, [url removed, login to view] require a tool to capture some information and to retrieve the required information (using search More

$111 USD in 3 days
(310 Reviews)
7.6
fabest

Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access DB. with search function. I will focus on user friendly interface. As you can see I have ver More

$94 USD in 2 days
(22 Reviews)
5.7
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft More

$150 USD in 10 days
(27 Reviews)
5.2
dipakmoliya

Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you require a tool to capture some information and to retrieve the required information (using search criteria) as and when More

$55 USD in 2 days
(33 Reviews)
4.8
zExcel

A proposal has not yet been provided

$150 USD in 1 day
(16 Reviews)
4.6
farr4u

HI, Access and Excel VBA expert here, I offer you access application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, these forms will be for performing data More

$77 USD in 6 days
(20 Reviews)
4.4
abhinovpankaj

Hello, I have been working with a MNC based company since last ~ 4 years, as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Prod More

$67 USD in 3 days
(2 Reviews)
2.6
aleator

Ready to do this job. So far I have only some closed projects in Access. Maybe your project will be the next? From the Access, of course, familiar.

$35 USD in 1 day
(3 Reviews)
2.0
ENRICOJ

HI.I HAVE MUCH EXPERIENCE IN ACCES AND CAN PROVIDE YOU A SOLUTION WITHIN IN A REASONABLE TIME. PLEASE APPROACH ME FOR FURTHER ASSISTANCE. KIND REGARDS .ENRICO

$30 USD in 1 day
(1 Review)
1.2
paricoto

Hi there - My name is Paul. I have more than 25 years experience in designing and developing MS Access applications especially for small and medium sized enterprises. I’ve read your brief and would approach your projec More

$150 USD in 7 days
(2 Reviews)
1.4
badawyhisham

I am experienced C++ and Ms Access programmer. I attached a demo for the job. The demo displays a form to search and filter access table. It selects three fields to search for. You can search by each field or you can More

$55 USD in 4 days
(0 Reviews)
0.0
ckfeher

34 + years experience, successfully deploying database solutions. 23 + years programming with Access. All kinds of solutions, for a wide variety of satisfied clients. For this Project, I suggest using MS Access, More

$133 USD in 5 days
(0 Reviews)
0.0
antonmartyniuk

Предложение еще не подано

$25 USD in 3 days
(0 Reviews)
0.0
christianvaleria

I have much experience in software development and in my current job I created many applications in VBA environment.

$100 USD in 3 days
(0 Reviews)
0.0
UncleRory

I've created numerous user front ends, connecting a User form into both Microsoft SQL and Access. The main way of managing user credentials is by having rights stored in the user form it self, and then password protect More

$45 USD in 3 days
(0 Reviews)
0.0
stork1990

Hello, I have a few questions/suggestions. Is the Access DB going to be new or something that is already existing? Will the DB only be stored and accessed on one machine? I would suggest using MSSQL Express edit More

$45 USD in 2 days
(0 Reviews)
0.0
Tonytone123

did something like this recently to be uploaded to our sharepoint. this should be a quick fix. And if i can understand how this will be used we can look at report creation, etc

$55 USD in 3 days
(0 Reviews)
0.0
NickBond

I have over 2 decades of experience with Microsoft Access and VBA and I'm currently operating Access 2013. I am able to clear time to dedicate to this project for a quick resolution.

$88 USD in 1 day
(0 Reviews)
0.0
oct13saurabh

I have developed a sample vba form, which can feed information in to Access database and can retrieve database information and display on excel. I have done so many similar task.

$25 USD in 3 days
(0 Reviews)
0.0