SQL Server Views
Many Access developers will be unfamiliar with the concept of a database view even though they may have been using the Access equivalent for many years. It is common practice to build Access queries and to use those queries as the record source for other Queries or SQL statements. You can think of a view as something similar but in this case a lot more powerful. Chapter 15 also discusses views and contains further examples including creating and populating a view using ADO.
KeywordsSelect Statement Main Menu Base Table Query Analyzer Record Source
Unable to display preview. Download preview PDF.