FREQUENTLY ASKED QUESTIONS:




              dBworxPE  


Q: How do I create a dBworxPEPE file?
A: Start by clicking the "Create new file" button
    on the main screen.  A "Save As" dialog will pop up to let you
    enter a name for your new file (e.g., "Contacts" or "January
    Invoices", etc.).  Once a file name has been entered, the "design"
    screen will appear.  For each field you want to set up, just click on
    "Append record" and enter the information about that field (field 
    description, type, etc.).  When you've set up all the fields for your
    file, click the "Save/Exit" button to return to the main screen.  At
    that point you'll see the column headings in the box on the right
    corresponding to the field descriptions you entered.  You're now in
    entry mode - click on the "Append record" and start keying your
    first record. (Note: if you made a mistake in your setup, click on
    the "Data file structure" button; the design screen will reappear
    and you can edit your field properties).

Q: What's the difference between inserting and appending a record?
A: If you select to append a new record, that record will be added to
    the end of the file.  If you select to insert a new record, that record
    will be added BEFORE the currently selected record (the
    highlighted record in the list box on the right side of the screen).

Q: Can I key information directly into the list box on the right side of
     the main screen (where all the database records are displayed)?
A: No you can't -- to help make the current record more visible, when
    you click on a record in the box on the right or select to add a new
    record dBworxPE displays the individual fields for that record in the
    current record box on the left.  As you key each field, the entries
    you make are immediately mirrored in the actual record on the
    right side of the screen.  Note that you can move downward from
    one field to the next just by hitting the "Enter" key, and you can
    move up to a previous field by pressing the "Page Up" key.

Q: Can I sort items in descending order?
A: Yes -- click the "Records" menu, then select "Sort Descending".

Q: How can I pick out those records that meet two or more different 
    criteria (for example, all customers named "Smith" who have a 
    phone number in the "918" area code)?
A: Run the "Select filter" option (under the Records menu) twice --
    once to select all customers named "Smith" and a second time to
    pick out just those with a "918" area code.

Q: Can I import records from another system into dBworxPE?
A: Yes, if the other system can export your records as a delimited
    file.  dBworxPE can read almost any type of delimited file (such 
    as comma or tab delimited text files) plus dBworxPE can also
    import XML files.

Q: What if I want a field in my database that's calculated based
    on the values of other fields in the same record?
A: You can specify any field as a "formula" or code "F" field --
    then dBworxPE will let you enter a calculation routine or 
    formula for that field.  The formula can involve other fields,
    constants, or even values linked from a different dBworxPE file.

Q: Is there a way to publish a dBworxPE database to my web site?
A: Just open the dBworxPE file you want to put on the web, select 
    "Create web page" from the "File" menu, and follow the 
    instructions.  dBworxPE will create an HTML version of your
    database which can be uploaded directly to the Web.

Q: What if one of my dBworxPE files gets overwritten?
A: The best answer is: TAKE FREQUENT BACKUPS (see the 
    section of the help file on "Saving" and on "Backups").

Q: What if I want to copy just certain fields from an existing 
   dBWorxPE database file to a new dBworxPE file?
A: Open your dBworxPE file and select "Save As" and enter the name of
    the new file you want to create.  Once the new file has been
    created, click on the "Data File Structure" button and (in the design
    screen) delete the fields you don't want.  Then click the "Save/Exit"
    button to return to the Entry screen.