Database Reference
In-Depth Information
You can use these controls to assemble custom forms for your database.
SEE ALSO
For information about form controls, see “Adding controls” in Chapter 8,
“Create custom forms.”
11
Click away from the gallery to close it.
12
Close all the open database objects by right-clicking the tab of the
Customers
form
and then clicking
Close All
.
CLEAN UP
Keep the GardenCompany01 database open for use in later exercises.
Exploring queries
You can locate specific information stored in a table, or in multiple tables, by creating
a query that specifies the criteria you want to match. Queries can be quite simple—for
example, you might want a list of all products in a specific category that cost less than
$10.00. They can also be quite complex—for example, you might want to locate all out-
of-state customers who have purchased gloves within the last three months. For the first
example, you might be able to sort and filter the data in the Products table fairly quickly to
come up with a list. For the second example, sorting and filtering would be very tedious.
It would be far simpler to create a query that extracts all records in the Customers table
whose billing addresses are not in your state and whose customer IDs map to records that
appear in the Orders table within the last three months and whose item IDs map to records
classified as gloves in the Products table.
