troubleshooting Question

MS Access Database Design Problem for test results

Avatar of dazzler77
dazzler77 asked on
Microsoft Access
3 Comments1 Solution662 ViewsLast Modified:
I am trying to build a database to store test results, and requirements tracking.
Each test has a step number and an instruction step.

My problem is there are different settings for each test which I would normally like to have different columns for.

For example the first 100 tests are like this:
test       5 degrees    10 degrees     20 degrees
1              pass              fail                   pass
2              pass              pass                 pass

For example the next 50 tests, each test  has different setting, but does not have different temperature ranges.

If I were doing object programming, I would have a base class, with each test having a class with different properties.

In access, I could use a different table for each test result set, but I would like to print out the report as one document.

I also want to link specifications to each test step.

Also, if I have different tables, how do I make relationships to different tables from one table to another?

eg.  I have a table of specifications, and some test steps are in different tables.

Specification    Test step      Result
1.2.3                 1.4               pass
1.2.4                 2.5               pass

Another way I thought was to use attached properties:
test      property   setting
1           temp          5
1           dial             3
1           voltage        7.4

test      property   setting
2           temp          10
2           dial             3
2           voltage        7.4

Using this method, it is very time consuming attaching each of these properties to each test, it would be easier to have these as columns in a table.  Just that the columns are different for groups of tests.

Maybe I am going about this the wrong way.  What is the best method to achieve this?
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros