T
trump26901
My company is preforming some pressure testing on some product samples.
Up until now the people testing have been placing the data into excel
charts and keeping them orginized by file names.
This approach has allowed a very easy way to view the results from a
single test, but there is no way to compare things like average test
results without making yet another excel spreadsheet. My thought was
this should be the perfect use for a database such as MS access.
The variables for this test are rather simple. Each test has a single
sample name, test date, tester name, source pressure, product code. I
have been able to create a simple table to incorporate this data, but I
have no clue how to add the important information... the pressure and
resulting reflection which is measured roughly 20-30 times during the
test.
Right now we just input the data into a spreadsheet and can view the
result in a table and with a line graph. Problem is there is no way to
get statistical information on this data when it is split into multiple
files.
Would anybody be kind enough to give me a very beginner runthrough or
point me in the right direction to find a guide? I"m 99% sure access
is the way to go for this, but I just don't have the experiance.
If it makes a difference, I was going to just keep it as a local DB,
but I do have the option to put it on a MSSQL server running desktop
edition on a Windows SBS 2k3.
Up until now the people testing have been placing the data into excel
charts and keeping them orginized by file names.
This approach has allowed a very easy way to view the results from a
single test, but there is no way to compare things like average test
results without making yet another excel spreadsheet. My thought was
this should be the perfect use for a database such as MS access.
The variables for this test are rather simple. Each test has a single
sample name, test date, tester name, source pressure, product code. I
have been able to create a simple table to incorporate this data, but I
have no clue how to add the important information... the pressure and
resulting reflection which is measured roughly 20-30 times during the
test.
Right now we just input the data into a spreadsheet and can view the
result in a table and with a line graph. Problem is there is no way to
get statistical information on this data when it is split into multiple
files.
Would anybody be kind enough to give me a very beginner runthrough or
point me in the right direction to find a guide? I"m 99% sure access
is the way to go for this, but I just don't have the experiance.
If it makes a difference, I was going to just keep it as a local DB,
but I do have the option to put it on a MSSQL server running desktop
edition on a Windows SBS 2k3.
have an awesome day