Stcok system

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

  1. zxspectrum

    zxspectrum Terabyte Poster Forum Leader Gold Member

    2,092
    216
    244
    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
    Honorary Member Highly Decorated Member Award 500 Likes Award

    BosonMichael Yottabyte Poster

    19,183
    500
    414
    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,205
    136
    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,373
    89
    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,624
    117
    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 Terabyte Poster Forum Leader Gold Member

    2,092
    216
    244
    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...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.