Vcoderz Community

Vcoderz Community (http://forum.vcoderz.com/index.php)
-   E-Learning Center (http://forum.vcoderz.com/forumdisplay.php?f=33)
-   -   Microsoft Access tiny project[Item Sales] (http://forum.vcoderz.com/showthread.php?t=18462)

Tawa 06-08-2010 06:22 PM

Microsoft Access tiny project[Item Sales]
 
Hey guys, I'm working on a small Microsoft Access project. It's something for personal use. But I thought

Anyways, the database should include the following:
- Customers details
- Item details
- Item categories
- Item quantities in stock
- Selling invoices
- Printable receipts

Well the idea is that with every Selling invoice, the stocks change and all that.

The idea is simple.

Can anyone help me out here?

Thanks in advance for any help :D

ibllise 06-08-2010 06:36 PM

ever used rational rose???

SysTaMatIcS 06-08-2010 06:47 PM

new , business asset managment or somethin like that which will lead you to download a template from the internet . this would help alot.

Tawa 06-09-2010 11:06 AM

@ibllise I'm just gonna stick to Microsoft Access.

@systamatics I know about the templates, but I thought if someone already has a similar database put together it would be easier, especially that I'm a Microsoft Access newbie.

Sheriff Ice 06-09-2010 11:34 AM

can i give you an advice about an ERP/CRM software for SME i start using it 2 days ago it has great features and it is modular u can use what you need, it is a full solution for SME as CRM/ERP

it is called postbooks from xtuple
it is totally free and open source
Code:

http://www.xtuple.com/postbooks

ibllise 06-10-2010 07:48 AM

Quote:

Originally Posted by Tawa (Post 216689)
@ibllise I'm just gonna stick to Microsoft Access.




Rational rose , is the software were you implement your database and design it properly with everything required ..
You all have to do is to fill in tables you want,with the records u want and link the tables together..

after doing so and checking that it is perfectly linked and nothing is missing..you can import it to Access ,and thus you will find it all linked..
all you have to do is create the Forms and queries which the End user will be using..

the best way to design a database is by drawing it 1st ..

Rational rose is easy and not that complicated.
you just have to know the basics of Databasing.

Tawa 06-10-2010 11:04 AM

Man, same thing goes for Microsoft Access :p

ibllise 06-10-2010 06:37 PM

no no ur not getting it..
before u start making forms and queries, u need to set the tables properly and link them properly..it could be done on access ..

Access is build on something called Methodology or Merise(in french) UML in other terms
Trust me man, to build an effective database with the minimum requirements ,1st draw it on rational rose..

Download it or buy it....


All times are GMT +1. The time now is 01:51 PM.

Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Ad Management plugin by RedTyger