VeggieBoards banner
1 - 9 of 9 Posts

·
Registered
Joined
·
4,337 Posts
Discussion Starter · #1 ·
I am so lost. I am wondering if there are any good tutoring or aids I can find online. The site the class had me look at was no hep and explained not even half of what I am supposed to know for the project. I need to get a decent grade on it as I am not to happy with my current grade in the class. I know no one who knows this and the teacher to the class was far less then helpful when I emailed him about other projects. It is making me want to cry.
 

·
Registered
Joined
·
4,337 Posts
Discussion Starter · #3 ·
Nope. I just looked at it and can not afford any extra costs.
 

·
Registered
Joined
·
1,938 Posts
~
 

·
Banned
Joined
·
1,013 Posts
Quote:
Originally Posted by SuicideBlonde View Post

I am so lost. I am wondering if there are any good tutoring or aids I can find online. The site the class had me look at was no hep and explained not even half of what I am supposed to know for the project. I need to get a decent grade on it as I am not to happy with my current grade in the class. I know no one who knows this and the teacher to the class was far less then helpful when I emailed him about other projects. It is making me want to cry.
Are you new to Access or just new to 2010?
 

·
Registered
Joined
·
4,337 Posts
Discussion Starter · #7 ·
Thanks for the advice. It was for a computer class and I had never used it before. I was spazing out about it. I hope I will never have to use it again but now I know a little.
 

·
Banned
Joined
·
3,641 Posts
I never understood why people have so much trouble with Access. I think people get confused because they are used to Excel.

Quick overview of Access:
Access is a little different from Excel. With Access, you put data in the rows and row position does not matter, so don't worry about sorting A-Z. You can't even move the rows up or down, again because it is not necessary since row position does not matter. The data position within a row is important (and the 1st row is usually the unique identifier). The unique identifier ensures that there are no exact duplicate records. Why is this important? You wouldn't want someone else to come to VeggieBoards and take the name SuicideBlone, would you? One record for each object to prevent problems.

You pre-define the data fields with constraints (numbers only, letters only, only allow 3 digits, etc). The data fields are not made to look pretty - no bold, italics, colors, etc. They just hold data.

Now all that raw data is no good as it is because it is a jumbled mess. What you do in Access is generate reports that present the data in an organized and attractive manner. This is where it can get tricky. The report wizard is fairly easy. Just pick the data fields, your template, etc and a report is generated. There are different view to the report. The Layout and Design views are how you move things around and set widths and whatnot. The Report view is the good looking view that you would print. The hardest part is linking multiple sets of data through relationships. To link two tables together, you have to link them by the ID (the one with the key next to it).

I'm telling you these things because I struggled with Access at the very beginning until I understood these things. It's these differences from Excel that made me understand how Access works. Basically, you work with raw data then you create a report to present it.
 

·
Registered
Joined
·
3,339 Posts
Quote:
Originally Posted by sleepydvdr View Post

I never understood why people have so much trouble with Access. I think people get confused because they are used to Excel.

Quick overview of Access:
Access is a little different from Excel. With Access, you put data in the rows and row position does not matter, so don't worry about sorting A-Z. You can't even move the rows up or down, again because it is not necessary since row position does not matter. The data position within a row is important (and the 1st row is usually the unique identifier). The unique identifier ensures that there are no exact duplicate records. Why is this important? You wouldn't want someone else to come to VeggieBoards and take the name SuicideBlone, would you? One record for each object to prevent problems.

You pre-define the data fields with constraints (numbers only, letters only, only allow 3 digits, etc). The data fields are not made to look pretty - no bold, italics, colors, etc. They just hold data.

Now all that raw data is no good as it is because it is a jumbled mess. What you do in Access is generate reports that present the data in an organized and attractive manner. This is where it can get tricky. The report wizard is fairly easy. Just pick the data fields, your template, etc and a report is generated. There are different view to the report. The Layout and Design views are how you move things around and set widths and whatnot. The Report view is the good looking view that you would print. The hardest part is linking multiple sets of data through relationships. To link two tables together, you have to link them by the ID (the one with the key next to it).

I'm telling you these things because I struggled with Access at the very beginning until I understood these things. It's these differences from Excel that made me understand how Access works. Basically, you work with raw data then you create a report to present it.
You can also link/join tables that have a common field...not necessarily the primary key.
 
1 - 9 of 9 Posts
Top