Free E-Books

n The query uses updated versions of records.
Every time the query is executed, it reads the underlying tables and re-creates the recordset.
Because recordsets themselves are not stored, a query automatically reflects any changes to the
underlying tables made since the last time the query was executed??”even in a real-time, multiuser
environment.
Creating a Query
After you create your tables and place data in them, you??™re ready to work with queries. To begin a
query, choose the Create ribbon, and click on the Query Design button in the Other group. Access
opens the query designer in response.
Figure 4-4 shows two windows. The underlying window is the Query Designer. Floating on top of
the designer is the Show Table dialog box. The Show Table window is modal, which means that
you must do something in the dialog box before continuing with the query. Before you continue,
you add the tables required for the query. In this case, tblProducts is highlighted to be added.
The Show Table dialog box shown in Figure 4-5 displays all tables and queries in your database.


Pages:
402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426