"marina madeleine" <ma**************@hotmail.com> wrote in message
news:41**********************@news.newsgroups.ws.. .
Could some clarify for me - I thought the scripting language for Access
was SQL and that to script in Access one would need to learn SQL. Why
then is the Access database under visual basic? What do you need to
know to know, SQL or VB, to work optimally in Access?
Also, is it possible to hook up Access datasets to a pre-made pivot
table in Excel. How does this work, any more elaborate info on this
would be much appreciated.
Marina Madeleine
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
"I thought the scripting language for Access was SQL"
You thought wrong. SQL is not a scripting language, it is a query language
specifically designed for carrying out set-based operations against a
relational database.
"Why then is the Access database under visual basic?"
Because VBA is Microsoft's procedural programming language for all of
Office.
"What do you need to know to know, SQL or VB, to work optimally in Access?"
You need to know both. To put it crudely, VBA is the procedural language
that you need for programming Access (scripting, if you must), SQL is the
query language that you need for retrieving and maintaining data.