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
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/Forums.aspx/access-modules/200810/1
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/Forums.aspx/access-modules/200810/1 > >
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/Forums.aspx/access-modules/200810/1
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/Forums.aspx/access-modules/200810/1 > >
