Find Jobs
Hire Freelancers

Access Database to create Smart Part Number

$250-750 USD

Closed
Posted almost 11 years ago

$250-750 USD

Paid on delivery
Project requires building an access database that can assign a unique identifier of 3 digits after answering questions to put proceeding identifiers - creating a "smart part number". All the questions need to be answered by drop downs to eliminate any variability. There are 7 fields that need to be selected prior to pulling the respective unique 3 digit number at the end that can be pulled sequentially. Then create a separate form that can be used on users computers that would just be able to look up the respective part number and This also needs to be set up to have a standalone form that can be used on multiple users' computers that can then run a check on a master list to see if the unique identifier exists. The master list location would be located on a share drive that all users would have access to. Then the use sees the part number and can hit a button to submit and there will be confirmation that the smart number was assigned. Also on the master list it must show that the part number was taken with a date and the user id as shown on computer if possible to drive accountability to what user pulled the part number. Require a user document on how to make changes if updates need to be made to the questions or outputs in the future. Examples would be to add style codes or other items, or change the dimensions that correspond to the letter.. Project duration - expected completion in 1 week from end of the posting. The attached file show the first 7 digits and what they correspond to on the selection.
Project ID: 4593495

About the project

22 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
22 freelancers are bidding on average $444 USD for this job
User Avatar
What version of MS Access you want the database be developed ? I assumed about 7 tables for this Smart Part Number creator database. We are amongst top 1% global outsourcing providers. We have successfully finished over 430 projects in last 13 years.
$594 USD in 12 days
4.9 (334 reviews)
7.7
7.7
User Avatar
MS Access expert here. I have done a lot of MS Access projects here in freelancer. Please see my profile for more details. Thanks
$388 USD in 3 days
5.0 (67 reviews)
7.0
7.0
User Avatar
Dear, I am Access/VBA automation Expert since 10years. I can bring you solution to allow multi-user tool, with your master list. I will be available after development, as support. Regards, Fabrice
$262 USD in 6 days
4.8 (91 reviews)
7.4
7.4
User Avatar
I have expertise with Microsoft Access. I read your requirements and can do this project. Looking forward to hear from you.
$526 USD in 5 days
4.8 (104 reviews)
6.6
6.6
User Avatar
My experience and feedback hope will convince you to start a very productive collaboration. Thank you
$388 USD in 7 days
5.0 (134 reviews)
6.3
6.3
User Avatar
Hi, I have 12 years experience developing MS Access applications and could do this project for you within a short time frame. Please view my portfolio for some examples of my work.
$300 USD in 5 days
4.9 (23 reviews)
5.5
5.5
User Avatar
Hello, After reviewing your project posting, I believe that I am well suited to fulfill the project's requirements and am thus submitting my credentials for your consideration. My development history in a nutshell... I have been designing and developing MS Access applications since its initial release back in '93. At the time, I was running the Legal Dept. at Logitech, Inc. and began by developing the Docketing and Invoicing system for one of the patent attorneys representing our company. I then left Logitech to develop full time. My first gig was with the Access Development team at Digital Equipment Corporation out of Livermore, California. There I worked on various projects for the silicon wafer manufacturers in the area. I then moved over to Hewlett Packard where I worked on an Oracle/Access application to control product data flow between their 40 plus manufacturing plants. During the next several years I continued to increase my expertise and to provide my services to a plethora of clients in the Silicon Valley area including: Chevron, E*Trade, First Republic Bank, Wells Fargo Bank, Bank of America, Bridge Bank, BEA Software, Baush & Lomb, HealthNet, and many, many more that can be seen on my attached resume. During this time I worked on applications within a multitude of industries including: Health Care, Banking, Insurance/Risk Management, Retail, Hotel Management, Real Property, Medical Research, Optical Care, Manufacturing, Technology, Consulting, Education, Training, Charities, Chemical, Sales and Marketing, Governmental, Oil and Gas, Stocks and Bond trading, Construction, Recycling, Data Processing, Legal, and others. Thank you very much for the opportunity to bid on this project and I'd love to learn more about your project and to work with you towards making your requirements a reality. Many thanks, Drew
$555 USD in 7 days
5.0 (6 reviews)
5.4
5.4
User Avatar
I have 15 years exp in access. I can create the database you need. I will send a sample shortly. Donna
$444 USD in 7 days
4.5 (34 reviews)
5.8
5.8
User Avatar
Hello, I can help.
$555 USD in 10 days
4.8 (4 reviews)
3.8
3.8
User Avatar
Hi, Ms Access expert having 8+ years of IT experience. I have gone through your requirement and will be able to help you in developing the application. Please see your PM for more details.
$333 USD in 10 days
5.0 (8 reviews)
3.8
3.8
User Avatar
Hi I am experience freelancer here I can do this project with all features. Thanks
$263 USD in 10 days
4.7 (23 reviews)
3.9
3.9
User Avatar
Hi! I can do this for you. Please see PM for details. Thanks! David
$250 USD in 7 days
4.4 (6 reviews)
3.9
3.9
User Avatar
I will bring very strong Ms Access Skills (All Versions) to bear on this project should you elect to award the project to me.
$278 USD in 7 days
5.0 (2 reviews)
3.0
3.0
User Avatar
Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and technologies, Veltrod provides high-quality software development and BPO services to independent software vendors and enterprises. We are specialized in developing Mobile applications, Search Engine optimizations, Social Network frameworks and ERP applications. We are pleased to take care of this project, if it is offered to us. We assure that we will work towards 100% client satisfaction. Thanks
$721 USD in 25 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Access experience
$500 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
20+ Yrs. experience developing IT Solutions using Microsoft Technologies. Expert in Forms Design and Database Management.
$555 USD in 3 days
5.0 (1 review)
0.2
0.2
User Avatar
We have experience in relational databases and user interface design. Based on the information you have provided, we would look to create a simple database consisting of user forms and admin functionality. Please see PM for more details.
$777 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Iam expert database developer using ms access reports and forms with complicated sql statements. I have developed many applications where user generates reports based on various criteria. I have developed an inventory management system for a manufacturer who brings in raw material and sell finished product. In this process it generates unique material code for the raw material and generate one unique code for the finished product. Iam pretty sure that i can develop a solution which fulfills all yours requirements. g
$555 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sou especialista em Access, desde 1999 trabalho com esta plataforma.
$277 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 8 years commercial experience with MS Access. I can start work on the project immediately. If required I can show previous examples of my work.
$444 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Peoria, United States
0.0
0
Member since Jun 5, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.