Microsoft Office Tutorials and References
In Depth Information
Exhibit 4.1 Accessing form tool in quick access tool bar
shown at the top left of a workbook near the Office button. The Excel Options at
the bottom of the Office button menu permits you to Customize the Quick Access
Toolbar . This process is shown in Exhibit 4.1 and the result is an icon in the Quick
Access that looks like a form (see the arrow).
Form , as the name implies, allows you to create a convenient form for data
entry. We begin the process by creating titles in our familiar columnar data for-
mat. As before, each column represents a field and each row is a record. The Fo rm
tool assumes these titles will be used to guide you in the data entry process (see
Exhibit 4.2). Begin by capturing the range containing the titles, B2:C2, with your
cursor and then find the Fo rm tool in the Quick Access Toolbar . As you can see
from Exhibit 4.2, the tool will prompt you to enter new data for each field of the two
fields identified— Name and Age . Each time you depress the button entitled New ,
the data is transcribed to the data table, just below the last data entry. In this case
the name Maximo and age 22 will be entered below Sako and 43. This process
can be repeated as many times as necessary and results in the creation of a simple
worksheet database.
The Fo rm tool also permits convenient search of the data entered into the
database. Begin by selecting the entire range containing the database. Then using
the Fo rm tool, select the Criteria button to specify a search criterion for the search:
Search JabSto ::




Custom Search