How to learn MS Access

[BizBoy]

Hi,

I am new to MS Access. I know nothing about MS Access.
However I want to learn it. I have basic knowledge about (excel) VBA.

Thinking about joining weekend classes for the same.
Could you please advise me how should I proceed.

Location - India.

 

[ranman256]

yes, classes, and get the Access for Dummies book. (good reference)
then the BEST is , build an app ,like a classroom with students/work, or a Business with shopping cart/inventory.
and start digging.
Working on a project is the best teacher.

 

[BizBoy]

Hi ranman, thanks a lot for the help. Have a nice day ahead.

 

[BizBoy]

Would you recommend book by Laurie Ulrich Fuller, Ken Cook.

 

[BizBoy]

If I am correct. Working with VBA for excel is more object oriented. Where one needs to play with properties for objects.

In case of MS Access, focus is more on writing quires. Which might look simple at the outset but must be complex once dived further.


Both of my assumptions can be wrong and apology if my post is violating rules.

 

[Joe4]

In case of MS Access, focus is more on writing quires. Which might look simple at the outset but must be complex once dived further.

Creating queries is just one aspect of Access (though a very powerful one).
VBA is also very big in Access, especially in looking to build applications. VBA is very commonly found with interactive Forms and other processes that you want to automate.

I think both Excel and Access are too big to put into a small, self-contained box like that. A lot of it depends on what you are trying to do, and both have the flexibility to cover quite a range of things.

 

[alansidman]

When starting out in Access, I believe it is very important to understand Table Structure(s) and design. Look at this white paper on design and you will be better equipped to build your own files.

http://r937.com/relational.html

 

[BizBoy]

Look at this white paper on design and you will be better equipped to build your own files.

http://r937.com/relational.html

Thanks for the help. Am checking URL. Have a nice day ahead.

 

[BizBoy]

I think both Excel and Access are too big to put into a small, self-contained box like that.

Thanks for the help Joe. Sir, does this mean, as a developer I will be required to integrate MS Access and VBA. I guess, both these platforms compliment each other.
I am very limited when it comes to excel VBA. I think our Forum will help me to broaden my horizon.

Have a nice day ahead.

 

[Joe4]

Thanks for the help Joe. Sir, does this mean, as a developer I will be required to integrate MS Access and VBA.

If your desire it to become a serious Access Developer, than I would say yes, you should know some Access VBA code.
It is used, not only for complex processes, but also in some fairly basic Form creation (i.e. default fields, data entry verification, dependent values, etc).