+ Post New Thread
Results 1 to 6 of 6
How do you do....it? Thread, Stock Level Database in Technical; Hi All, I want to set up a database to monitor our stock levels on printer consumables, it has been ...
  1. #1

    Join Date
    Dec 2005
    Posts
    453
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Stock Level Database

    Hi All,

    I want to set up a database to monitor our stock levels on printer consumables, it has been a long time since i have created a database any advice would be appreciated.


    Faza

  2. #2

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,232
    Thank Post
    667
    Thanked 1,638 Times in 1,463 Posts
    Rep Power
    423

    Re: Stock Level Database

    I use glpi to do this.

    You set up your printers and cartridges and then allocate them to printers as you use them that way it will give you stats on how many pages you printed and how long it lasted.

    Ben

  3. #3

    Join Date
    Dec 2005
    Posts
    453
    Thank Post
    4
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Stock Level Database

    Is there a way that i can create a stock level database in Access?

  4. #4

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,232
    Thank Post
    667
    Thanked 1,638 Times in 1,463 Posts
    Rep Power
    423

    Re: Stock Level Database

    I expect so it is a db application after all.

    Ben

  5. #5
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42

    Re: Stock Level Database

    @faza: We did look at creating a database for our consumables/printers here too but after finding glpi (which is being tested now) it seems pointless to spend all that time creating a database yourself. If you really want do an access database i would suggest you spend time figuring exactly what you want to record then create the tables and relationship accordingly. Once you get this right the rest should follow.

  6. #6

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,879
    Thank Post
    518
    Thanked 2,486 Times in 1,928 Posts
    Blog Entries
    24
    Rep Power
    838

    Re: Stock Level Database

    I don't think we can really advise on creating a db in access, that'd come down to your knowledge of database creation and design really.

SHARE:
+ Post New Thread

Similar Threads

  1. Nintendo Wii - In Stock
    By Elky in forum Our Advertisers
    Replies: 9
    Last Post: 13th December 2007, 08:43 AM
  2. All-in-one PCs now in stock
    By Elky in forum Our Advertisers
    Replies: 0
    Last Post: 10th September 2007, 10:04 AM
  3. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  4. Stock Checking
    By faza in forum Wireless Networks
    Replies: 4
    Last Post: 19th February 2007, 01:39 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •