Creating notebook databases
You can use data forms in Quattro Pro to create notebook databases. Data forms let you do the basic functions of adding, deleting, or changing records in a database using a form, instead of typing the information directly in the notebook cells. Each field from the database is listed, you type in the information, and then Quattro Pro automatically places it in a row in the notebook database.
You can add records to a notebook database. In addition, you can search for records in a notebook database when you need to edit or delete existing records or discover if there are duplicate records. When searching for records, you can navigate through the database to find the information you want.
You can edit information in existing records and delete records that you no longer require.
To create a notebook database |  |
|
1.
|
|
In a blank notebook, type field names in individual columns of row 1.
|
|
For example, you could type Name in cell A1, Address in cell B1, and City in cell C1.
|
|
2.
|
|
Select the field names in row 1 and the empty cells directly beneath them in row 2.
|
|
For example, if you have field names in cells A1 to C1, select the block of cells from A1 to C2.
|
|
3.
|
|
Click Tools
 Data tools Form. |
|
4.
|
|
Click OK.
|
|
5.
|
|
In the Edit records dialog box, type the record information in the corresponding fields.
|
|
6.
|
|
Click New.
|
|
•
|
|
A notebook database can also be created by manually typing data in the rows beneath the appropriate field name. For more information, see “Rules for entering database cells in Quattro Pro.”
|
To add a record to a notebook database | |
|
1.
|
|
Click a cell in the database.
|
|
2.
|
|
Click Tools
Data tools Form. |
|
3.
|
|
Click OK.
|
|
4.
|
|
In the Edit records dialog box, click New.
|
|
5.
|
|
Type the record information in the corresponding fields.
|
|
6.
|
|
Click New.
|
To navigate a notebook database | |
|
1.
|
|
Click a cell in the database.
|
|
2.
|
|
Click Tools
Data tools 
p.jpg" height="14" width="9" border="0" hspace="0" vspace="0" align="absmiddle"> Form. |
|
3.
|
|
Click OK.
|
|
4.
|
|
In the Edit records dialog box, click any of the following navigation buttons:
|
|
•
|
First record
 — moves directly to the first database record |
|
•
|
Last record
 — moves directly to the last database record |
|
•
|
Record forward
 — moves forward one database record |
|
•
|
Record back
 — moves backward one database record |
|
•
|
|
When searching for records, the navigation buttons navigate only records that meet the search criteria. To navigate all database records, clear the search criteria.
|
. Quattro Pro displays the record number above the bar. You can drag the slider from the first record to the last record, and you can stop at any record.To search for a record in a notebook database | |
|
1.
|
|
Click a cell in the database.
|
|
2.
|
|
Click Tools
Data tools Form. |
|
3.
|
|
Click OK.
|
|
4.
|
|
In the Edit records dialog box, click Search.
|
|
5.
|
|
Type the information for which to search in the corresponding fields.
|
|
6.
|
|
Click Record forward
. |
|
•
|
|
To narrow the search, fill out as many fields with search criteria as you can. To broaden the search, use wildcards in your search criteria.
|
To edit a record in a notebook database | |
|
1.
|
|
Click a cell in the database.
|
|
2.
|
|
Click Tools
Datatools Form. |
|
3.
|
|
Click OK.
|
|
4.
|
|
In the Edit records dialog box, click Record back
to locate the record to edit. |
|
5.
|
|
Edit the record.
|
|
6.
|
|
Click Record forward
. |
To delete a record from a notebook database | |
|
1.
|
|
Click a cell in the database.
|
|
2.
|
|
Click Tools
Data tools Form. |
|
3.
|
|
Click OK.
|
|
4.
|
|
In the Edit records dialog box, click Record back
until you locate the record to delete. |
|
5.
|
|
Click Delete.
|
|
•
|
|
You cannot retrieve records after you delete them.
|