Results 1 to 6 of 6
  1. #1
    AccessPower's Avatar
    AccessPower is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    165

    Checkout System

    I'd like to get some ideas for an equipment tracking system. So there are about 40 laptops that will be checked out periodically to different people as needed. What is the most efficient architecture for this? I will need to track whether or not laptops are checked out. I will also need to track checkout dates and checkin dates of the past so that I can produce reports.

    I was thinking something like this:

    tblEquipment
    --------------------
    pkDeviceID (Auto)
    SerialNumber (Text)
    ComputerName (Text)
    CheckoutDate (Date)


    CheckinDate (Date)



    tblTransactions
    --------------------
    pkTransactionID
    DeviceID
    CheckoutDate
    CheckinDate


    Checkout Button that populates the date of checkout
    Checkin button that populates the date of checkin, writes the deviceid checkoutdate and checkindate to tblTransactions.

    What do you guys think. Is there a better way to go about doing this?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the tEquip table needs the field USERid.
    This will hold the userID of who has rented the item.
    a null field means its available.
    the userID would also be in the tTransaction table too.

  3. #3
    AccessPower's Avatar
    AccessPower is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    165
    Good thinking Ranman. I don't know how I overlooked that. lol

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Why is there check in/out dates in tblTransactions AND tblEquipment??
    I would only have check in/out dates in table tblTransactions. (along with FK to person checking In/Out the laptop).

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    +1 on only have the dates in the transactions table.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    This free data model may be helpful. (Barry Williams' site)

    Seems you would want a Client or Employee type table also based on
    different people
    .

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to create Books Library Checkin Checkout database
    By NotesAndSoft in forum Database Design
    Replies: 1
    Last Post: 02-13-2014, 04:29 AM
  2. Replies: 1
    Last Post: 03-22-2013, 08:13 PM
  3. Help with Key Checkout Access Database
    By Darth21 in forum Access
    Replies: 6
    Last Post: 03-06-2013, 11:32 PM
  4. Replies: 2
    Last Post: 04-12-2011, 10:14 AM
  5. Multimedia Inventory and Checkout
    By ITChevyUSSNY in forum Forms
    Replies: 5
    Last Post: 12-12-2010, 02:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums