Microsoft KB Archive/136167

Works 95 FastTips: Database Questions & Answers

PSS ID Number: Q136167 Article last modified on 06-22-1999

WINDOWS|MACINTOS:4.0,4.0a,4.5

WINDOWS|MACINTOS

================================================================ ==

The information in this article applies to:

 == Microsoft Works for Windows, versions 4.0, 4.0a, 4.5 == 

= SUMMARY =

This article contains the Works 4.0 Database Questions and Answers.

= MORE INFORMATION =

Q. Why can’t I add, delete, or change a field in Form view?

A. Works 4.0 for Windows 95 differs from earlier versions of Works for Windows by having a separate view for the design and layout of the database form, called Form Design view. To add a field, move an existing field, or otherwise change the layout of the form, click Form Design on the View menu. Form view is used for entering or changing the data that is in the fields.

Q. What is a filter?

A. A filter, formerly called a query in earlier versions of Works for Windows, is a set of criteria that you specify to tell Works which records to display. For example, if you have an address database of 1000 records, but you are only interested in those records that are from the state of Washington, you can create a filter so that all the records of people from states other than Washington are “filtered out” (that is not visible). The other records are still part of your database, but they are in the background, allowing you to see the data you need. For more information about creating and using filters, see your Works online Help.

Q. How much data can I enter per field in Works 4.0?

A. Works 4.0 can accept up to 2K of data per field. Each character typically uses one byte, and 2K is equal to 2048 bytes. However, some space must be allocated for special characters, such as dollar signs, negative value signs, and so on.

Q. How do I print specific records of my database?

A. To print specific records, perform the following four steps:

1. On the View menu, click List.

2. Mark the records you want to print by clicking the boxes next to the record numbers on the left side of the screen.

3. On the Record menu, point to Show, and then click Marked Records.

Now when you print, only those records you marked will print. Q. What is a report?

A. Reports organize and summarize your database information. Use the ReportCreator, available on the Tools menu, to quickly generate a report. First, type a title for your report, and then add the fields you want included in the report. You can also sort, group, or filter the data, or add summary statistics such as totals or averages to the report. ReportCreator automatically creates the report based on your selections. For more information about reports and the ReportCreator, see your Works online Help.

Additional query words: 4.00 4.00a 4.50 kbhowto w_works fasttips

=
========================================================= Keywords :

Version : WINDOWS|MACINTOS:4.0,4.0a,4.5 Platform : WINDOWS|MACINTOS Issue type : kbinfo ============================================================================= Copyright Microsoft Corporation 1999.