Microsoft Office Tutorials and References
In Depth Information
Creating a Simple Query
New (blank) record
Oren suggests that you use the various navigation techniques to move through the
Contract table and become familiar with its contents.
To navigate the Contract datasheet:
1. Click the first record’s ContractNum field value ( 3011 ). The Current Record box
shows that record 1 is the current record.
You can make a field the
current field by
clicking anywhere within the
column for that field.
2. Click the Next record navigation button . The second record is now
highlighted, which identifies it as the current record. Also, notice that the second
record’s value for the ContractNum field is selected, and the Current Record box
displays “2 of 65” to indicate that the second record is the current record.
3. Click the Last record navigation button
. The last record in the table,
record 65, is now the current record.
4. Drag the scroll box in the vertical scroll bar (see Figure 1-18) up to the top of the
bar. Notice that record 65 is still the current record, as indicated in the Current
Record box. Dragging the scroll box changes the display of the table datasheet,
but does not change the current record.
5. Drag the scroll box in the vertical scroll bar back down until you can see the end
of the table and the current record (record 65).
6. Click the Previous record navigation button
. Record 64 is now the current
7. Click the First record navigation button
. The first record is now the current
record and is visible on the screen.
The Contract table now contains all the data about the customer contracts for Belmont
Landscapes. To better understand how to work with this data, Oren asks you to create
simple objects for the other main types of database objects—queries, forms, and reports.
Creating a Simple Query
As noted earlier, a query is a question you ask about the data stored in a database. When
you create a query, you tell Access which ﬁ elds you need and what criteria Access
should use to select the records that will answer your question. Then Access displays
only the information you want, so you don’t have to navigate through the entire database
for the information. In the Contract table, for example, Oren might create a query to
display only those records for contracts that were signed in a speciﬁ c month. Even though
a query can display table information in a different way, the information still exists in the
table as it was originally entered.
Oren wants to focus on the amount of each contract and the contract type. He doesn’t
want the list to include all the ﬁ elds in the Contract table, such as CustomerID and