MS Access 2010 Startup Tutorial

[dinesh_ltjd]

Hi Friends,



I am very new to Access. Can anyone of you pls help me with Basic Access 2010 Study material. So that I can go through it and get hands on knowledge for Access. So that I can start working on some basic stuff

Thanks
Dinesh

[orange]

You should review database design and understand the concepts of relational database before getting into Access.

I have suggested videos to others to familiarize them with the concepts involved.

For erd this is a great tutorial
http://www.rogersaccesslibrary.com/T...lationship.zip

These free video tutorials describe the processes of data modelling, normalization and entity relationship diagramming. There are other videos, but this group is by the same presenter and covers an example situation. The example relates Customers, Orders and Items.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

The first few topics at this site are well worth the read.

http://www.rogersaccesslibrary.com/forum/topic238.html

Good luck with your project.

https://www.youtube.com/course?list=EC34E1E1F86126CBA0

[dinesh_ltjd]

Thanks a bunch sir :-)

[orange]

You are welcome. These videos including the youtube link are a great resource to reference from time to time as a refresher.
Good luck with your learning.

[dinesh_ltjd]

Hi Sir,

Me again...Sorry to bother you...
I need a quick help..I was practising on a attached database in access.
I have imported all the sheets in access
Now I want 'Product ID wise Quantity Ordered'...I dont want to use the Pivot View.
Is there a way to make a query to get the required output

Thanks]
Dinesh

[orange]

Access refers to relational database. Excel refers to spreadsheet. These are quite different animals that serve different purposes.

The links I gave you focused on creating an ERD and normalizing data. I do not see an ERD to show a picture of what you are dealing with.
I don't see a write up of your business or the major subjects and processes involve.
I was expecting you to follow up with something more specific to ERD or even comments about the youtube courses.


I have no way to know exactly what you are trying to do.

Sheets and Pivot view are a long way down the road.

You may find this article on relational concepts very basic and fundamental to database (and Access).
http://forums.aspfree.com/attachment...2&d=1201055452

If you want to attach a jpg of your tables and relationships, or your Access database, I'm sure others would like to see what you have created.