New to Access - Need some guidance

[Meat4grinder]

I know this might not be the right place but i am learning access and would like a mentor or someone to guide me in the right direction. if You can help with this message me via here or skype Meat4Grinder. Thanks

 

[alansidman]

Here are two sites that I believe will help you start your journey

http://sbuweb.tcu.edu/bjones/20263/Access/AC101_FundamentalsDB_Design.pdf

After reading the above, click on this link and begin the tutorial

Access Basics

 

[Meat4grinder]

I been watching a Tutorial -kinda understand it but need someone to help me put one together. Its for a fun one right now mainly to do trail and error, however i dont know if i am going the right direction so i mainly need someone to bounce idea's off and guide me in doing the correct steps so that later on it dont mess up.

 

[HiTechCoach]

I been watching a Tutorial -kinda understand it but need someone to help me put one together. Its for a fun one right now mainly to do trail and error, however i dont know if i am going the right direction so i mainly need someone to bounce idea's off and guide me in doing the correct steps so that later on it dont mess up.

The best way to learn database development is to do it. In the process you will try thing. Some things will work. Some won't. Evaluate, Learn. Try again. Keep repeating this process.


Every programmer will ness up a lot when they start. There is just to much to learn. It takes lots of practice to gain the experience to not "mess up" a lot.


Also look at examples. Check out the North Wind sample database and the other templates that come with Access.

 

[HiTechCoach]

From a PM:

I been trying new thing however i think i am looking at access the way i was using excel. Might be over thinking it so i am thinking to get some classes only way i will get some one on one, so that i can see how to do this correctly. I built most of my tables kinda understand how to make a query and how to make basic forms. However i am looking at forms like VBA (in excel) where a button adds the information to the proper places, now that i dont know how it works in access. As you can see i got some fundamentals but dont know whats next and how to tie it back together.

1)

I been trying new thing however i think i am looking at access the way i was using excel.

That will only confuse you and make it harder to learn proper database programming.

Don't get fool by how similar Access and Excel look. It is only by appearance not by how they really work.

Excel is a spreadsheet6 NOT a relational database. It is true you can make what appears to be a table but that does not make it a relational database.

Access is a Relational database. Some Excel really does not handle.

Most of the Excel workbooks I have seen would be considered a very poor database design and vice versa.


2)

As you can see i got some fundamentals but dont know whats next and how to tie it back together.

Hard to say if you have any of the fundamentals since you are using Access like you would Excel.

3)

I built most of my tables kinda understand how to make a query and how to make basic forms. However i am looking at forms like VBA (in excel) where a button adds the information to the proper places, ...

Access forms and Excel User form as nothing alike.

A true basic form in Access can add, edit and delete records with NO vba code or buttons! It really is true that a basic form in Access has not VBA code or buttons to function.

4)

Might be over thinking it so i am thinking to get some classes only way i will get some one on one, so that i can see how to do this correctly.

You are not over think this at all.

Relational Database programming is much more difficult that spreadsheets. This is also true of Access.

Some people learn better in a class setting. Some people learn well from books. Some people learn well from videos.

From 30+ years of training programmers, I find that everyone learns best by doing. This is true of class room training.


Also check out the free training from Microsoft: Microsoft Virtual Academy