johnboytweed
Registered User.
- Local time
- Today, 02:31
- Joined
- Feb 6, 2012
- Messages
- 27
Good Afternoon,
I have looked online a lot about access and I understand that there are suppose to be tables setup to store information and that relationships are necessary for those tables to function. I guess my comprehension of it all ends there. One of my biggest questions is simply, "should I create a table that has all my data consolidated in it so that it can be viewed like you would a spreadsheet after all the necessary data has been entered? Or should I create a form that pulls all the data into one view so that it can be entered that way and then the information is saved into each table separately?
Sorry if this is very basic, but I'm just trying to understand how I need to make these tables relate to one another. I didn't know if there should be one table that has everything in it so that it can be easily viewed on a regular basis, or if I am suppose to create the tables and then create a "form" so that all the data is housed together.
The form looks good but it only seems that you can view one record at a time. If I wanted to view many records at once it seems like it should be in a "datasheet view".
I have looked online a lot about access and I understand that there are suppose to be tables setup to store information and that relationships are necessary for those tables to function. I guess my comprehension of it all ends there. One of my biggest questions is simply, "should I create a table that has all my data consolidated in it so that it can be viewed like you would a spreadsheet after all the necessary data has been entered? Or should I create a form that pulls all the data into one view so that it can be entered that way and then the information is saved into each table separately?
Sorry if this is very basic, but I'm just trying to understand how I need to make these tables relate to one another. I didn't know if there should be one table that has everything in it so that it can be easily viewed on a regular basis, or if I am suppose to create the tables and then create a "form" so that all the data is housed together.
The form looks good but it only seems that you can view one record at a time. If I wanted to view many records at once it seems like it should be in a "datasheet view".