• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Moving from Jet Queries to T... > In the Real World—SQL as a Second La...

In the Real World—SQL as a Second Language

It’s tempting to use Jet’s Query Design view or the project designer to generate all SQL statements behind the scenes. Graphical QBE bypasses the need to learn two languages—SQL and VBA—to become a proficient Access or Visual Basic 6.0 database developer. The reality is that you ultimately must master both SQL and VBA, because the two languages are inextricably intertwined in all nontrivial Access database front ends to Jet and SQL Server databases. SQL is the lingua franca of all relational databases, just as VBA is the common programming language of Microsoft Office, Visual Basic 6.0, Visio, and many third-party applications. A future version of Access is likely to accommodate programming in Visual Basic .NET and C#, which means another language or two to learn.

Note

SQL is the foundation for several Microsoft query-language extensions, including SHAPE syntax for generating hierarchical Recordsets and Multidimensional Expressions (MDX) for DataCubes and the PivotTable Service for online analytical processing (OLAP) with Microsoft Analysis Services (formerly OLAP Services and Decision Support Services). As more organizations adopt the Standard or Enterprise editions of SQL Server 2000, which include Analysis Services, data warehouses will become commonplace in medium-sized enterprises, and smaller firms will set up data marts.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint