1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Stcok system

Discussion in 'Networks' started by zxspectrum, Dec 29, 2006.

  1. zxspectrum

    zxspectrum Gigabyte Poster Premium Member

    1,666
    54
    139
    Right sorry if i put this in the wrong forum but im not sure where else to put it. Its for a uni assignment

    I need to set up a small network for a small company who deal in high quality foods. This is to bring them into the 21st century so to speak and will also have a website made just for them by me. The website bit im on with and ill be ok with doing etc. Now im not hot on where to look for information regarding this.

    I need a system that can produce 4 printouts one for sales, stock accounts and warehouse. Id like each dept to have an accurate upto date database as well, when one item is sold and then tilled up etc id like that item to let stock control know that it is on their system and would need re odering at some point.

    If anyone can help on this ill be soooo grateful

    Eddie
     
    Certifications: BSc computing and information systems
    WIP: 70-680
  2. BosonMichael
    Highly Decorated Member Award

    BosonMichael Yottabyte Poster

    19,136
    462
    374
    That's what databases are made for.
     
    Certifications: CISSP, MCSE+I, MCSE: Security, MCSE: Messaging, MCDST, MCDBA, MCTS, OCP, CCNP, CCDP, CCNA Security, CCNA Voice, CNE, SCSA, Security+, Linux+, Server+, Network+, A+
    WIP: Just about everything!
  3. simongrahamuk
    Honorary Member

    simongrahamuk Hmmmmmmm?

    6,199
    125
    199
    How about using a Form? I'm sure they're fairly easy to create with Dreamweaver. 8)
     
  4. Mr.Cheeks

    Mr.Cheeks 1st ever Gold Member! Gold Member

    5,369
    85
    190
    How about MS Access - you can do loads of stuff in that, very customisable...

    edit: re-reading that, is it only "web based" database you are after?
     
  5. hbroomhall

    hbroomhall Petabyte Poster Gold Member

    6,623
    115
    224
    There are many ways of doing this!

    The classic way is a database in the back office which is accessed by the front-end web pages.

    Databases can be access, MySQL, PostgreSQL, SQLServer.

    Front ends use PHP, Perl, ASP or similar.

    You get the reports from queries on the database.

    Harry.
     
    Certifications: ECDL A+ Network+ i-Net+
    WIP: Server+
  6. zxspectrum

    zxspectrum Gigabyte Poster Premium Member

    1,666
    54
    139
    When you say web based i take it you mean that the information will be secure from the public etc, except from the web page etc. Ill have a look on the MS access in a mo

    cheers
    Eddie
     
    Certifications: BSc computing and information systems
    WIP: 70-680

Share This Page

Loading...