Part 1: Par t Title
The Many Faces of Microsoft Access
29
Pa rt 1: Understanding Microsoft Access
th e h orizontal scroll bar to b ring ot her fields in th is quer y into v iew. As in the Desig n v iew o f
tables, you can use F6 to move between the top and bottom portions of the Query window.
You can learn how to build this type of complex multiple-table query in Chapter 8, “Building
Complex Queries." You can find this query used in the Housing Reservations database as the
source of data for the fsubFacilityReservations form.
The Query Window in Datasheet View
Click the View button on the toolbar to run the query and see the query results in Datasheet
view, as shown in Figure 2-12.
The Query window in Datasheet view is similar to a Table window in Datasheet view. Even
though the fields in the query datasheet shown in Figure 2-12 are from three different tables,
you can work with the fields as if they were in a single table. If you’re designing an Access
application for other users, you can use queries to hide much of the complexity of the data-
base and make the application simpler to use. Depending on how you designed the query,
you might also be able to update some of the data in the underlying tables simply by typing
in new values in the Query window as you would in a Table window in Datasheet view. Close
the Query window to see only the Database window.
F02Q Q 12.
bm p
Figure 2-12. Datasheet view of the qr yFacilityReser vations query.
Forms
Datasheets are useful for viewing and changing data in your database, but they’re not partic-
u larl y at tract ive or si mp le t o u se. I f yo u wan t to for mat your dat a i n a sp eci al w ay or auto mate
how your data is used and updated, you need to use a form. Forms provide a number of
important capabilities.
.
You can control and enhance the way your data looks on the screen. For example, you
can add color and shading or add number formats. You can add controls such as drop-
down list boxes and check boxes. You can display ActiveX objects such as pictures and
graphs directly on the form. And you can calculate and display values based on data in
a table or a query.
|
|