O'Reilly logo

Access 2007 Programming by Example with VBA, XML, and ASP by Julitta Korol

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 23Views and Stored Procedures

In this chapter, we will work with advanced Data Definition Language statements that are used for creating, altering, and deleting two special database objects known as views and stored procedures. These objects are used to perform various query operations. Views are like Access Select queries; however, you can’t use the ORDER BY clause to sort your data or use parameters to filter records. Stored procedures perform the same operations as Access Action and Parameter queries. They can also be used for creating sorted Select queries. Stored procedures are saved precompiled so that at run time the procedure executes much faster than a standard SQL statement. Learning how to create and use views and stored procedures ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required