In this chapter, you will learn about temporary tables and how they are created, accessed, queried, indexed, and deleted. You will also learn the differences between temporary tables and views.
Temporary table — A table that encompasses the result of a saved SELECT statement.
View — A saved query that queries one or more tables.
As discussed earlier in this book, a view is a saved query that queries one or more tables. They are commonly used to restrict data from users for security purposes, shorten complex queries, and combine data from multiple tables. Views are very useful in Microsoft Access since they enable you to query data in the database in much the same way as you would a table. ...