OpenOffice.org OpenOffice - 3.0 Quick Start Guide Page 252

  • Download
  • Add to my manuals
  • Print
  • Page
    / 433
  • Table of contents
  • BOOKMARKS
  • Rated. / 5. Based on customer reviews
Page view 251
Figure 184: Table in Design View
Note:
If you have several tables to create with the same fields, design
one table and produce the other tables by cutting and pasting.
(See “Creating a table by copying an existing table” on page
247.)
Adding data to the list table
List tables do not require a form. Instead, add their data directly to the
table. In this example, use the names of the two people with a bank
card and Cash for cash purchases.
1) In the main database window, click on the
Tables
icon (Figure
176). Right-click on
Payment Type
and select Open from the
context menu.
a) Enter
Dan
in the first row. Use the tab key to move to the
second row.
b) Enter
Kevin
in the second row.
c) Enter
Cash
in the third row.
2) Save and close the table window.
Tip
The
Enter
key can also be used to move from field entry to field
entry. For this example, enter Jan. in the first
Name
field.
Enter
moves the cursor to the
ID
field.
Enter
then moves the cursor to
the second
Name
field.
The
Down Arrow
key can also be used to move from row to row.
Note
The
PaymentID
field contains
<AutoField>
until you use the
Enter
key to move to the second row. Then it becomes a 0. As
you add the entries to each row, the rows of the
PaymentID
field
change to consecutive whole numbers. For example the first
three numbers in this field are 0,1,2.
Creating a View
A View is a query. Because of this, the details of how to create and use
a View are in the Creating queries section.
252 Getting Started with OpenOffice.org 3
Page view 251
1 2 ... 247 248 249 250 251 252 253 254 255 256 257 ... 432 433

Comments to this Manuals

No comments