ASTRO astrojet II plus, Installation And Operating Manual

Page: 37 / 62

33
7. The wizard will ask about # of fields per record – leave it at 0, is the “First record
is used to record field names” – check this box, and delimiter information – leave
the defaults. Press “Next” or “Finish”.
Your project is now associated with the converted database. Access to any record in
the database should be almost instantaneous and the Control Panel should always
provide individual page information faster than the printer can supply stock.
Indexing a Microsoft Access *.MDB file
To index an Access database file for use with the Layout Editor and Control Panel you
will need Microsoft Access ’97 (or 2000). This should be installed on the target system
to ensure the same leave of ODBC is available to Access and the Layout Editor and
Control Panel. Then follow this procedure:
1. Start ACCESS and open the database file, (for example: “MY SAMPLE.MDB”.
2. Select the table to be used - here it is “MY SAMPLE”.
3. Click the “Design” button. A window displaying the characteristics of each field
(column) in the database is drawn.
4. Select the first row by clicking in the blank gray square to its left. This selects the
characteristics of first column.
5. At the bottom left click in the cell to the right of the heading “Allow Zero Length”
to display a drop down arrow, from which you will select “yes”.
6. Click the cell to the right of the heading “Indexed” to display a drop down arrow,
from which you select “Yes (Duplicates OK)”
7. Exit Access.
Indexing a dBase III, IV, V, FoxPro (*.DBF) File
To index a dBase file for use with the Layout Editor and Control Panel you will need
Microsoft FoxPro. This should be installed on the target system to ensure the same
leave of ODBC is available to Access and the Layout Editor and Control Panel. Then
follow this procedure:
1. Start FoxPro and open the database file, (for example: “SAMPLE.DBF”.
2. Select the table to be used - here it is “SAMPLE”.
3. If you are asked about the character set to use, select 1252 – Windows ANSI.
4. From the “View” menu select “Table Designer”. A tabbed dialog wills popup.
5. Select the “Fields” tab. Note the name of the first field. Select the Indexes tab.
6. In the cell under Name, type the name for your index. In this case “SAMPLE”.
7. Once this is entered other fields become available. Fill in the following fields:
A. Order – click to show an up arrow (ascending)
B. Type – select regular
C. Expression – enter the field name you noted above
D. Filter – leave blank