Operation Manual

To move to another record when the form has a subform, click any of the fields of the main form. In
this case, click the Date field of the main form. Then use the directional arrows at the bottom.
There are four of them from left to right: First Record, Previous Record, Next Record, and Last
Record (Figure 232). To the right of these arrows is the New Record icon.
To create a new record while in another record in the main form, click either the Next Record icon
or the New Record icon.
Tip
The number in the Record box is the number of the record whose data is shown in
the form.
If you know the number of the record you want, you can enter it into the record box
and then press Enter to take you to that record.
Figure 234 is a record with data inserted in its fields.
Figure 234: Sample record of the Vacation form and sub form
Creating queries
Queries are used to get specific information from a database. Query results are special tables
within the database.
To demonstrate the use of queries, we will use two different methods:
• Using our CD-Collection table, we will create a list of albums by a particular artist. We will
do this using the Wizard.
• The information we might want from the Fuel table includes what our fuel economy is. We
will do this using the Design View. (Queries that require calculations are best created with
the Design view.)
Chapter 8 Getting Started with Base | 245