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

Chapter 23. Working with Structured Quer... > In the Real World—SQL As a Second La...

In the Real World—SQL As a Second Language

It's tempting to let Access write all your SQL statements, thereby bypassing the need to learn two languages—SQL and VBA—to become a proficient Access developer. The reality is that you ultimately must master both SQL and VBA, because the two languages are inextricably intertwined in all non-trivial Access database front-ends. SQL is the lingua franca of all relational databases, just as VBA is the common programming language of Microsoft Office, Visual Basic, and many third-party applications, such as Visio.

Note

SQL is the foundation for several new 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 OLAP Services. As more organizations adopt SQL Server 7.0, which includes OLAP Services (formerly Microsoft Decision Support Services), data warehouses will become commonplace in medium-sized enterprises, and smaller firms will set up data marts. It's a good bet that future versions of Access will add OLAP features.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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