Learn Microsoft Access

complete amateur to this .... can you teach me some basics

can u share any file which taught me from beggining to end..........? I have listen it is very much similar to excel. Is it True........?

Sure friends, I'll upload a short tutorial soon. It is not similar to Excel by the way. Excel is a spreadsheet program and Access is a Relational Database Management System. You make tables to store data. Permanent data in master tables and variable data in related tables. Join the two tables with One Primary Key and One Foreign key. Remember joining two tables requires simple rules:

1. The data type of the two fields you want to join should be same (field name could be different).

2. Atleast one of them should be a Primary Key

this you can do in relationship window.

Will continue further if it interests you

gud luk

And I forgot, I'll be conducting a FREE OF COST Microsoft Access Class in Indirapuram in April. will let you know.

Thanks Rakesh, by d way where is Indirapuram......?

Indirapuram is in Ghaziabad. And I am attaching a beginners tutorial on creating tables and relationships in Access 2007. If you like this one, do let me know, i'll post other tutorials also.

Thanks buddy, i will tell u soon after i read it. Can u tell where access is helpful for me or where i can use it in a ma work.....?

Sure, for CAs, I guess it is indispensible. You can extract data from huge databases by specifying different criteria. For example, you want to know out of 1000 employees in an organization, how many of them are drawing a salary between 30000 and 40000 and whose names begin with A and who are posted in Delhi and you want to exclude the salary of march month.

See so many criteria. You cannot do this in excel easily but in access it takes only a second to extract this data. If you follow on my other tutorials you will also learn how you can make so many complicated queries.

Thanx

Ya right i can do it in excel by using filters or pivot table, but it will take some time. Hope that ur training will give me a good understanding of access, which i will apply in ma work & get benefits of the same.

I am following your example keenly

Learnt a bit of access thanks to you :D

Sorry friends, I will post next tutorial very soon. Actually, a bit busy lecturing CISA candidates for the upcoming CISA exams in June 11.

HI friends, I am uploading the next microsoft access tutorial. sorry for the delay. Download Excel file from this post and the tutorial PDF from the next one.

Please download the Microsoft Access PDF tutorial. Next I'll post 'How to design queries in Microsoft Access'

Thanks Rakesh