Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

Learn Microsoft Access

Rakesh Sharma (Senior Audit Officer) (103 Points)

21 March 2011

Hello friends, I have more than 10 years of experience in Microsoft Access. If you have any questions on Microsoft Access, I'll be glad to answer.

Reply
Follow
Share

19 Replies

praveen (Chartered Accountant) (6971 Points)
Replied 21 March 2011

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

1 Like

Upgrade to CAclubindia Pro. Subscribe Now!

Vikas Marele (CA in Service) (1144 Points)
Replied 21 March 2011

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........?

1 Like

Rakesh Sharma (Senior Audit Officer) (103 Points)
Replied 22 March 2011

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

1 Like

Rakesh Sharma (Senior Audit Officer) (103 Points)
Replied 22 March 2011

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

Vikas Marele (CA in Service) (1144 Points)
Replied 22 March 2011

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

Upgrade to CAclubindia Pro. Subscribe Now!

Rakesh Sharma (Senior Audit Officer) (103 Points)
Replied 22 March 2011

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.

Attached File : 34 accesstables.doc downloaded: 434 times

3 Like

Vikas Marele (CA in Service) (1144 Points)
Replied 22 March 2011

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.....?

Rakesh Sharma (Senior Audit Officer) (103 Points)
Replied 22 March 2011

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

Vikas Marele (CA in Service) (1144 Points)
Replied 22 March 2011

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.

praveen (Chartered Accountant) (6971 Points)
Replied 23 March 2011

I am following your example keenly

Learnt a bit of access thanks to you :D

1 Like

Upgrade to CAclubindia Pro. Subscribe Now!

Rakesh Sharma (Senior Audit Officer) (103 Points)
Replied 25 March 2011

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

1 Like

Rakesh Sharma (Senior Audit Officer) (103 Points)
Replied 08 April 2011

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.

Attached File : 8 payroll2003.xls downloaded: 280 times

1 Like