In Progress

Creating inventory database with basic calculations/reports

Here is the basic setup and purpose of the database: I currently have about 150 different inventory items that I want to keep track of in a database.

1) These items will need the following fields: name, weight, price (this field will be derived from a formula), diamonds, labor, profit, and product description, also a place where i can import images of these items. (I have included an spreadsheet with all these fields already filled out)

2) I want the database to let me search for an item code and be able to pull up all the specs of the item i listed above (weight, labor, etc), and in addition, be able to view a picture of the item

3) I want the database to be able to calculate and fill in the PRICE field for me of individual items, based on the numerical fields I've listed above (i will give you the formula for calculating prices once the project has started), and give the prices to me in a report when i try and generate one.

4) I want the interface of the database to be simple, so I can easily add new items to the inventory database when I need to. So please add a form to input new items.

I am looking to do all this in Open Office base (preferably), or possibly Microsoft access.

Skills: C Programming, Microsoft Access, Software Architecture, SQL

See more: creating inventory database, programming database, programming basic, programming access database, numerical programming, name diamonds, microsoft project import, microsoft access programming, database programming sql, open office project, microsoft project price, need microsoft office, sql database report, product inventory, inventory database, import database, diamonds, database calculations, creating sql, calculations, calculating, access creating reports, calculate different, programming microsoft access sql, basic programming database

About the Employer:
( 30 reviews ) Chicago, United States

Project ID: #1090086

Awarded to:

florinserban

Hi. Please check PM for details. Thanks!

$120 USD in 3 days
(16 Reviews)
4.5

24 freelancers are bidding on average $153 for this job

rhomeu

Advanced MS Access developer here. MS Access is the best solution to your requirements. Please check my profile/portfolio, work done and private message box.

$250 USD in 2 days
(41 Reviews)
6.5
eperfections

We have developed many similar applications which previously existed in Excel ! We are very confident to get this working as well !

$150 USD in 3 days
(142 Reviews)
6.4
amnmttl

Please check PMB for BID Details Ready to start right away

$115 USD in 5 days
(21 Reviews)
5.0
instech

Please see the PM for comments and sample

$160 USD in 4 days
(9 Reviews)
4.9
rbenfield

Hi there, I'm a Microsoft Certified Systems Engineer and Professional Access Developer. I can create this database for you no problem. Many Thanks, Rich

$120 USD in 3 days
(8 Reviews)
4.7
cygital

Let's do it.

$200 USD in 5 days
(5 Reviews)
4.2
ifaisal

Hello I can do this for you. Please see my private message for more details. Regards Faisal

$100 USD in 3 days
(9 Reviews)
4.1
PerfectSquare

please see the PM

$150 USD in 5 days
(26 Reviews)
4.1
DeoTech

Hi! I want offer C# + MS SQL Compact. It will portable smart client. Only framework 2.0 need. If you whant, i can create simple sample in ASP.NET and you can see how it will be. Regards.

$200 USD in 4 days
(5 Reviews)
4.1
bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$250 USD in 7 days
(5 Reviews)
3.9
superMena2001

sir please check your PM

$100 USD in 1 day
(4 Reviews)
3.3
SajjadHussain14

Please check PM

$170 USD in 10 days
(2 Reviews)
3.2
JohnInFL

Please see PMB for a detailed proposal, thank you.

$230 USD in 7 days
(2 Reviews)
2.3
yehia111111

Hi,Kindly check your PMB

$90 USD in 1 day
(2 Reviews)
1.9
bestappdev

I've over 12 years of experience is developing Access solutions for a range of businesses from small to enterprise. I will build a solution using best practice while still allowing it to be easy to use and maintain. I More

$100 USD in 1 day
(1 Review)
1.2
kvkrao1951

Please see PM

$150 USD in 15 days
(1 Review)
1.4
MalithJ

i can do this for you.

$80 USD in 10 days
(0 Reviews)
0.0
mshahadi

Hello! Please check PM.. BR.

$160 USD in 5 days
(0 Reviews)
0.0
jmontesp

Hi, expert programmer willing to work with you.

$250 USD in 7 days
(0 Reviews)
0.0
shreerg

I can do this. I have worked before on this type of project

$150 USD in 7 days
(0 Reviews)
0.0