Access Database to create Smart Part Number

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.

Skills: Microsoft Access, Software Architecture

See more: access database project document, microsoft number, access database software, smart it, microsoft share, variability, make smart, change project duration, c# with access database, c with access database, access database, access form standalone file, smart project database, smart database, project 2013 access, drop list database, selection access, check assigned number, number look, creating master database, access 2013 create button, create button access 2013, drive letter access, computer architecture project, create codes access

About the Employer:
( 0 reviews ) United States

Project ID: #4593495

23 freelancers are bidding on average $436 for this job


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 More

$594 USD in 12 days
(355 Reviews)

[login to view URL] I have gone through your project requirements and the excel file on how to calculate the smart part number. These things I will do on sharepoint server. Have you bought space there in Microsoft site? If yes More

$555 USD in 3 days
(509 Reviews)

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
(41 Reviews)

My experience and feedback hope will convince you to start a very productive collaboration. Thank you

$388 USD in 7 days
(148 Reviews)

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
(32 Reviews)

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
(58 Reviews)

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 nutshel More

$555 USD in 7 days
(6 Reviews)

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
(13 Reviews)

I am a Senior Software developer with 20 years experience of Microsoft Access. Please see your PM for more info.

$255 USD in 7 days
(3 Reviews)

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 Reviews)

Hello, I can help.

$555 USD in 10 days
(3 Reviews)

Hi I am experience freelancer here I can do this project with all features. Thanks

$263 USD in 10 days
(20 Reviews)

Hi! I can do this for you. Please see PM for details. Thanks! David

$250 USD in 7 days
(3 Reviews)

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
(1 Review)

20+ Yrs. experience developing IT Solutions using Microsoft Technologies. Expert in Forms Design and Database Management.

$555 USD in 3 days
(1 Review)

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 t More

$721 USD in 25 days
(0 Reviews)

Access experience

$500 USD in 4 days
(0 Reviews)

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
(0 Reviews)

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 P More

$777 USD in 7 days
(0 Reviews)

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 inve More

$555 USD in 3 days
(0 Reviews)