Closed

Drug Inventory Database in Access

I'm looking for someone to design a simple database in Access 2007.

There will be 4 main data sets and a series of reports.

1. Drug information - 7 pieces of information about a particular kind of drug

2. Drug order screen - a screen to record information about types and quantities of drugs being ordered in a particular invoice. (4 pieces of info)

3. Stock received screen - a screen to record what drugs are supplied in an order (not all are supplied)

4. Stock finished screen - a screen recording drugs as they are used (two pieces of information)

Reports

1. Drugs by order number or date

2. Order history for each drug

3. Generating a list of drugs ordered and not received (comparison between 2 and 3 based on invoice number)

4. Geneerate a list showing drug, batch number, time received, time completed

5. Generate a list of drugs that were finished after their expiry data.

6. Drug report on near expiring dates.

Winning bidder would set up tables. Design forms for data entry and preset the reports.

Would like a user friendly interface that allows rapid data entry without being intimidating. Potential use of Scanning barcodes or to generate barcodes according to data entry?

Looking for 1-2 week turnaround.

Full specs will be available to the winning bidder.

Skills: Data Entry, Data Processing, Windows Desktop

See more: drug inventory database, drug inventory, design drug inventory database, types drug inventory, access drug inventory database, rapid 7, drug design, data entry access 2007, data access interface, batch data entry, access drugs stock database, access database drug inventory, drug inventory access database, drug inventory access, screen recording, invoice processing, inventory database, drug, database info, access reports data entry, data entry inventory database, database design record, database design stock data, access order, simple access order database

About the Employer:
( 0 reviews ) Australia

Project ID: #1118875

30 freelancers are bidding on average $206 for this job

StumpCreations

Please see PM

$600 USD in 14 days
(1 Review)
3.4
KellogITSolution

Hello I am bidding in response to your invitation and ready to start the work immediately. Plz check your PMB for more details. Thanks

$110 USD in 5 days
(7 Reviews)
3.4
msajaynath

Check pm for details.

$50 USD in 10 days
(2 Reviews)
2.5
frehmanpk

Respected Sir, Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy with attention to detail. Please see attached sample application that how much user friendly More

$200 USD in 7 days
(4 Reviews)
2.4
drchaz

Gold freelancer UK based; 2:1 BSc hons degree; 10years ms office experience advanced word, powerpoint and excel; vast editing and proofreading experience; transcription and audio typing experienced as medical secretary More

$250 USD in 7 days
(1 Review)
1.7
etindore

Please see PM

$80 USD in 7 days
(1 Review)
1.0
fdqrpsy9

Please check PM

$30 USD in 2 days
(0 Reviews)
0.0
rashedjoni

Hello,Please check your PM for details.

$65 USD in 11 days
(0 Reviews)
0.0
kapustinamd

Hello, I am very much interested in this project. I have completed many similar projects and can easily handle this task. I am ready to insert sample products for you and am ready to start immediately upon selection. More

$150 USD in 7 days
(0 Reviews)
0.0
neanicu

I am specialist in Access 2007 and VBA programming, with many project like this on portofolio. I am very much interested in this project. I am ready to work to the project.

$180 USD in 21 days
(0 Reviews)
0.0
VIJAY4VIJAY

ASSURE THAT I CAN FINISH UP OUR PROJECT IN VERY GENUINE MANNER. THANK YOU .

$123 USD in 11 days
(0 Reviews)
0.0
rafaqatkhan

Details Pls

$200 USD in 10 days
(0 Reviews)
0.0
shahid200529

Please See PM

$200 USD in 7 days
(0 Reviews)
0.0
mithi17

Dear Sir/Madam: As per your requirement I can fulfill the job types – data entry, data processing and window desktop. I had worked at the US Embassy, Kathmandu, Nepal, General Services Office as a Secretary f More

$60 USD in 3 days
(0 Reviews)
0.0
RubyAnn1029

can work fast

$250 USD in 5 days
(0 Reviews)
0.0
AREMUN

I am expert in Access as well Database packages i apply to do the job

$200 USD in 4 days
(0 Reviews)
0.0
nelson1812002

I have over 25 years' as a developer and CIO. I have created very complex, menu-driven, MS Access apps for large clients including AT&T, Cox Communications, and others. Let's get started.

$200 USD in 7 days
(0 Reviews)
0.0
GlazGo

Ready to help you! See PM/

$150 USD in 2 days
(0 Reviews)
1.3
cressidainfo5

please check PMB for more info thanking you

$200 USD in 8 days
(0 Reviews)
0.0
trupious

I give you exactly what you want.

$50 USD in 1 day
(0 Reviews)
0.0