Results 1 to 3 of 3
  1. #1
    ScottXe is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2012
    Posts
    25

    Database for annual calibration


    I am planning to build a database for tracking the annual equipment calibration. The database is divided into two parts. One is the equipment info and the second part contains the calibration detail each year. The no of equipment may increase as times go by. The second part contains the detail of calibration detail, cost, service provider, results etc. on each equipment annually. Upon completion, I can query the calibration records of each equipment, all equipment of calibration in each year, cost of calibration of each equipment and/or each year, etc. upon request. I am a novice in building database and looking for the guidance how to construct a database for this purpose.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    See if tutorials at this site help guide you http://www.rogersaccesslibrary.com/

    So far, I see 3 tables.

    tblEquipment

    tblProviders

    tblCalibrations
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ScottXe is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2012
    Posts
    25
    June, thanks for the useful tutorials and suggestion. I will do some analysis of the issues before building the database.

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

Similar Threads

  1. Chart for annual comparison of data by months
    By shindb81 in forum Access
    Replies: 4
    Last Post: 05-21-2014, 12:48 AM
  2. Annual Leave(vacation) Relationships
    By Rach in forum Access
    Replies: 1
    Last Post: 01-26-2013, 12:45 PM
  3. Replies: 0
    Last Post: 12-01-2012, 05:35 PM
  4. Annual Review
    By kwilbur in forum Access
    Replies: 5
    Last Post: 01-03-2012, 10:33 AM
  5. Annual Leave Planner
    By Dexter in forum Access
    Replies: 1
    Last Post: 03-01-2011, 05:00 AM

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