PC World Komputer 1997 February/PCWK0297.iso/lotus/english/lotus016.dsk/LA1N40EN.CNT

Microsoft Windows Help File Content | 1995-10-03 | 72KB | 852 lines

:Base la1n40en.hlp>Steps
:Title Approach Help
:Index Lotus Chart Help=lc1n20en.hlp
:Index LotusScript IDE Help=lsen30en.hlp
:Index LotusScript Language Help=lsln30en.hlp
:Index Approach LotusScript Reference Help=lasn40en.hlp
:Index Freelance Graphics LotusScript Reference Help=fl2c10en.hlp
:Index Word Pro LotusScript Reference Help=wp0n70en.hlp
:Index TeamMail Help=tm1n10en.hlp
:Index Lotus Customer Support Help=cs1n40en.hlp
1 Getting Started
2 Using Help=[e-mail]>Overview
2 Planning a Database
3 Why build a database?=[e-mail]>Overview
3 What will a database do for you?=[e-mail]>Overview
3 What questions will you ask the database?=[e-mail]>Overview
3 What kind of data?=[e-mail]>Overview
3 Identify main ideas and group fields under them=[e-mail]>Overview
3 Make connections between the groups=[e-mail]>Overview
3 Check for redundant information=[e-mail]>Overview
3 Use SmartMasters=[e-mail]>Overview
3 Build the database in Approach=[e-mail]>Overview
2 Did You Know. . .
3 Browse is for data, Design is for style=[e-mail]>Overview
3 Approach saves data automatically=[e-mail]>Overview
3 A sort is not a find=[e-mail]>Overview
3 Select Print Preview to see report summaries=[e-mail]>Overview
1 Top 10 Tasks
2 Importing and Exporting Data
3 Importing Data
4 Importing data into databases=[e-mail]>Steps
4 Opening databases created in other applications=[e-mail]>Steps
4 Creating databases from spreadsheets=[e-mail]>Steps
4 Creating databases from delimited text files=[e-mail]>Steps
4 Creating databases from fixed-length text files=[e-mail]>Steps
4 Importing Approach files=[e-mail]>Steps
4 Mapping fields=[e-mail]>Overview
4 Pasting pictures in fields=[e-mail]>Steps
3 Exporting Data
4 Exporting data from Approach=[e-mail]>Steps
4 Copying PicturePlus pictures to a file=[e-mail]>Steps
2 Creating Databases
3 Creating a new database from scratch=[e-mail]>Steps
3 Creating a new database with a set of ready-to-use fields=[e-mail]>Steps
3 Creating a new database that is a ready-to-use application=[e-mail]>Steps
3 Opening databases created in other applications=[e-mail]>Steps
3 Creating databases from spreadsheets=[e-mail]>Steps
3 Creating databases from delimited text files=[e-mail]>Steps
3 Creating databases from fixed-length text files=[e-mail]>Steps
3 Creating custom SmartMasters=[e-mail]>Steps
3 Mapping fields=[e-mail]>Overview
2 Creating and Formatting Fields
3 Defining Fields for Databases
4 Overview: Types of fields=[e-mail]>Overview
4 Adding fields to a database=[e-mail]>Steps
4 Writing formulas for calculated fields=[e-mail]>Steps
4 Calculating a summary across records=[e-mail]>Steps
4 Editing fields of a database=[e-mail]>Steps
4 Specifying a key field for a Paradox database=[e-mail]>Steps
4 Deleting fields from a database=[e-mail]>Steps
3 Displaying Fields in Views
4 Overview: Fields=[e-mail]>Overview
4 Adding fields to a view=[e-mail]>Steps
4 Displaying fields as scrolling lists=[e-mail]>Steps
4 Displaying fewer values in a scrolling list=[e-mail]>Steps
4 Displaying descriptive values in a scrolling list=[e-mail]>Steps
4 Displaying fields as check boxes=[e-mail]>Steps
4 Displaying fields as radio buttons=[e-mail]>Steps
4 Rearranging a set of radio buttons or check boxes=[e-mail]>Steps
2 Entering and Editing Data
3 Adding, Deleting, and Hiding Records
4 Adding new records=[e-mail]>Steps
4 Duplicating records=[e-mail]>Steps
4 Deleting specific records=[e-mail]>Steps
4 Deleting a found set of records=[e-mail]>Steps
4 Deleting all records=[e-mail]>Steps
4 Hiding records=[e-mail]>Steps
4 Showing hidden records=[e-mail]>Steps
3 Entering Data in Fields
4 Selecting fields=[e-mail]>Steps
4 Entering text in text or memo fields=[e-mail]>Steps
4 Entering values in numeric fields=[e-mail]>Steps
4 Entering values in Boolean fields=[e-mail]>Steps
4 Entering dates in date fields=[e-mail]>Steps
4 Entering times in time fields=[e-mail]>Steps
4 Duplicating a value from the last record modified=[e-mail]>Steps
4 Selecting from a drop-down box=[e-mail]>Steps
4 Selecting radio buttons or check boxes=[e-mail]>Steps
4 Entering the same data into many records=[e-mail]>Steps
4 Pasting pictures in fields=[e-mail]>Steps
4 Drawing in PicturePlus fields=[e-mail]>Steps
3 Moving to Another Record
4 Moving through records one record at a time=[e-mail]>Steps
4 Moving to the first or last record=[e-mail]>Steps
4 Moving to a specific record=[e-mail]>Steps
3 Checking Spelling
4 Checking spelling=[e-mail]>Steps
4 Editing the user dictionary=[e-mail]>Steps
4 Changing to another main dictionary=[e-mail]>Steps
4 Setting options for checking spelling=[e-mail]>Steps
3 Finding and Replacing Text
4 Finding text=[e-mail]>Steps
4 Replacing text=[e-mail]>Steps
2 Laying Out and Styling Views
3 Overview: InfoBox=[e-mail]>Overview
3 Working with Named Styles
4 Overview: Working with named styles=[e-mail]>Overview
4 Defining new named styles=[e-mail]>Steps
4 Applying named styles=[e-mail]>Steps
4 Applying a named style from the InfoBox=[e-mail]>Steps
4 Copying named styles=[e-mail]>Steps
4 Editing named styles=[e-mail]>Steps
4 Deleting named styles=[e-mail]>Steps
3 Adding Objects to the Background of a View
4 Drawing geometric objects=[e-mail]>Steps
4 Adding text blocks=[e-mail]>Steps
4 Adding multiple objects to a view=[e-mail]>Steps
4 Pasting pictures in views=[e-mail]>Steps
4 Inserting dates or times=[e-mail]>Steps
4 Adding buttons to run macros=[e-mail]>Steps
3 Changing Objects and Text
4 Applying properties from another object (Fast Format)=[e-mail]>Steps
4 Selecting objects=[e-mail]>Steps
4 Resizing objects=[e-mail]>Steps
4 Moving objects=[e-mail]>Steps
4 Selecting text in text blocks=[e-mail]>Steps
4 Cutting or copying objects or text=[e-mail]>Steps
4 Changing the width of lines or borders=[e-mail]>Steps
4 Creating partial borders=[e-mail]>Steps
4 Making objects and views transparent=[e-mail]>Steps
4 Putting objects and fields in the tab order=[e-mail]>Steps
4 Changing the tab order on views=[e-mail]>Steps
3 Working with More Than One Object at a Time
4 Grouping and ungrouping objects=[e-mail]>Steps
4 Changing the order of overlapping objects=[e-mail]>Steps
4 Aligning and distributing objects=[e-mail]>Steps
3 Editing Views
4 Naming views=[e-mail]>Steps
4 Selecting a main database for a view=[e-mail]>Steps
4 Changing the menu for a view=[e-mail]>Steps
4 Hiding views=[e-mail]>Steps
4 Redisplaying hidden views=[e-mail]>Steps
4 Showing more of the view by hiding its margins=[e-mail]>Steps
4 Changing the width of the view border=[e-mail]>Steps
4 Creating partial borders for views=[e-mail]>Steps
4 Duplicating views=[e-mail]>Steps
4 Deleting views=[e-mail]>Steps
4 Deleting elements of a view=[e-mail]>Steps
4 Adding fields to a view=[e-mail]>Steps
2 Joining Databases
3 Joining database files=[e-mail]>Steps
3 Setting options for a join=[e-mail]>Steps
3 Making calculated fields available for joins=[e-mail]>Steps
3 Unjoining database files=[e-mail]>Steps
3 Overview: Joined databases=[e-mail]>Overview
3 Overview: Main and detail databases in a view=[e-mail]>Overview
3 Overview: One-to-many, many-to-one, and one-to-one relationships=[e-mail]>Overview
3 Overview: Many-to-many relationships=[e-mail]>Overview
3 Overview: Alias joins=[e-mail]>Overview
3 Joining a database to itself (alias join)=[e-mail]>Steps
2 Finding Records
3 Overview: The found set=[e-mail]>Overview
3 Showing all records=[e-mail]>Steps
3 Finding Records Using the Find Assistant
4 Overview: Finding records with the Find Assistant=[e-mail]>Overview
4 Selecting a find type with the Find Assistant=[e-mail]>Overview
4 Creating a find condition with the Find Assistant=[e-mail]>Steps
4 Finding duplicate records with the Find Assistant=[e-mail]>Steps
4 Finding distinct or unique records with the Find Assistant=H_[e-mail]>Steps
4 Finding the top or lowest values with the Find Assistant=[e-mail]>Steps
4 Sorting fields with the Find Assistant=[e-mail]>Steps
3 Finding Records Using Query by Box
4 Finding records using Query by Box=[e-mail]>Steps
4 Overview: Defining find conditions graphically in Query by Box=[e-mail]>Overview
4 Overview: Multiple find conditions in Query by Box=[e-mail]>Overview
3 Finding Records Using a Blank View
4 Creating find requests=[e-mail]>Steps
4 Finding records that satisfy multiple conditions (AND)=H_FINDING_RECORDS_THAT_SATISFY_MULTIPLE_CONDITIONS_(AND)[e-mail]>Steps
4 Finding records that satisfy at least one of several conditions (OR)=H_FIND_RECORDS_TO_SATISFY_ONE_OF_SEVERAL_CONDITIONS_(OR)[e-mail]>Steps
4 Finding records with OR conditions in more than one field=H[e-mail]>Steps
4 Finding text with wildcards=[e-mail]>Steps
4 Finding case-sensitive text=[e-mail]>Steps
4 Finding a word that sounds like another=[e-mail]>Steps
4 Finding numbers, dates, and times=[e-mail]>Steps
4 Finding values in a range=[e-mail]>Steps
4 Finding today's date=[e-mail]>Steps
4 Finding radio button and check box settings=[e-mail]>Steps
4 Finding blank or nonblank fields=[e-mail]>Steps
4 Using If statements to find data=[e-mail]>Steps
4 Repeating finds=[e-mail]>Steps
3 Creating Named Finds
4 Naming finds with the Find Assistant=[e-mail]>Steps
4 Naming and reviewing finds with the Find Assistant=[e-mail]>Overview
4 Naming finds based on find requests=[e-mail]>Steps
4 Editing named finds=[e-mail]>Steps
4 Copying named finds=[e-mail]>Steps
4 Deleting named finds=[e-mail]>Steps
4 Running named finds=[e-mail]>Steps
2 Sorting Records
3 Specifying a sort order=[e-mail]>Steps
3 Sorting records by a field in a view (Ascending)=[e-mail]>Steps
3 Sorting records by a field in a view (Descending)=[e-mail]>Steps
3 Setting a default sort order for looking at records in Browse=[e-mail]>Steps
3 Setting a default sort order for a repeating panel=[e-mail]>Steps
2 Creating Reports
3 Overview: Reports=[e-mail]>Overview
3 Overview: Report panels=[e-mail]>Overview
3 Using PowerClick Reporting
4 Creating a PowerClick report with a grand total=[e-mail]>Steps
4 Creating a PowerClick report with subtotals for groups=[e-mail]>Steps
4 Grouping records in reports=[e-mail]>Steps
4 Adding summaries to reports=[e-mail]>Steps
3 Creating Reports
4 Deciding what new reports look like=[e-mail]>Overview
4 Adding fields to new reports=[e-mail]>Steps
4 Grouping records in new reports=[e-mail]>Steps
4 Adding repeating fields to new repeating panel reports=[e-mail]>Steps
4 Adding summaries to new reports=[e-mail]>Steps
3 Summarizing Data in Reports
4 Adding summaries to reports=[e-mail]>Steps
4 Summary calculations=[e-mail]>Overview
4 Choosing which records go into a summary=[e-mail]>Steps
4 Moving summaries=[e-mail]>Steps
3 Revising Reports
4 Adding fields to reports=[e-mail]>Steps
4 Creating charts in reports=[e-mail]>Steps
4 Selecting, moving, and deleting report panels=[e-mail]>Steps
4 Grouping records in reports=[e-mail]>Steps
4 Changing the number of columns in reports=[e-mail]>Steps
4 Moving and resizing report columns=[e-mail]>Steps
4 Showing missing records in a report=[e-mail]>Steps
3 Printing Reports
4 Reducing or expanding sections of reports when printing=[e-mail]>Steps
4 Creating title pages for reports=[e-mail]>Steps
4 Adding dates, times, or page numbers to reports=[e-mail]>Steps
4 Changing the number of columns in reports=[e-mail]>Steps
4 Paginating reports=[e-mail]>Steps
2 Previewing and Printing
3 Overview: Printing Approach views=[e-mail]>Overview
3 Downloading data before previewing=[e-mail]>Steps
3 Previewing views=[e-mail]>Steps
3 Printing views=[e-mail]>Steps
3 Formatting worksheets or crosstabs for printing=[e-mail]>Steps
3 Reducing or expanding sections of reports when printing=[e-mail]>Steps
3 Closing up extra space between fields=[e-mail]>Steps
3 Setting objects and fields to slide when printing=[e-mail]>Steps
3 Preventing objects and fields from printing=[e-mail]>Steps
3 Properties of printers=[e-mail]>Overview
3 Specifying the printer, paper, and orientation=[e-mail]>Steps
3 Printing a list of file properties=[e-mail]>Overview
3 Printing a list of database fields=[e-mail]>Steps
3 Printing a diagram of join relationships=[e-mail]>Steps
3 Printing macros=[e-mail]>Steps
1 How Do I?
2 Manage Files
3 Create and Open Files
4 Approach file properties=[e-mail]>Overview
4 Welcome dialog box: Open an Existing Approach File=[e-mail]>Overview
4 Opening Approach files=[e-mail]>Steps
4 Creating a new database from scratch=[e-mail]>Steps
4 Creating a new database with a set of ready-to-use fields=[e-mail]>Steps
4 Creating a new database that is a ready-to-use application=[e-mail]>Steps
4 Opening databases created in other applications=[e-mail]>Steps
4 Creating databases from spreadsheets=[e-mail]>Steps
4 Creating databases from delimited text files=[e-mail]>Steps
4 Creating databases from fixed-length text files=[e-mail]>Steps
4 Creating custom SmartMasters=[e-mail]>Steps
4 Identifying default directories=[e-mail]>Steps
4 Mapping fields=[e-mail]>Overview
3 Protect Data, Assign Password Privileges
4 Overview: Passwords=[e-mail]>Overview
4 TeamSecurity=[e-mail]>Overview
4 Defining password privileges using Copy=[e-mail]>Steps
4 Defining password privileges using New =[e-mail]>Steps
4 Editing password privileges=[e-mail]>Steps
4 Deleting groups or users=[e-mail]>Steps
4 Confirming passwords=[e-mail]>Steps
4 Entering data using optimistic record locking=[e-mail]>Steps
3 Save, Close, and Delete Files
4 Saving Approach files=[e-mail]>Steps
4 Saving a copy of an Approach file and a database file=[e-mail]>Steps
4 Saving a copy of an Approach file only=[e-mail]>Steps
4 Closing Approach files=[e-mail]>Steps
4 Deleting files=[e-mail]>Steps
3 Create Query Files
4 Creating query files in Approach=[e-mail]>Steps
4 Opening query files in Approach=[e-mail]>Steps
4 Saving or exporting data from a query=[e-mail]>Steps
3 Create an SQL SELECT Statement with the SQL Assistant
4 Overview: Connecting to an SQL or ODBC data source=[e-mail]>Overview
4 Installing an ODBC driver =[e-mail]>Steps
4 Selecting tables for an SQL SELECT statement=[e-mail]>Steps
4 Creating joins for an SQL SELECT statement=[e-mail]>Steps
4 Creating find conditions for an SQL SELECT statement=[e-mail]>Steps
4 Selecting fields for an SQL SELECT statement=[e-mail]>Steps
4 Sorting fields for an SQL SELECT statement=[e-mail]>Steps
4 Editing SQL statements=[e-mail]>Steps
2 Define Fields for a Database
3 Add, Edit, and Delete Database Fields
4 Overview: Types of fields=[e-mail]>Overview
4 Adding fields to a database=[e-mail]>Steps
4 Writing formulas for calculated fields=[e-mail]>Steps
4 Calculating a summary across records=[e-mail]>Steps
4 Editing fields of a database=[e-mail]>Steps
4 Specifying a key field for a Paradox database=[e-mail]>Steps
4 Deleting fields from a database=[e-mail]>Steps
3 Customize Fields for Data Entry
4 Entering data automatically=[e-mail]>Steps
4 Verifying the accuracy of entered data=[e-mail]>Steps
4 Setting OLE options for PicturePlus fields=[e-mail]>Steps
4 Setting data options for a variable field=[e-mail]>Steps
2 Add and Edit Fields in Views
3 Display Fields in a View
4 Overview: Fields=[e-mail]>Overview
4 Adding fields to a view=[e-mail]>Steps
4 Displaying fields as scrolling lists=[e-mail]>Steps
4 Displaying fewer values in a scrolling list=[e-mail]>Steps
4 Displaying descriptive values in a scrolling list=[e-mail]>Steps
4 Displaying fields as check boxes=[e-mail]>Steps
4 Displaying fields as radio buttons=[e-mail]>Steps
4 Rearranging a set of radio buttons or check boxes=[e-mail]>Steps
3 Format Data in Fields
4 Formatting dates=[e-mail]>Steps
4 Formatting dates as quarters, thirds, and so on=[e-mail]>Steps
4 Formatting times=[e-mail]>Steps
4 Formatting numbers=[e-mail]>Steps
4 Formatting data in text fields=[e-mail]>Steps
3 Edit Fields and Their Labels
4 Changing text attributes of labels or data=[e-mail]>Steps
4 Editing labels=[e-mail]>Steps
4 Changing the position of labels=[e-mail]>Steps
4 Hiding labels=[e-mail]>Steps
4 Closing up extra space between fields=[e-mail]>Steps
4 Changing the tab order on views=[e-mail]>Steps
4 Removing fields from the tab order=[e-mail]>Steps
3 Work with PicturePlus Fields
4 Adding PicturePlus fields to a view=[e-mail]>Steps
4 Setting OLE options for PicturePlus fields=[e-mail]>Steps
4 Pasting pictures in fields=[e-mail]>Steps
4 Editing pictures in PicturePlus fields=[e-mail]>Steps
4 Drawing in PicturePlus fields=[e-mail]>Steps
4 Changing display options for a PicturePlus field=[e-mail]>Steps
4 Copying PicturePlus pictures to a file=[e-mail]>Steps
2 Join Databases
3 Joining database files=[e-mail]>Steps
3 Setting options for a join=[e-mail]>Steps
4 Making calculated fields available for joins=[e-mail]>Steps
3 Unjoining database files=[e-mail]>Steps
3 Overview: Joined databases=[e-mail]>Overview
3 Overview: Main and detail databases in a view=[e-mail]>Overview
3 Overview: One-to-many, many-to-one, and one-to-one relationships=[e-mail]>Overview
3 Overview: Many-to-many relationships=[e-mail]>Overview
3 Overview: Alias joins=[e-mail]>Overview
3 Joining a database to itself (alias join)=[e-mail]>Steps
2 Work in Design
3 Overview: InfoBox=[e-mail]>Overview
3 Customize the Design Environment
4 Showing the grid to help you design views=[e-mail]>Steps
4 Snapping objects to the grid=[e-mail]>Steps
4 Showing rulers=[e-mail]>Steps
4 Showing the Tools palette=[e-mail]>Steps
4 Showing data or field names=[e-mail]>Steps
4 Zooming in and out=[e-mail]>Steps
3 Work with Named Styles
4 Overview: Working with named styles=[e-mail]>Overview
4 Defining new named styles=[e-mail]>Steps
4 Applying named styles=[e-mail]>Steps
4 Applying a named style from the InfoBox=[e-mail]>Steps
4 Copying named styles=[e-mail]>Steps
4 Editing named styles=[e-mail]>Steps
4 Deleting named styles=[e-mail]>Steps
3 Add Objects to the Background of a View
4 Drawing geometric objects=[e-mail]>Steps
4 Adding text blocks=[e-mail]>Steps
4 Adding multiple objects to a view=[e-mail]>Steps
4 Pasting pictures in views=[e-mail]>Steps
4 Inserting dates or times=[e-mail]>Steps
4 Adding buttons to run macros=[e-mail]>Steps
3 Change Objects and Text
4 Applying properties from another object (Fast Format)=[e-mail]>Steps
4 Selecting objects=[e-mail]>Steps
4 Resizing objects=[e-mail]>Steps
4 Moving objects=[e-mail]>Steps
4 Selecting text in text blocks=[e-mail]>Steps
4 Cutting or copying objects or text=[e-mail]>Steps
4 Changing the width of lines or borders=[e-mail]>Steps
4 Creating partial borders=[e-mail]>Steps
4 Making objects and views transparent=[e-mail]>Steps
4 Putting objects and fields in the tab order=[e-mail]>Steps
4 Changing the tab order on views=[e-mail]>Steps
3 Work with More Than One Object at a Time
4 Grouping and ungrouping objects=[e-mail]>Steps
4 Changing the order of overlapping objects=[e-mail]>Steps
4 Aligning and distributing objects=[e-mail]>Steps
3 Edit Views
4 Naming views=[e-mail]>Steps
4 Selecting a main database for a view=[e-mail]>Steps
4 Changing the menu for a view=[e-mail]>Steps
4 Hiding views=[e-mail]>Steps
4 Redisplaying hidden views=[e-mail]>Steps
4 Showing more of the view by hiding its margins=[e-mail]>Steps
4 Changing the width of the view border=[e-mail]>Steps
4 Creating partial borders for views=[e-mail]>Steps
4 Duplicating views=[e-mail]>Steps
4 Deleting views=[e-mail]>Steps
4 Deleting elements of a view=[e-mail]>Steps
4 Adding fields to a view=[e-mail]>Steps
2 Preview and Print
3 Overview: Printing Approach views=[e-mail]>Overview
3 Downloading data before previewing=[e-mail]>Steps
3 Previewing views=[e-mail]>Steps
3 Printing views=[e-mail]>Steps
3 Formatting worksheets or crosstabs for printing=[e-mail]>Steps
3 Reducing or expanding sections of reports when printing=[e-mail]>Steps
3 Closing up extra space between fields=[e-mail]>Steps
3 Setting objects and fields to slide when printing=[e-mail]>Steps
3 Preventing objects and fields from printing=[e-mail]>Steps
3 Properties of printers=[e-mail]>Overview
3 Specifying the printer, paper, and orientation=[e-mail]>Steps
3 Printing a list of file properties=[e-mail]>Overview
3 Printing a list of database fields=[e-mail]>Steps
3 Printing a diagram of join relationships=[e-mail]>Steps
3 Printing macros=[e-mail]>Steps
2 Design Forms and Repeating Panels
3 Create Forms
4 Overview: Forms=[e-mail]>Overview
4 Deciding what new forms look like=[e-mail]>Overview
4 Adding fields to new forms=[e-mail]>Steps
4 Removing or reordering fields while creating new views=[e-mail]>Steps
4 Creating new forms that include a repeating panel=[e-mail]>Steps
4 Adding pages to forms=[e-mail]>Steps
3 Create Repeating Panels
4 Overview: Repeating panels=[e-mail]>Overview
4 Creating new forms that include a repeating panel=[e-mail]>Steps
4 Adding a repeating panel to existing forms=[e-mail]>Steps
4 Summarizing data for records in repeating panels=[e-mail]>Steps
4 Adding fields to repeating panels=[e-mail]>Steps
4 Selecting repeating panels=[e-mail]>Steps
4 Setting a default sort order for a repeating panel=[e-mail]>Steps
4 Naming repeating panels=[e-mail]>Steps
4 Design Repeating Panels
5 Hiding labels in repeating panels=[e-mail]>Steps
5 Rearranging fields in repeating panels=[e-mail]>Steps
5 Resizing repeating panels=[e-mail]>Steps
5 Alternating the color of records in a repeating panel=[e-mail]>Steps
5 Changing the width of borders for repeating panels=[e-mail]>Steps
5 Creating partial borders around repeating panels=[e-mail]>Steps
5 Creating a shadow behind repeating panels=[e-mail]>Steps
2 Design Worksheets
3 Creating new worksheets=[e-mail]>Steps
3 Selecting in worksheets or crosstabs=[e-mail]>Overview
3 Copying selections to the Clipboard=[e-mail]>Steps
3 Dividing worksheets and crosstabs into panes=[e-mail]>Steps
3 Formatting worksheets or crosstabs for printing=[e-mail]>Steps
3 Removing fields from worksheets or crosstabs=[e-mail]>Steps
3 Moving columns in worksheets or crosstabs=[e-mail]>Steps
3 Resizing columns and rows in worksheets or crosstabs =[e-mail]>Steps
3 Adding formula columns to worksheets=[e-mail]>Steps
3 Adding blank columns to worksheets=[e-mail]>Steps
3 Editing column header text=[e-mail]>Steps
2 Design Reports
3 Overview: Reports=[e-mail]>Overview
3 Overview: Report panels=[e-mail]>Overview
3 Use PowerClick Reporting
4 Creating a PowerClick report with a grand total=[e-mail]>Steps
4 Creating a PowerClick report with subtotals for groups=[e-mail]>Steps
4 Grouping records in reports=[e-mail]>Steps
4 Adding summaries to reports=[e-mail]>Steps
3 Create Reports
4 Deciding what new reports look like=[e-mail]>Overview
4 Adding fields to new reports=[e-mail]>Steps
4 Grouping records in new reports=[e-mail]>Steps
4 Adding repeating fields to new repeating panel reports=[e-mail]>Steps
4 Adding summaries to new reports=[e-mail]>Steps
3 Summarize Data in Reports
4 Adding summaries to reports=[e-mail]>Steps
4 Summary calculations=[e-mail]>Overview
4 Choosing which records go into a summary=[e-mail]>Steps
4 Moving summaries=[e-mail]>Steps
3 Revise Reports
4 Adding fields to reports=[e-mail]>Steps
4 Creating charts in reports=[e-mail]>Steps
4 Selecting, moving, and deleting report panels=[e-mail]>Steps
4 Grouping records in reports=[e-mail]>Steps
4 Changing the number of columns in reports=[e-mail]>Steps
4 Moving and resizing report columns=[e-mail]>Steps
4 Showing missing records in a report=[e-mail]>Steps
3 Print Reports
4 Reducing or expanding sections of reports when printing=[e-mail]>Steps
4 Creating title pages for reports=[e-mail]>Steps
4 Adding dates, times, or page numbers to reports=[e-mail]>Steps
4 Changing the number of columns in reports=[e-mail]>Steps
4 Paginating reports=[e-mail]>Steps
2 Design Form Letters
3 Overview: Form letters=[e-mail]>Overview
3 Create Form Letters
4 Deciding what new form letters look like=[e-mail]>Overview
4 Adding the return address to form letters=[e-mail]>Steps
4 Adding the recipient address to form letters=[e-mail]>Steps
4 Adding the salutation to form letters=[e-mail]>Steps
4 Adding the close to form letters=[e-mail]>Steps
4 Adding envelopes to form letters=[e-mail]>Steps
3 Revise Form Letters
4 Entering text in form letters=[e-mail]>Steps
4 Adding fields to form letters=[e-mail]>Steps
4 Changing the date format on form letters=[e-mail]>Steps
4 Moving or deleting form letter fields=[e-mail]>Steps
2 Design Envelopes and Mailing Labels
3 Overview: Envelopes=[e-mail]>Overview
3 Overview: Mailing labels=[e-mail]>Overview
3 Create Envelopes
4 Deciding what new envelopes look like=[e-mail]>Overview
4 Adding the return address to envelopes=[e-mail]>Steps
4 Adding the recipient address to envelopes=[e-mail]>Steps
4 Selecting print settings for envelopes=[e-mail]>Steps
3 Create Mailing Labels
4 Creating mailing labels=[e-mail]>Steps
4 Creating custom mailing label types=[e-mail]>Steps
4 Adding text to mailing labels=[e-mail]>Steps
4 Moving or resizing mailing label fields=[e-mail]>Steps
4 Closing up extra space between fields=[e-mail]>Steps
4 Changing or deleting custom mailing label types=[e-mail]>Steps
2 Design Crosstabs
3 Overview: Crosstabs=[e-mail]>Overview
3 Adding rows to new crosstabs=[e-mail]>Steps
3 Adding columns to new crosstabs=[e-mail]>Steps
3 Adding values to new crosstabs=[e-mail]>Steps
3 Adding summaries to crosstabs=[e-mail]>Steps
3 Editing crosstab summaries=[e-mail]>Steps
3 Adding or moving fields in crosstabs=[e-mail]>Steps
3 Applying found sets to crosstabs=[e-mail]>Steps
3 Adding all groups to crosstabs=[e-mail]>Steps
3 Selecting rows and columns in crosstabs=[e-mail]>Steps
3 Creating charts from crosstabs=[e-mail]>Steps
3 Overview: Drill down to data=[e-mail]>Overview
3 Finding records that make up crosstabs (drill down to data)=[e-mail]>Steps
3 Selecting drill-down views=[e-mail]>Steps
2 Design Charts
3 Create Charts Using the Chart Assistant
4 Overview: Chart Assistant=[e-mail]>Overview
4 Deciding what new charts look like=[e-mail]>Overview
4 Selecting a field for the x-axis=[e-mail]>Steps
4 Selecting fields for the y-axis=[e-mail]>Steps
4 Selecting a field for the series (chart legend)=[e-mail]>Steps
4 Creating pie charts=[e-mail]>Steps
3 Revise Charts
4 Drill-down to data for charts=[e-mail]>Steps
4 Charting a different data set=[e-mail]>Steps
3 Create Charts in Reports and Crosstabs
4 Creating charts in reports=[e-mail]>Steps
4 Creating charts from crosstabs=[e-mail]>Steps
:include LC1N20EN.CNT
2 Enter and Edit Data
3 Add, Delete, and Hide Records
4 Adding new records=[e-mail]>Steps
4 Duplicating records=[e-mail]>Steps
4 Deleting specific records=[e-mail]>Steps
4 Deleting a found set of records=[e-mail]>Steps
4 Deleting all records=[e-mail]>Steps
4 Hiding records=[e-mail]>Steps
4 Showing hidden records=[e-mail]>Steps
3 Enter Data in Fields
4 Selecting fields=[e-mail]>Steps
4 Entering text in text or memo fields=[e-mail]>Steps
4 Entering values in numeric fields=[e-mail]>Steps
4 Entering values in Boolean fields=[e-mail]>Steps
4 Entering dates in date fields=[e-mail]>Steps
4 Entering times in time fields=[e-mail]>Steps
4 Duplicating a value from the last record modified=[e-mail]>Steps
4 Selecting from a drop-down box=[e-mail]>Steps
4 Selecting radio buttons or check boxes=[e-mail]>Steps
4 Entering the same data into many records=[e-mail]>Steps
4 Pasting pictures in fields=[e-mail]>Steps
4 Drawing in PicturePlus fields=[e-mail]>Steps
3 Move to Another Record
4 Moving through records one record at a time=[e-mail]>Steps
4 Moving to the first or last record=[e-mail]>Steps
4 Moving to a specific record=[e-mail]>Steps
3 Check Spelling
4 Checking spelling=[e-mail]>Steps
4 Editing the user dictionary=[e-mail]>Steps
4 Changing to another main dictionary=[e-mail]>Steps
4 Setting options for checking spelling=[e-mail]>Steps
3 Find and Replace Text
4 Finding text=[e-mail]>Steps
4 Replacing text=[e-mail]>Steps
2 Find Records
3 Overview: The found set=[e-mail]>Overview
3 Showing all records=[e-mail]>Steps
3 Find Records Using the Find Assistant
4 Overview: Finding records with the Find Assistant=[e-mail]>Overview
4 Selecting a find type with the Find Assistant=[e-mail]>Overview
4 Creating a find condition with the Find Assistant=[e-mail]>Steps
4 Finding duplicate records with the Find Assistant=[e-mail]>Steps
4 Finding distinct or unique records with the Find Assistant=H_[e-mail]>Steps
4 Finding the top or lowest values with the Find Assistant=[e-mail]>Steps
4 Sorting fields with the Find Assistant=[e-mail]>Steps
3 Find Records Using Query by Box
4 Finding records using Query by Box=[e-mail]>Steps
4 Overview: Defining find conditions graphically in Query by Box=[e-mail]>Overview
4 Overview: Multiple find conditions in Query by Box=[e-mail]>Overview
3 Find Records Using a Blank View
4 Creating find requests=[e-mail]>Steps
4 Finding records that satisfy multiple conditions (AND)=H_FINDING_RECORDS_THAT_SATISFY_MULTIPLE_CONDITIONS_(AND)[e-mail]>Steps
4 Finding records that satisfy at least one of several conditions (OR)=H_FIND_RECORDS_TO_SATISFY_ONE_OF_SEVERAL_CONDITIONS_(OR)[e-mail]>Steps
4 Finding records with OR conditions in more than one field=H[e-mail]>Steps
4 Finding text with wildcards=[e-mail]>Steps
4 Finding case-sensitive text=[e-mail]>Steps
4 Finding a word that sounds like another=[e-mail]>Steps
4 Finding numbers, dates, and times=[e-mail]>Steps
4 Finding values in a range=[e-mail]>Steps
4 Finding today's date=[e-mail]>Steps
4 Finding radio button and check box settings=[e-mail]>Steps
4 Finding blank or nonblank fields=[e-mail]>Steps
4 Using If statements to find data=[e-mail]>Steps
4 Repeating finds=[e-mail]>Steps
3 Create Named Finds
4 Naming finds with the Find Assistant=[e-mail]>Steps
4 Naming and reviewing finds with the Find Assistant=[e-mail]>Overview
4 Naming finds based on find requests=[e-mail]>Steps
4 Editing named finds=[e-mail]>Steps
4 Copying named finds=[e-mail]>Steps
4 Deleting named finds=[e-mail]>Steps
4 Running named finds=[e-mail]>Steps
3 Create Query Files
4 Creating query files in Approach=[e-mail]>Steps
4 Opening query files in Approach=[e-mail]>Steps
4 Saving or exporting data from a query=[e-mail]>Steps
3 Create an SQL SELECT Statement with the SQL Assistant
4 Overview: Connecting to an SQL or ODBC data source=[e-mail]>Overview
4 Selecting tables for an SQL SELECT statement=[e-mail]>Steps
4 Creating joins for an SQL SELECT statement=[e-mail]>Steps
4 Creating find conditions for an SQL SELECT statement=[e-mail]>Steps
4 Selecting fields for an SQL SELECT statement=[e-mail]>Steps
4 Sorting fields for an SQL SELECT statement=[e-mail]>Steps
4 Editing SQL statements=[e-mail]>Steps
2 Sort Records
3 Specifying a sort order=[e-mail]>Steps
3 Sorting records by a field in a view (Ascending)=[e-mail]>Steps
3 Sorting records by a field in a view (Descending)=[e-mail]>Steps
3 Setting a default sort order for looking at records in Browse=[e-mail]>Steps
3 Setting a default sort order for a repeating panel=[e-mail]>Steps
2 Share Work Within Groups Using TeamMail
3 Sending e-mail messages from inside Approach=[e-mail]>Steps
3 Sending e-mail messages with attachments from inside Approach=H_SE[e-mail]>Steps
:include TM1N10EN.CNT
2 Share Data with Other Applications
3 Import Data
4 Importing data into databases=[e-mail]>Steps
4 Opening databases created in other applications=[e-mail]>Steps
4 Creating databases from spreadsheets=[e-mail]>Steps
4 Creating databases from delimited text files=[e-mail]>Steps
4 Creating databases from fixed-length text files=[e-mail]>Steps
4 Importing Approach files=[e-mail]>Steps
4 Mapping fields=[e-mail]>Overview
4 Pasting pictures in fields=[e-mail]>Steps
3 Export Data
4 Exporting data from Approach=[e-mail]>Steps
4 Copying PicturePlus pictures to a file=[e-mail]>Steps
3 Link and Embed Objects (OLE)
4 Overview: Communicating between applications using OLE=[e-mail]>Overview
4 Overview: OLE links=[e-mail]>Overview
4 Overview: OLE embedded objects=[e-mail]>Overview
4 Overview: Embedding an Approach object in another application=[e-mail]>Overview
4 Creating Approach OLE objects in Approach (Copy View)=[e-mail]>Steps
4 Creating Approach OLE objects from other applications=[e-mail]>Steps
4 Creating linked objects from files=[e-mail]>Steps
4 Inserting linked objects from the Clipboard=[e-mail]>Steps
4 Editing linked objects=[e-mail]>Steps
4 Modifying links=[e-mail]>Steps
4 Embedding OLE objects based on existing files=[e-mail]>Steps
4 Embedding new OLE objects=[e-mail]>Steps
4 Editing embedded objects=[e-mail]>Steps
3 Work with Custom Controls (OCX)
4 Overview: OLE Custom Controls=[e-mail]>Overview
4 Registering custom controls=[e-mail]>Steps
4 Inserting custom controls in views=[e-mail]>Steps
4 Changing properties of custom controls=[e-mail]>Steps
4 Adding custom controls to the Tools palette=[e-mail]>Steps
2 Share Data on a Network
3 Setting file-sharing options for dBASE files=[e-mail]>Steps
3 Specifying locking protocols for shared dBASE files=[e-mail]>Steps
3 Setting file-sharing options for Paradox files=[e-mail]>Steps
3 Changing the status to single-user=[e-mail]>Steps
3 Entering passwords=[e-mail]>Steps
3 Refreshing the data network onscreen=[e-mail]>Steps
3 Saving changes to shared records=[e-mail]>Steps
2 Customize Approach
3 Set Approach Preferences
4 Setting display preferences for the Approach window=[e-mail]>Overview
4 Showing summaries in reports=[e-mail]>Overview
4 Setting preferences for the Design environment=[e-mail]>Overview
4 Adding custom controls to the Tools palette=[e-mail]>Steps
4 Setting a default sort order for looking at records in Browse=[e-mail]>Steps
4 Defining passwords for a database=[e-mail]>Steps
4 Identifying default directories=[e-mail]>Steps
4 Displaying the contents of drop-down boxes automatically=[e-mail]>Steps
4 Moving between fields using ENTER=[e-mail]>Steps
4 Showing the Add Field dialog box after creating new fields=H_[e-mail]>Steps
4 Showing the Cancel Macro dialog box while running macros=[e-mail]>Steps
4 Making calculated fields available for joins=[e-mail]>Steps
4 Entering data using optimistic record locking=[e-mail]>Steps
4 Downloading data before previewing=[e-mail]>Steps
4 Setting dialing preferences=[e-mail]>Overview
4 Setting preferences for database files=[e-mail]>Overview
4 Maintaining external indexes for dBASE or FoxPro databases=H_[e-mail]>Steps
4 Closing external indexes for dBASE or FoxPro databases=[e-mail]>Steps
4 Creating secondary indexes for Paradox databases=[e-mail]>Steps
4 Deleting secondary indexes for Paradox databases=[e-mail]>Steps
3 Customize Menus
4 Custom menus=[e-mail]>Overview
4 Creating custom menus=[e-mail]>Steps
4 Creating a custom menu by copying one that exists=[e-mail]>Steps
4 Editing custom menus=[e-mail]>Steps
4 Moving and deleting commands on custom menus=[e-mail]>Steps
4 Deleting custom menus=[e-mail]>Steps
1 Demo Catalog
2 Using demos=[e-mail]>Overview
1 Tools for Getting Your Work Done
2 Installing additional language versions of Approach=[e-mail]>Overview
2 Keyboard Information
3 Moving between fields=[e-mail]>Overview
3 Keyboard shortcuts=[e-mail]>Overview
3 Moving within fields=[e-mail]>Overview
3 Selecting within fields=[e-mail]>Overview
2 Menus
3 Shortcut menus=[e-mail]>Steps
3 File menu=[e-mail]>Overview
3 Edit menu=[e-mail]>Overview
3 View menu=[e-mail]>Overview
3 Create menu=[e-mail]>Overview
3 Window menu=[e-mail]>Overview
3 Help menu=[e-mail]>Overview
3 Context Menus
4 Browse menu=[e-mail]>Overview
4 Chart menu=[e-mail]>Overview
4 Column menu=[e-mail]>Overview
4 Crosstab menu=[e-mail]>Overview
4 Envelope menu=[e-mail]>Overview
4 Form menu=[e-mail]>Overview
4 Form Letter menu=[e-mail]>Overview
4 Mailing Label menu=[e-mail]>Overview
4 Object menu=[e-mail]>Overview
4 Report menu=[e-mail]>Overview
4 Text menu=[e-mail]>Overview
4 Worksheet menu=[e-mail]>Overview
2 SmartIcons
3 Overview: SmartIcons=[e-mail]>Overview
3 Overview: Using SmartIcons=[e-mail]>Overview
3 Using an icon=[e-mail]>Steps
3 Modifying a Set of SmartIcons
4 Adding an icon to a set of SmartIcons=[e-mail]>Steps
4 Removing an icon from a set of SmartIcons=[e-mail]>Steps
4 Sizing icons in a SmartIcons set=[e-mail]>Steps
4 Spacing between SmartIcons in a set=[e-mail]>Steps
4 Creating a new SmartIcons set=[e-mail]>Steps
4 Deleting a SmartIcons set=[e-mail]>Steps
4 Displaying or hiding SmartIcons bubble help=[e-mail]>Steps
3 SmartIcons in the Work Area
4 Overview: Placing SmartIcons in the work area=[e-mail]>Overview
4 Placing a set of SmartIcons using the mouse=[e-mail]>Steps
4 Selecting and displaying a specific icon set=[e-mail]>Steps
4 Displaying or hiding SmartIcons=[e-mail]>Steps
4 Hiding SmartIcons using the bar button=[e-mail]>Steps
4 Moving an icon using the mouse=[e-mail]>Steps
4 Selecting a SmartIcons set using the bar button=[e-mail]>Steps
4 Setting location preferences for context SmartIcons=[e-mail]>Steps
2 Functions
3 List of functions=[e-mail]>Overview
3 Overview: Functions=[e-mail]>Overview
3 Overview: Formulas=[e-mail]>Overview
3 Overview: Field references, constants, and operators=[e-mail]>Overview
3 Date and time constants=[e-mail]>Overview
2 Macros
3 List of macro commands=[e-mail]>Overview
3 Overview: Macros=[e-mail]>Overview
3 Define Macro dialog box=H_DEFINE_MACRO_DIALOG_BOX_REF>Overview
3 Printing macros=H_PRINTING_MACRO_COMMANDS_STEPS>Steps
3 Running script functions with a macro=H_RUNNING_SCRIPT_FUNCTIONS_WITH_A_MACRO_STEPS>Steps
3 Write Macros
4 Creating new macros=[e-mail]>Steps
4 Creating macros based on existing macros=H_CREATING_MACROS_BASED_ON_EXISTING_MACROS_STEPS>Steps
4 Editing macros=[e-mail]>Steps
4 Deleting macros=[e-mail]>Steps
4 Attaching macros=[e-mail]>Steps
4 Adding macros to the Run Macro menu=[e-mail]>Steps
3 Use Macros: Suggestions for Use
4 Creating looping macros=[e-mail]>Steps
4 Defining a conditional macro=[e-mail]>Steps
4 Running macros from buttons in a message box=H_RUNNING_MACROS_FROM_BUTTONS_IN_A_MESSAGE_BOX_STEPS>Steps
4 Setting a value in a field with a macro=[e-mail]>Steps
4 Switching to another view with a macro=[e-mail]>Steps
2 File Types
3 File extensions in Approach=[e-mail]>Overview
3 dBASE files in Approach=[e-mail]>Overview
3 FoxPro files in Approach=[e-mail]>Overview
3 IBM DB2 tables in Approach=[e-mail]>Overview
3 ODBC data sources in Approach=[e-mail]>Overview
3 Oracle SQL tables in Approach=[e-mail]>Overview
3 Paradox files in Approach=[e-mail]>Overview
3 Query files in Approach=[e-mail]>Overview
3 SQL Server tables in Approach=[e-mail]>Overview
3 Troubleshooting Sybase SQL Server=[e-mail]>Overview
1 Did You Know. . .
2 Browse is for data, Design is for style=[e-mail]>Overview
2 Approach saves data automatically=[e-mail]>Overview
2 A sort is not a find=[e-mail]>Overview
2 Select Print Preview to see report summaries=[e-mail]>Overview
1 LotusScript
:include LSEN30EN.CNT
:include LSLN30EN.CNT
:include LASN40EN.CNT
:include FL2C10EN.CNT
:include WP0N70EN.CNT
1 What's New for Upgraders
2 What's new in Approach 96=[e-mail]>Overview
2 Installing additional language versions of Approach=[e-mail]>Overview
1 Using Applications Together
2 Share Work Within Groups Using TeamMail
3 Sending e-mail messages from inside Approach=[e-mail]>Steps
3 Sending e-mail messages with attachments from inside Approach=H_SE[e-mail]>Steps
:include TM1N10EN.CNT
2 Working Together with Lotus Notes
3 Opening views or forms from a local Notes database=H_OPEN[e-mail]>Steps
3 Opening views or forms from a Notes database on a server=H_OPENING_LO[e-mail]>Steps
3 Replicating a Notes database=[e-mail]>Steps
3 Replicating Notes databases with a server=[e-mail]>Steps
3 Notes/FX
4 Enabling variable fields for Notes/FX=[e-mail]>Steps
4 Overview: Exchanging data between Approach and Notes=[e-mail]>Overview
4 Overview: Setting up Notes/FX=[e-mail]>Overview
4 Setting up fields for two-way exchange with Notes=[e-mail]>Steps
4 Adding Notes/FX fields to a Notes form=[e-mail]>Steps
4 Embedding an Approach object in a Notes document=[e-mail]>Steps
4 Embedding an Approach object in a Notes form=[e-mail]>Steps
4 Creating a new Notes document=[e-mail]>Steps
4 Updating fields in a Notes document from Approach=[e-mail]>Steps
4 Updating information in Approach from a Notes document=[e-mail]>Steps
2 Working Together with Lotus 1-2-3
3 Opening named ranges from Lotus 1-2-3 spreadsheets=[e-mail]>Steps
3 Creating Approach views in Lotus 1-2-3=[e-mail]>Steps
3 Creating databases from spreadsheets=[e-mail]>Steps
1 Troubleshooting
2 Contacting customer support=[e-mail]>Big
2 Messages
3 Common messages=[e-mail]>Overview
2 Did You Know. . .
3 Browse is for data, Design is for style=[e-mail]>Overview
3 Approach saves data automatically=[e-mail]>Overview
3 A sort is not a find=[e-mail]>Overview
3 Select Print Preview to see report summaries=[e-mail]>Overview