Microsoft Office Tutorials and References
In Depth Information
5. Click the First Record navigation button
. The first record is now the current record.
6. Click the Close Window button on the menu bar to close the query.
A dialog box opens and asks if you want to save changes to the design of the query. This
dialog box opens because you changed the sort order of the query results.
7. Click the Yes button to save the query design changes and return to the Database window.
Notice that the EmployerList query now appears in the Queries list box. In addition,
because you maximized the Query window, now the Database window is also maximized.
You need to restore the window.
8. Click the Restore Window button
on the menu bar to restore the Database window.
The query results are not stored in the database; however, the query design is stored as
part of the database with the name you specified. You can re-create the query results at
any time by running the query again. You can also print the query datasheet using the
Print button, just as you can to print a table datasheet. You’ll learn more about creating
and running queries in Tutorial 3.
After Zack views the query results, Elsa asks you to create a form for the Employer table
so that her staff members can use the form to enter and work with data in the table easily.
Creating and Navigating a Form
A form is an object you use to maintain, view, and print 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.
In Access, you can design your own forms or use a Form Wizard to create your forms
automatically. A Form Wizard is an Access tool that asks you a series of questions, and
then creates a form based on your answers. However, an AutoForm Wizard does not ask
you questions. Instead, it places all the fields from a selected table (or query) on a form
automatically, and then displays the form on the screen, making it the quickest way to
create a form.
Elsa wants a form for the Employer table that will show all the fields for one record at a
time, with fields listed one below another in a column. This type of form will make it eas-
ier for her staff to focus on all the data for a particular employer. You’ll use the AutoForm:
Columnar Wizard to create the form.
To create the form using an AutoForm Wizard:
1. Click Forms in the Objects bar of the Database window to display the Forms list. The Forms
list box does not contain any forms yet.
2. Click the New button in the Database window to open the New Form dialog box. See