Hello,
I would like to preface this by saying I am completely inexperienced using Microsoft Access. I am a recent engineering graduate who, on the advice of some people more experienced than myself, has been compelled to learn Access since it can be a much better tool than many of the over complicated excel spreadsheets that many in our industry use.
Basically here is my problem. My first database is for measuring a variety of variables in fields for the agricultural industry. My name convention is:
tblState_Town_Year with the table being broke into:
|DOY|Date|High Temp|Low Temp|Humidity|Soil Temp|Wind Speed|Solar Radiation|Precipitation|Evapotranspiration
My thought process (for when its all done) is to have a back-end/front-end where the back-end stores information in tables for each year/town/state. That way as each year passes or if I want to add another town or w/e I can simply add the specific tables and then link them together on a server and have a front end where the people I work with can look up the relevant information from their computers without being able to alter any information.
I guess I understand how to put fields next to one another so you could have comparative graphs, however lets say I want to have fields linked together so It would put down all the information from 05->06->07 linearly instead of comparatively; how do I do this?
Also, is my naming convention stupid? Is the date a good Key Parameter to use?
I would like to preface this by saying I am completely inexperienced using Microsoft Access. I am a recent engineering graduate who, on the advice of some people more experienced than myself, has been compelled to learn Access since it can be a much better tool than many of the over complicated excel spreadsheets that many in our industry use.
Basically here is my problem. My first database is for measuring a variety of variables in fields for the agricultural industry. My name convention is:
tblState_Town_Year with the table being broke into:
|DOY|Date|High Temp|Low Temp|Humidity|Soil Temp|Wind Speed|Solar Radiation|Precipitation|Evapotranspiration
My thought process (for when its all done) is to have a back-end/front-end where the back-end stores information in tables for each year/town/state. That way as each year passes or if I want to add another town or w/e I can simply add the specific tables and then link them together on a server and have a front end where the people I work with can look up the relevant information from their computers without being able to alter any information.
I guess I understand how to put fields next to one another so you could have comparative graphs, however lets say I want to have fields linked together so It would put down all the information from 05->06->07 linearly instead of comparatively; how do I do this?
Also, is my naming convention stupid? Is the date a good Key Parameter to use?
