Microsoft Office Tutorials and References
In Depth Information
l The data form appears,
consisting of one field
for each column head
you created.
5
Type the requested
information in the first
field.
5
6
Press Tab to move to
the next field.
8
7
Repeat Steps 5 and 6 to
complete the remaining
fields.
8
After completing the
first set of fields, click
New to start a new
record.
The data fills the worksheet, and the form
fields clear, ready for another record.
l
9
Repeat Steps 5 to 8 for each new record.
0
Click Close after entering all your data.
A list of your data records appears in the
worksheet.
0
Did You Know?
You can use the data form to search for and edit your
data. With the list and form displayed, click the form’s
Criteria button. In a blank field, type an operator,
such as = or > , and a value in one or more fields. For
example, to find all records for Sally, you would type
=”Sally” in the First Name field and then press Enter.
If several records are available, click the Find Prev
(Previous) and Find Next buttons as appropriate. If
you are looking for text, place the text you are
looking for in quotes; if you are looking for a number,
do not place the number in quotes.
Did You Know?
You can use a form with an existing list. Just click and
drag to select the column heads and then click the
Form button on the Quick Access toolbar.
Chapter 4: Manipulate Records
83
 
Search JabSto ::




Custom Search