• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Exploring Relational Database... > Displaying Data with Queries and Vie...

Displaying Data with Queries and Views

So far, this chapter has concentrated on designing relational databases and their tables, and adding or altering data. SQL SELECT queries return data to Access, but you don't need to write SQL statements to display data in forms or print reports from the data. Access has built-in graphical tools to automatically write Jet SQL for Jet databases and T-SQL for SQL Server databases. Access's query tools use a modern implementation of query-by-example (QBE, an IBM trademark). QBE is a simple method of specifying the tables and columns to view, how the data is sorted, and rows to include or exclude.

Note

As mentioned earlier in the chapter, fields become columns and records become rows in a query. The reason for the change in terminology is that a query's rows and columns need not—and often do not—represent data values stored in the underlying tables. Queries can have columns whose values are calculated from multiple fields and rows with aggregated data, such as subtotals and totals.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint