Chapter Summary

This chapter introduced you to two powerful database objects you can use in Access: views and stored procedures. You learned how views are used as virtual tables to make specific rows and columns from one or more tables available to your Access users. Remember that views are similar to SELECT statements, except they cannot contain the ORDER BY clause to sort the data and they do not allow parameters. Views can be used in queries to hide from users the complexity of joins between the tables. Converting your Access queries into views and stored procedures will help migrate your Access applications to the SQL Server environment in the future.

This chapter concludes Part III of this book, which presented numerous examples of using SQL DDL statements inside VBA procedures and in the Access SQL Query Design window. In particular, you learned how DDL statements are used to create tables, views, stored procedures, primary keys, indexes, and constraints that define the database. You also learned a couple of advanced Data Manipulation Language (DML) statements. Although there is more to Access SQL than this part has covered, this should be quite sufficient to get you started using SQL in your own applications.

This page intentionally left blank.


0 0

Post a comment