PC Review


Reply
Thread Tools Rate Thread

Advanced Functionality through VBA

 
 
vbasean
Guest
Posts: n/a
 
      7th Oct 2008
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
 
Reply With Quote
 
 
 
 
vbasean
Guest
Posts: n/a
 
      7th Oct 2008
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

"Chris O'C via AccessMonster.com" wrote:

> 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
>
>
> vbasean wrote:
> >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.

>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200810/1
>
>

 
Reply With Quote
 
vbasean
Guest
Posts: n/a
 
      7th Oct 2008
great idea. Thanks for the imput.

"Chris O'C via AccessMonster.com" wrote:

> 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
>
>
> vbasean wrote:
> >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.

>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200810/1
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Advanced Outlook right click functionality from system tray DannyH Microsoft Outlook Discussion 0 29th May 2010 04:51 PM
Help: Advanced Template (dotx) Functionality DocBadwrench Microsoft Word Document Management 6 11th Aug 2009 10:51 PM
Loss of Functionality with Advanced Filter gordon Microsoft Excel Crashes 1 25th Jul 2008 08:20 AM
Advanced functionality with Access =?Utf-8?B?YnZkYWhs?= Microsoft Access Form Coding 2 11th Nov 2006 11:19 AM
Advanced Resource Account Functionality Chris Microsoft Outlook Calendar 0 30th Mar 2004 06:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:43 AM.