Kapalı

Write some Software

Hello,

I need to be able a custom ACCESS tool for inventory. Let me walk you through what I envision.

I have two tables with information:

Table 1: Employee ID Number (Name, Last Name, Hired Day, ID Number)

Table 2: Inventory ID (Inventory number, details)

Example:

The employee scans his/hers bar code number. Access looks up the person in Table 1 and based on that it populates the name of the person (name and last name). Access gives you THREE options to follow up that:

A) NEW CHECKOUT B) RETURN C) REPORT A PROBLEM

If the person clicks on "A" "NEW CHECKOUT." The person then is prompted to scan the barcode on the product. Access looks on Table 2 Inventory ID. and matches that number with the product. The product CAN'T already be checked out, and times stamp the [url removed, login to view] creates a list (Table 3) of the product that was checked out, with the following information:

RESULT from A): Employee ID Number, Name, Last Name, Day and Time Checked out (all this recorded on Table 3).

-------------------------------------------------------

If the person clicks on "B" "RETURN" The person then is prompted to scan the barcode on the product. Access looks on Table 3 Inventory ID. and matches that number with the product that was already checked out. The product CAN'T be checked in if it was not checked out and records the time stamp of the transaction.

RESULT from B): adds this information to (table 3) in the respective field. OR creates "table 4" that records returns. If "table 4" is created, I need to be able to run a report that shows me all the checked out products and the returned products, names, last names time stamps of both actions.

-------------------------------------------------------

If the person clicks on "C" "Report a Problem" The person is prompted to write a paragraph of the issue. There should be a field for Inventory ID. So the person can report that a specific inventory had some problem or some other note. The inventory ID is not a mandatory field.

-------------------------------------------------------

Reports that I need to be able to create:

Report 1: Every Week product: run all the checked out products not returned and count days since checked out. Need the report to clarify that the report is updated as of (day when run).

Report 2: Number of products checked out and returned per employee. Need the report to clarify that the report is updated as of (day when run).

Report 3: (read below to fully understand this one). Be able to create a report based on Inventory ID. Lets just say, that location 1, has inventory from 00011 to 00200. Then I want them to just be able to run reports on their Employees, and who didn't return a list, who has, and how many everybody has done (same as Report 1 and 2 but for the current location).

Report 4: report per location. With that just names each report w a title of the location (North, South, SLC, SLC2, VOLUNTEER). So we can see the same info per each of those.

I need to be able to use barcode bars, and also I need to be able to type the numbers in case the bar code is not working. I need the part of the form that asks for the three options: A) NEW CHECKOUT B) RETURN C) REPORT A PROBLEM be simple to use, clean and sort of pretty. Hopefully. no need for scrolling or TAB but that can be arranged.

I envision this to be on a computer next to the inventory pile, and run from there, but there is a chance that I will need this to run from ACCESS online web tool. Because I may have 4 locations using the same Tables 1 and 2, and I need to be able to pull Table 3 (and 4 if is there), and I need to be able to run reports Report 1 through 4 from home base (SLC).

I hope I explained this clearly. Let me know if you have any questions.

I am not opposed to have a web tool (as long as I can password protect it). I don't want to compromise my lists.

Beceriler: PHP, Yazılım Mimarisi

Daha fazlasını gör: software development info, i need to write a letter to my friend he passed grade 12 i write a letter to him about my 3rd time failure in grade 10 and my fe, write an article suitable for publication on the issue of the youth employment and suggest how these can be promoted by the vari, php, software architecture, write a dialogue in wich you meet this person by chance and you talk together about the time the person helped you, write a program to generate a optimal binary search tree for the given ordered keys and the number of times each key is searched, write a program to generate a optimal binary search tree for the given (ordered) keys and the number of times each key is search, mobile phone paragraph write, software design info, write applet initially hello, paragraph write english, ccbill form write info database, write javascript code window shows key pressed, write info database, software write mq4, software write chip epson, useful software write book, software grabs info site, software write web specs

İşveren Hakkında:
( 2 değerlendirme ) Salt Lake City, United States

Proje NO: #12911880

