How to learn MS Access

BizBoy

Board Regular
Joined
Jul 26, 2012
Messages
118
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.
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
1,843
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

Board Regular
Joined
Jul 26, 2012
Messages
118
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.
 
Last edited:

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,221
Office Version
365
Platform
Windows
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

Well-known Member
Joined
Feb 26, 2007
Messages
5,214
Office Version
2019
Platform
Windows
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

Board Regular
Joined
Jul 26, 2012
Messages
118
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
52,221
Office Version
365
Platform
Windows
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,090,549
Messages
5,415,209
Members
403,572
Latest member
twinlock

This Week's Hot Topics

Top