Build Microsoft Access Database
$250-750 AUD
Paid on delivery
I currently have 8 technicians who all manually populate a large portion of calibration certificates for service work. I need an access database created to reduce their input work and add some reporting functionality.
The system will be composed of 50 forms, each of these is for a different piece of equipment and I have all copies currently in word format as attached example 2100Q. The tech should be able to start a new job and fill in the customer address and contact or select from a previous list of customers. They will also enter the date, the form should have all other fields pre populated from the technician creating the job and specific certificate values related to the technician(highlighted blue on attached 2100Q).
Once the first form is created they should be able to keep creating certs under the same job reference number until completed. All or individual certs should be printable in PDF, I also need a query/report where I can search for certificates by job number, technician, date range or customer. A report needs to be created which populates like attached "example instrument list" from this information.
As mentioned above when the technician is selected their specific set of calibration figures will need to populate the document, I will also need a very simple interface that these figures are all mapped from another form as they get new standards every 12 months and I want to enter it on one form which populates all their certs. I have experience with all the systems mentioned but do not know access well enough to build this, I will be able to supply very detailed information and support to the designer and think this should be a fairly simple project for someone with the correct skill set.
I have an example of the layout/functionality also attached under the folder Files_14Feb
Project ID: #9948863
About the project
21 freelancers are bidding on average $729 for this job
Hi, I would like to discuss it further. I am good at MS access. Looking forward to understand the scope.
Hi Sir, I am highly skilled in Access database development and I can create the front end user input forms to make data entry quick and efficient. I have done similar work previously and I can do it with precision a More
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start
I am experienced in Ms Office automation tasks using VBA for Access and Ms Excel. I can conduct this activity in 10 days (I think that the lead time is optimal) if the requirements are clear and communication is seamle More
I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I More
Hi, I read through your requirement. I have 7 years of experience in MS advanced excel and access for Data entry forms /analysis/mining, reporting, charting, dashboards, pivots(powerpivots), scenario managers etc. I ca More
As a System analyst/Database developer, i have more than 10 years hands on experience in designing and developing relational database applications using Microsoft Access/VBA. I am highly knowledgeable in system analysi More
I provide accuracy and speed without compromising on quality of work. I am very competent with excel and access work and functions that will enable me produce a comprehensive piece of work.
I have 15 years of experience developing MS Access databases. I am familiar with building complex, multi-user, data heavy, flexible databases. After making an initial assessment, I have resolved that - if awarded the More