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

Introducing Jet Queries

Queries are an essential tool in any database management system. You use queries to select records, and add, update, and delete records in tables. Most often you use queries to select specific groups of records that meet criteria you specify. You can also use queries to combine information from different tables, providing a unified view of related data items. In this chapter, you learn the basics of creating your own select queries, including specifying selection criteria and using the results of your queries to generate reports and create new tables. You create queries using more than one table in Chapter 11, “Creating Multitable and Crosstab Queries,” after you learn the details of how to use operators and create expressions in Chapter 10, “Understanding Jet Query Operators and Expressions.”

This chapter covers queries that apply to Jet databases and to client/server databases, such as SQL Server, that you link to a conventional Access front-end .mdb file. When you link client/server tables to an Access front end, your application uses the Jet query engine to process the back-end data. Jet has its own dialect of SQL, called Jet SQL, which, for the most part, conforms to the ANSI SQL-92 standard but has several extensions that aren't included in SQL-92. All query techniques you learn in Part III, “Transforming Data with Queries and PivotTables,” apply to Jet databases and client/server tables linked to a front end that stores queries, forms, reports, and modules in an .mdb file.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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