Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access Design

Posted on 2011-03-13
9
Medium Priority
?
456 Views
Last Modified: 2013-11-29
Is there a quality template using testing data anywhere that is viewable for ideas?The quality tests that are performed each day are already going into a access database.  Although it is not set up properly because each test that is performed goes into its own database.  My thought is to get the 3-5 different tests performed into one database.  
0
Comment
Question by:topgun0621
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
9 Comments
 
LVL 85
ID: 35123223
Exactly what sort of Quality data are you collecting? Are you looking for something like a QA database? If so there are tons of them out there, but each is specific to an industry.

If you're referring to something else, you'll have to give more details.
0
 

Author Comment

by:topgun0621
ID: 35124483
For the testing of steel. Data such as yield, tensile ect...
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35129698
Well if your system is in fact this basic, then you should be able to do this your self.

Something, like this, perhaps, as a start:

tblParts:
PartID (PK)
PartName
PartMaterial
...etc

tblPartsTest
PartTestID (PK)
PartID (FK)
TestID (FK)
TestDate
TestResult
...

tblTests
TestID (PK)
TestName
...etc


JeffCoachman
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35130305
Off-The-Cuff, Basic sample and report:
Access-EEQ26883457MetalStrengthT.mdb
0
 

Author Comment

by:topgun0621
ID: 35134317
your basically on the correct path.  I have a tables for wire data, weld shear data, and welded test data.  
Wire test results: date,machine,size,area,yield .35%,yield .50%, tensile, rod size,carbon.
Weld shear results: size,area,load value machine.
Welded tensile results: date,machine,size,area,yield .35%,yield .50%, tensile.

The data going in is massive.  Last two months for example we currently have 13,000 wire test results and even more for the weld shear results.

We start out with various sizes of rod that are assigned a heat number.  This heat number is unique to each size.(example: 1/4- 1008 -carbon -heat#12345C)This heat number has certain chemical properties used to make up the steel.  We hand type this data into a table.

An order will come out to draw 32 carriers@4000# each.  This amount of wire will make several different styles of rolls/sheets each assigned a description and weight.  This product will then go out side untill it is ready to be shipped to a customer   Once shipped to a customer we then are required to provide a certified report to the customer.  This certified report has the following information: Long Wire heat number, Cross Wire Heat number(even though multiple heat numbers may have been used, only one heat number has to be on certified and it can be random), 1 sample yield data for both, 1 sample tensile data for both, and a "OK" box that a bend test was performed and a "OK" box that a welded tenisle test was performed. Also included is the weight and description of what was made in that lot.
All this data is put into Access but yet we hand write all the data on forms and spread sheets.  Once the product ships we look in the folders for the correct size, find the description by weight and send it up front to have someone type up a certified report.  If we ship other rolls/sheets out of that lot later in the week the process is repeated, which makes no sense to me as the certified report is the same data, but maybe different customer.
I need to tie these tabels together and be able to pull up specific lots and generate a certified report.

I have some dummy data that I have created to try to do this.  Not sure If the relatonships are correct, and having an issue generating a report as well.

Here is what I have: Not sure if I have the correct concept, but i know that an average will be fine for the test results. I grouped the averages on the heat number also. Any help greatly appreciated                                                                                                                                                                                                                                                                                                                     QCDataBase.accdb
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 35137863
1. Before you post a database here make sure you run the compact/repair utility first.
Your Db as downloaded is 15 mb, ...when compacted, it is 1.5 mb.

2. Your original question:
<Is there a quality template using testing data anywhere that is viewable for ideas?>
The answer here is No.
There is nothing this specific that exists as a template.

3. As far as structuring the data to have all the tests in one database, ...This is a "Architectural" design question.
And as such, may be a bit beyond the scope of a Q & A forum such as this.

LSMConsulting may be willing to help you further though...

JeffCoachman
0
 

Author Comment

by:topgun0621
ID: 35138221
yes, I apoligize for not compacting, I should have realized that.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35138296
You could have waited for a response from LSM,

I'm in no rush...
;-)

Jeff
0
 

Author Comment

by:topgun0621
ID: 35152542
new to this, was not sure if it was time to accept, did not want you mad thats for sure .
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question