chapter 3Forms-Based Database Queries

This chapter provides an overview of forming and running database queries using the forms-based query tool in Microsoft Access. Even if you never intend to use Microsoft Access or another forms-based database query product, at least give this chapter a quick read because it will help you visualize database concepts. Also keep in mind that Chapter 4 introduces SQL, the standard query language for all modern relational databases.

CHAPTER OBJECTIVES

In this chapter, the reader should:

• Understand the basics of forms-based queries.

• Be able to use Microsoft Access and the video store sample database to create and run queries.

QBE: The Roots of Forms-Based Queries

A forms-based query language uses a GUI panel ...

Get Databases DeMYSTiFieD, 2nd Edition, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.