Vcoderz Community
We create websites that have it all, beauty & brains
Lebanon Web Design & Development - Coddict
 

Go Back   Vcoderz Community > Computer Zone > Computers & Information Technologies > E-Learning Center

Notices

E-Learning Center E-Learning tutorials and competitions.

Reply
 
Share Thread Tools Search this Thread
Old 06-08-2010   #1
Tawa
 
Tawa's Avatar
 
Last Online: 04-23-2018
Join Date: Mar 2006
Posts: 6,245
Thanks: 2,120
Thanked 3,365 Times in 1,740 Posts
Groans: 29
Groaned at 44 Times in 35 Posts
Default 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


__________________
What we do in life, echoes in eternity.
Tawa is offline   Reply With Quote
Old 06-08-2010   #2
ibllise
Registered Member
 
ibllise's Avatar
 
Last Online: 07-30-2011
Join Date: May 2010
Posts: 219
Thanks: 30
Thanked 90 Times in 56 Posts
Groans: 6
Groaned at 67 Times in 34 Posts
Default

ever used rational rose???
ibllise is offline   Reply With Quote
Old 06-08-2010   #3
SysTaMatIcS
Registered Member
 
SysTaMatIcS's Avatar
 
Last Online: 04-17-2018
Join Date: Dec 2006
Posts: 10,466
Thanks: 14,135
Thanked 4,242 Times in 2,546 Posts
Groans: 186
Groaned at 198 Times in 120 Posts
Default

new , business asset managment or somethin like that which will lead you to download a template from the internet . this would help alot.
__________________
problems of performance appraisal is that it sucks to memorize them
SysTaMatIcS is offline   Reply With Quote
Old 06-09-2010   #4
Tawa
 
Tawa's Avatar
 
Last Online: 04-23-2018
Join Date: Mar 2006
Posts: 6,245
Thanks: 2,120
Thanked 3,365 Times in 1,740 Posts
Groans: 29
Groaned at 44 Times in 35 Posts
Default

@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.
__________________
What we do in life, echoes in eternity.
Tawa is offline   Reply With Quote
Old 06-09-2010   #5
Sheriff Ice
info@sync.com.lb
 
Sheriff Ice's Avatar
 
Last Online: 2 Weeks Ago
Join Date: Apr 2006
Posts: 3,827
Thanks: 1,348
Thanked 2,391 Times in 1,306 Posts
Groans: 0
Groaned at 16 Times in 15 Posts
Default

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
__________________
http://www.gamync.com Lebanese Produced Mobiles Games by http://www.sync.com.lb
Sheriff Ice is offline   Reply With Quote
Old 06-10-2010   #6
ibllise
Registered Member
 
ibllise's Avatar
 
Last Online: 07-30-2011
Join Date: May 2010
Posts: 219
Thanks: 30
Thanked 90 Times in 56 Posts
Groans: 6
Groaned at 67 Times in 34 Posts
Default

Quote:
Originally Posted by Tawa View Post
@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.
ibllise is offline   Reply With Quote
Old 06-10-2010   #7
Tawa
 
Tawa's Avatar
 
Last Online: 04-23-2018
Join Date: Mar 2006
Posts: 6,245
Thanks: 2,120
Thanked 3,365 Times in 1,740 Posts
Groans: 29
Groaned at 44 Times in 35 Posts
Default

Man, same thing goes for Microsoft Access
__________________
What we do in life, echoes in eternity.
Tawa is offline   Reply With Quote
Old 06-10-2010   #8
ibllise
Registered Member
 
ibllise's Avatar
 
Last Online: 07-30-2011
Join Date: May 2010
Posts: 219
Thanks: 30
Thanked 90 Times in 56 Posts
Groans: 6
Groaned at 67 Times in 34 Posts
Default

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....
ibllise is offline   Reply With Quote
Reply

  Vcoderz Community > Computer Zone > Computers & Information Technologies > E-Learning Center

Tags
access, microsoft, projectitem, sales, tiny



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 04:36 PM.


Lebanon web design and development
Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Ad Management plugin by RedTyger
Share