Microsoft KB Archive/141928

= Works 95 FAQ: General Database Questions =

Article ID: 141928

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Works 4.0a
 * Microsoft Works 4.5a

-



This article was previously published under Q141928



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 the document already contains information, it means it has been saved as a default template. To turn off the default template, use the steps below.

 Create a new database document. On the File menu, click Save As. Click Template, and then click Defaults. Click Clear to remove the specified default template. Click Cancel to close the dialog box.</ol> </li> Q. How do I export my data from Works to Microsoft Access?

A. <ol> Open the file in Works for Windows.</li> On the File menu, click Save As.</li> Click the Save As Type and choose dBASE IV. Click Save.</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 Works: 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 As Type, and choose a format the other program supports, such as dBASE IV (.dbf) or Text and Tabs.</li> Click Save.</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 your user's guide or contact the program manufacturer.

Microsoft Works for Windows 95 supports the following database formats:

<ul> dBASE III</li> dBASE IV</li> Text, comma-separated</li> <li>Text, tab-separated</li> <li>Microsoft Works for Windows 3.0 DB</li> <li>Microsoft Works for Windows 2.0/Microsoft Works for DOS</li> <li>Microsoft Works 3.0 for Macintosh DB</li> <li>Microsoft Works 4.0 for Macintosh DB</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 Microsoft Works, do the following:

<ol> <li>On the File menu, click Open.</li> <li>In the Files Of Type box, click the type of document you want to open. All supported formats are listed here.</li> <li>Select the document, and then click Open or 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 your 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 Design view and resize each field so that it is at least as large as its longest entry.</li> <li>Q. Why are fields completely blank after I export to 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. Then, on the Format menu, click Field and verify that the field has the correct numeric formatting. For example, each text field must be formatted as General or Text.</li> <li>Q. How do I make a multiple-line field?

A. If you want 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>

If you want a multiple-line field in Form view, do the following:

<ol> <li>On the View menu, click Form Design.</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 use a report, do the following:

<ol> <li>On the Tools menu, click Report Creator.</li> <li>Name the report and click OK.</li> <li>Step through the Report Creator, selecting the options you want on each tab.</li> <li>On the Summary tab, select the field that you want totaled and select the Sum box.</li> <li>Click Done.</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 Microsoft 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 keep a running total 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 that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Additional query words: 4.00 4.50 w_works db datbases facks fax facs faqs

Keywords: kbinfo kbfaq KB141928

-

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

© Microsoft Corporation. All rights reserved.