Microsoft KB Archive/154507

= Works 3.0 FAQ: General Database Questions =

Article ID: 154507

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 3.0a
 * Microsoft Works 3.0b

-



This article was previously published under Q154507



SUMMARY
This article provides answers to frequently asked Works Database questions.



MORE INFORMATION
 Q. Why does my new database already contain information?

A. When you create a new document and it contains information, this means it has been saved as a default template. To turn off the default template, use the steps below:  On the File menu, click Templates. Select a database template.

NOTE: The database templates are preceded by a blue and white icon. Check each database template to make sure the Use This Template For All New Database Documents box, does not contain a check mark. Click New & Recent Documents. Click Database to create a blank database document.</ol> </li> Q. How do I export my data from Works to Microsoft Access 1.0 or 2.0?

A. Follow these steps:

<ol> Open the file in Works.</li> On the File menu, click Save As.</li> Click the Save File As Type box, and choose dBASE IV. Click OK.</li> In Microsoft Access, open an existing database or create a new database.</li> On the File menu, click Import.</li> Select dBASE IV as the Data Source.</li> In the Select File dialog box, find and select your Works for Windows database file. Click Import.</li></ol>

For more information about transferring files to Microsoft Access, see following article in the Microsoft Knowledge Base:

93429 How to Import a Works for Windows Database to MS Access

</li> Q. How do I export my data to another database program?

A. To export a document into a format that Works supports, do the following.

<ol> Open the document you want to save.</li> On the File menu, click Save As.</li> Click the Save File as Type box and choose a format the other program supports, such as dBASE IV (.dbf) or Text and Tabs.</li> Click OK.</li></ol>

If you are trying to save a document for use in another database, and that format is not available in the Save As Type box, select a format that the other database program can import. For information about the types of formats supported by the database program, see the program's user's guide or contact the program manufacturer.

Microsoft Works 3.0x supports the following database formats: <ul> dBASE III</li> dBASE IV</li> Text, comma-separated</li> <li>Text, tab-separated</li> <li>Works for Windows, 2.0/Works for MS-DOS</li></ul>

</li> <li>Q. How do I import data from other database programs into Works?

A. You can import documents from several different database formats into Works using commonly supported file formats. To open a document that is directly supported by Works, do the following:

<ol> <li>On the File menu, click Open Existing File.</li> <li>In the List Files Of Type box, click the type of document you want to open. All supported formats are listed there.</li> <li>Select the document, and then click OK.</li></ol>

If you're trying to open a document from a database that is not included in the Files Of Type box, you must convert the document into one of the supported formats using the program that created database. For information about the types of formats supported by the database program, see the program's user's guide or contact the program manufacturer.</li> <li>Q. What causes the message "Some text has been truncated" when I save a document in dBASE format?

A. This error occurs if the field width for any field in Form view is insufficient. To correct this problem, switch to Form Form view and resize each field so that it is at least as large as its longest entry.</li> <li>Q. Why are some fields completely blank after I export my Works database to a dBASE file format?

A. This is usually a result of numeric or date formatting in fields containing text. To correct this problem, select a field that is blank after exporting. On the Format menu, click Number and verify that the field has the correct numeric formatting; each text field must be formatted as General or Text.</li> <li>Q. How do I make a multiple-line field?

A. To create a multiple-line field in List view, do the following:

<ol> <li>Select the field.</li> <li>On the Format menu, click Alignment.</li> <li>Make sure the Wrap Text box contains a check mark.</li> <li>Click OK.</li></ol>

To create want a multiple-line field in Form view, do the following: <ol> <li>On the View menu, click Form.</li> <li>Select the field.</li> <li>On the Format menu, click Field Size.</li> <li>In the Height box, type the number of lines you want in the field.</li> <li>Click OK.</li></ol> </li> <li>Q. How do I total a column/field in the Works database?

A. The best way to total a field in a Works database is to use a report. To create a report, do the following: <ol> <li>On the Tools menu, click Create New Report.</li> <li>Give the report a name and add any fields you want included on the report. Click OK.</li> <li>On the Report Statistics dialog box, select the field that you want totaled and place a check in the Sum box.</li> <li>Click OK.</li></ol> </li> <li>Q. How do I create a running total in the database?

A. A running total shows the sum of all the values in a specific field up to any given record. In a Works database, you can use a formula to automatically create and calculate a running total. For example, if you have a field called "Gizmos" and you want to track additions and subtractions of your inventory of Gizmos, do the following: <ol> <li>Enter the starting number of Gizmos in record 1 of the field.</li> <li>Create a new field named "Total".</li> <li>Enter the same number in the first record of the Total field.</li> <li>In the second record of the Total field, type the formula

=Gizmos+Total

</li></ol> </li> <li>Q. How do I combine text from two separate fields into one field?

A. To combine text from two fields into one, use the ampersand (&) to join the fields. You may also want to include one space. For example, if Field1 contains "John" and Field2 contains "Brown", the following formula will produces a combined "John Brown" in Field3:

=Field1&" "&Field2.

</li></ol>

The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

Additional query words: w_works db datbases facks fax facs faqs F.a.q.s.

Keywords: kberrmsg kbinfo kbinterop kb3rdparty KB154507

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.