Microsoft Office Tutorials and References
In Depth Information
Creating a Simple Form
The ContractList query datasheet displays the three selected fields for each record
in the Contract table. The fields are shown in the order you selected them in the
Simple Query Wizard, from left to right. The records are listed in order by the
primary key field, ContractNum. Even though the query datasheet displays only the
three fields you chose for the query, the Contract table still includes all the fields
for all records.
Notice that the navigation buttons are located at the bottom of the window. You
navigate a query datasheet in the same way that you navigate a table datasheet.
7. Click the Last record navigation button
. The last record in the query
datasheet is now the current record.
8. Click the Previous record navigation button
. Record 64 in the query
datasheet is now the current record.
9. Click the First record navigation button
. The first record is now the current
10. Click the Close ‘ContractList’ button on the object tab. A dialog box opens
asking if you want to save the changes to the layout of the query. This dialog box
opens because you resized the ContractType column.
11. Click the Yes button to save the query layout changes and close the query.
The query results are not stored in the database; however, the query design is stored as
part of the database with the name you specifi ed. You can re-create the query results at
any time by opening the query again. You’ll learn more about creating and working with
queries in Tutorial 3.
Next, Oren asks you to create a form for the Contract table so that Belmont
Landscapes employees can use the form to enter and work with data in the table easily.
Creating a Simple Form
As noted earlier, you use a form to enter, edit, and view records in a database. Although
you can perform these same functions with tables and queries, forms can present data in
many customized and useful ways.
Oren wants a form for the Contract table that shows all the fi elds for one record at
a time, with fi elds listed one below another in a column. This type of form will make it
easier for his staff to focus on all the data for a particular contract. You’ll use the Form
tool to create this form quickly and easily.
To create the form using the Form tool:
1. Make sure the Contract table is still open in Datasheet view. The table or other
database object you’re using as the basis for the form must either be open or
selected in the Navigation Pane when you use the Form tool.
Trouble? If the Contract table is not open, click the Shutter Bar Open/Close
Button to open the Navigation Pane. Then double-click Contract to open the
Contract table in Datasheet view. Click the Shutter Bar Open/Close Button
close the pane.
2. In the Forms group on the Create tab, click the Form button. The Form tool
creates a simple form showing every field in the Contract table and places it on a tab
named “Contract.” Access assigns this name because the form is based on the
Contract table. See Figure 1-22.
Search JabSto ::

Custom Search