Bu iş için 26 freelancer ortalamada $321 teklif veriyor

graphicaa

Hello, I can give proposal for webtool with access protection, Please let me know if i am in your shortlist - i can submit my detailed proposal. Thanks, Sathies

in %bids___i_period_sub_35% gün içinde600%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(454 Değerlendirme)
8.5
michale21

Dear Project Manager, Greeting from Votive Technologies!! I just came across this requirement and wanted to have a brief conversation with you on the subject. We are the expert WordPress Development and Desig Daha Fazla

in %bids___i_period_sub_35% gün içinde1000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(335 Değerlendirme)
8.5
webbookstudio

Hello, my name is Olya. I represent Ukrainian IT Company «Webbook». We provide website design and web and app development services for organizations, public and government institutions, company or private web-pages. Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(59 Değerlendirme)
7.2
Rahulkeshwani19

SALUTATION Hello Dear, We initially started our startup with 5 clients and 10 team members. Today after 8 years, we have over 224 satisfied clients and 41 members in our team. Our main focus is on to bui Daha Fazla

in %bids___i_period_sub_35% gün içinde1500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(77 Değerlendirme)
6.8
pytho

Hi, I am interested to work with you on this project, I reviewed the requests you listed and I would like to discuss further details with you. Since 2006 I am managing a Web Design Agency located in Romania, which cur Daha Fazla

in %bids___i_period_sub_35% gün içinde480%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(38 Değerlendirme)
6.9
fullymagento

Hello sir, I have reviewed your requirement and after understanding it well excited to work with you on your awesome concept.I would really love to speak with you further regarding this project, so kindly come in pm Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(49 Değerlendirme)
6.9
BitLabs

Hello, I have gone through your outsourced requirements "Write some Software " and have analyzed that I have right skills (PHP, Software Architecture) to execute your esteemed project. I will complete your projec Daha Fazla

in %bids___i_period_sub_35% gün içinde316%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(102 Değerlendirme)
6.4
techwelfare

Hi Let's clarify the requirement in details also if you want us to share our previous work let us [login to view URL] have a few questions about your project, please send us message so that we can discuss more. Thanks & reg Daha Fazla

in %bids___i_period_sub_35% gün içinde225%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(118 Değerlendirme)
6.8
hitech10

Thank you for your interest in partnering with Hitaishin infotech for your website development project. With well over 100,000 firms offering website development services, we know how challenging it can be to find th Daha Fazla

in %bids___i_period_sub_35% gün içinde263%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)
6.0
yogeshssanwal

I am Yogesh sanwal, 5+ years experienced in website and e-commerce development using PHP/MySQL and Internet Marketing. Take a look to my last work: [login to view URL] [login to view URL] http: Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(108 Değerlendirme)
6.0
websolutions008

Hi, This is angel from [login to view URL] We could provide a Software. We are a company located in India. Give us one good chance to provide our ability. See our recent website works [login to view URL] https: Daha Fazla

in %bids___i_period_sub_35% gün içinde266%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(67 Değerlendirme)
6.2
in %bids___i_period_sub_35% gün içinde255%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(57 Değerlendirme)
5.5
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde400%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(23 Değerlendirme)
4.8
cracken

Hi, I am well equipped to this kind of task and can handle it pretty well. In fact, I already done job related to this before. Let me know the best of your time so we can discuss further based on your requirements and Daha Fazla

in %bids___i_period_sub_35% gün içinde249%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)
4.6
kevivu

Dear Sir, I am based out of Jersey City, NJ, USA. Completed numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. You can refer my freelancer profile for reviews and Daha Fazla

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)
4.5
in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(40 Değerlendirme)
4.9
agodinhost

Hi, I can do it using java / mySQL. It would be a mobile / web application. The barcode reader acts like a normal keyboard, se there is no much concern about the scan. I need to know which kind of bar code you need ( Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
3.4
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(20 Değerlendirme)
2.3
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
1.4
WebApp4expert

Hey, Greeting of the day, I am konika. I was looking through your project requirements and I do believe it's something we have experience in previous development and we can complete in a reasonable amount of time and Daha Fazla

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
1.4