Advanced Functionality through VBA

[vbasean]

Welcome to the world of MS Access. MS Access is a wonderful program that
allows intermediate office users to create simple applications for storing
data and manipulating it.

Most users want to do similar things. They want to have combo boxes that
filter other combo boxes (commonly called cascading combo boxes.) They may
want to filter a form by a list box. Some may want to have special happen
when a user clicks a button.

MS Office applications, in general, do not require you to understand
programming or a theory of sorts to implement advanced features. But for MS
Access it is imperative that beginner users understand that to get the above
advanced functionality out of Access they must begin by learning the three
basic major keys to Access development.

Three of the major keys to MS Access are VBA [Visual Basic for
Applications], SQL [structured query language], and Relational Database
Theory (these three not necessarily in this order.)

There are plenty of books on VBA, and SQL. The topic of Relational
Databases is peppered throughout these two books when they relate to MS
Access.

It's very difficult to expect advanced functionality out of MS Access
without trying to grasp these three keys.

For beginner developers/users who desire to get more out of MS Access it
would benefit them greatly to investigate these three topics in detail.

Thanks,

Your friend Chris

 

[vbasean]

With all due respect, there are three types of threads on this forum:
1) Question
2) Suggestion
3) General Comment

this thread was started as a 'General Comment' which it is.

Thanks,

~Chris

If you want to start a discussion you need to phrase it in the form of a
question, otherwise it looks like a rant.

Chris
Microsoft MVP

Welcome to the world of MS Access. MS Access is a wonderful program that
allows intermediate office users to create simple applications for storing
data and manipulating it.

Most users want to do similar things. They want to have combo boxes that
filter other combo boxes (commonly called cascading combo boxes.) They may
want to filter a form by a list box. Some may want to have special happen
when a user clicks a button.

MS Office applications, in general, do not require you to understand
programming or a theory of sorts to implement advanced features. But for MS
Access it is imperative that beginner users understand that to get the above
advanced functionality out of Access they must begin by learning the three
basic major keys to Access development.

Three of the major keys to MS Access are VBA [Visual Basic for
Applications], SQL [structured query language], and Relational Database
Theory (these three not necessarily in this order.)

There are plenty of books on VBA, and SQL. The topic of Relational
Databases is peppered throughout these two books when they relate to MS
Access.

It's very difficult to expect advanced functionality out of MS Access
without trying to grasp these three keys.

For beginner developers/users who desire to get more out of MS Access it
would benefit them greatly to investigate these three topics in detail.

 

[vbasean]

great idea. Thanks for the imput.

It's not marked as a general comment when it's posted to the rest of the
world. But why do you think this group is a good place to post your comment?
It'll scroll down off most people's readers in a few hours, a day at most.
Searching on any of its keywords will rarely bring it up in the results
because it doesn't have any replies marked as correct and it'll be removed
from the online db in about 2 months if it doesn't get any replies marked as
answers.

Seems to me this could be a good candidate for a blog post. Many blogs are
free and the posts stay on the web without being removed from someone's
online db. That would be a better venue for general comments about a product.


Chris
Microsoft MVP