Results 1 to 4 of 4
  1. #1
    Ricardo is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2012
    Posts
    3

    Database for test progress tracking


    I'm very new to Access. I would like to create a database that allows users to track testing progress. This means there will be a table of tests - each with a specification like low < result < high, result > low, result > high (could also be <= and >=) described in fields for each test table record. The user should be able to enter the result in another field and have the database determine whether the result meets the spec and have pass or fail recorded in another table.

    Is this something that can be done without writing VBA code or can I accomplish this with just the standard Access GUI functions?

    Thanks

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    This means there will be a table of tests - each with a specification like low < result < high, result > low, result > high (could also be <= and >=) described in fields for each test table record
    I didn't understand the part in red. Could you explain that to me please?
    I think you might be able to do what you need without VBA code. You might need to consider using a query or two.
    How you set up your Tables in Access will determine how you can get what you need.
    Access really makes it easy to do many regular database-type activities - so you only need to think about VBA when your requirements get complex.

  3. #3
    Ricardo is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2012
    Posts
    3
    Quote Originally Posted by Robeen View Post
    I didn't understand the part in red. Could you explain that to me please?
    I think you might be able to do what you need without VBA code. You might need to consider using a query or two.
    How you set up your Tables in Access will determine how you can get what you need.
    Access really makes it easy to do many regular database-type activities - so you only need to think about VBA when your requirements get complex.
    I meant that tests will have different specification criteria to determine pass or fail.

    One test may require that the result be bounded by a maximum and minimum (minimum value < result < maximum value), another may have just a minimum value (minimum < result), and another may only have a maximum bound (result < maximum value). These bounds may be inclusive or exclusive (i.e. greater than or equal to vs greater than).

    My initial idea is to create a table with fields like this:
    Test Name Minimum Maximum Inclusive? Result

    I don't know if this is the best design or not though.

  4. #4
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    I think you should start out -> make your table and enter some test data -> and then create a query on the data in the table.In the query -> in design mode -> you can put your criteria [specification criteria] in the 'Criteria' row of the query design window.When you get to that point, let us know how it looks.Don't enter too much data - just enough to see if this approach is going to work for you.

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

Similar Threads

  1. Checklist to test new database
    By wouterv81 in forum Access
    Replies: 1
    Last Post: 04-26-2012, 09:17 PM
  2. Replies: 7
    Last Post: 10-19-2011, 07:17 PM
  3. Replies: 1
    Last Post: 02-17-2011, 10:57 PM
  4. Keying in Test answers to Access DB from Written Test
    By CityOfKalamazoo in forum Access
    Replies: 3
    Last Post: 03-01-2010, 08:58 AM
  5. help with tracking within a database
    By martyn in forum Queries
    Replies: 0
    Last Post: 10-07-2009, 02:15 PM

Tags for this Thread

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