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

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 ...