D |
• Q&A in the law office (database for
litigation and document control, deposition summaries, etc.) • Payroll with Q&A, part 2 • Removing password protection from a database • DADA 9240 System error message and what to do about it • Two ways to use Q&A on a network (advantage of each user having own copy of Q&A) • How the "Print Expanded Fields" option on the Print Options screen works • Automating weighted grade calculations (gradebook database for teachers) • Retrieving information fast (shortcuts for narrowing search criteria) • Changing the Intelligent Assistant's name on the Main menu • A report derived column that places the street number in column 1 and the street name in column 2 |
| N o v 91 |
• Payroll with Q&A, part 1 • Q&A User Group on Prodigy • Protecting Q&A 4.0 Under Deskview • Retrieve Spec formulas (many examples of using programming expressions to retrieve records) • Protecting directories and document files (preventing directories from being inadvertently deleted) • Fax merging Q&A with an Intel Connection CoProcessor or SatisFAXtion board • Designing daily "tickler files" or "to-do" lists • Isolating and processing memo field entries (marking special text blocks in an expanded field) • Importing a WordPerfect 5.0 and 5.1 secondary (data) merge file • A Print Spec that prints the field labels in bold • Adding a space between the street number and name in an imported file • Using the Postfile command in Write to add your graphic signature to a document • Correcting Page Preview problems |
| O c t 91 |
• Posting tips and solving multiple
posting problems • Simulating a "contains" operator (retrieving records containing a specified string in a field) • Using "Define Page for Imported Documents" feature • Custom menu basics (how to create custom menus plus some tricks) • Show more function key assignments on screen • Using Q&A with full-blown accounting packages • When your report's column headings aren't the field names they should be • A Retrieve Spec program to update an inventory database from an invoice database • Printing multi-column reports in Write • Setting "video on" (vidon) and "video off" (vidoff) anywhere in a macro • Review of "JustWrite" - a Symantec Q&A-compatible Windows word processor • How to force a day of the month in date calculations • Problem with XLookups on a two-computer network • Using Q&A as a textbase for research projects (storing research notes) • Why you should explicitly type the name of the item being selected by a macro |
| S e p 91 |
• Pop up lists of Restricted Values from
external files • Using the power of the Field Editor for fast access to all kinds of external file data (pick lists) • Limiting Execute statements to one-time only • Sensible filename extension naming • Fix report column spacing problems after upgrading • Simulating an @Count function in programming • Retrieving multiple values in Keyword fields • Using your mouse with Q&A • Splitting a multi-line address into two single-line fields • Batch Posting - an overview |
| A u g 91 |
• Displaying permitted field values for
fast and accurate data entry • Printing birthday reminder lists by month • Creating a database that works like a spreadsheet • Financial calculator database assists with long- and short-term investments • Include only the last filled "Comments" field in a report • Printing a hard copy of a complete database program • Maintaining physical inventory: a case study (tips and tricks to make physical inventory easier) • Printing on legal paper on the LaserJet • Including the filename in a printed report |
| J u l 91 |
• Handy financial calculator is fast and
flexible • Invoice search options and target mailings • Automatically updating the average cost of stock items from information in purchase orders • Printing thick black lines in Write • Searching for a literal "Min" in a value (such as a product code like "MIN023") • Using Write to remove report column headings • Determining the days of the week during a given time period • How to sort deeper to ensure retrieval consistency (such as records to include in a mail merge) • Printing portions of reports from screen • Reclaiming hard disk space with databases and documents • Filling in two keyword fields simultaneously from a lookup table • Using a pre-defined hot-key to execute the programming in a record and display the next record • Increasing a person's age by one year at the six-month point, and showing the date of the next increase • A report that shows if a field in Database A has a matching field in Database B • Unteaching the Intelligent Assistant to make a database more nimble |
| J u n 91 |
Q&A 4.0 Begins Shipping • Comprehensive review of the new Q&A 4.0 (entire issue devoted to it) |
| M a y 91 |
• Grouping ZIP Codes for bulk mail
discounts • When you receive a "Report Too Wide" message • Tricks with summary reports (printing multiple reports on one page, improving look, using JOIN command) • Using Q&A's built-in financial functions • Checking computed duplicate field values • Formatting QASPEC output (printing programming statements) • Searching across multiple fields for the occurrence of a value • When there's no more room in your lookup table (using a database instead) • How to triple-space a report • Using the literal "#" symbol in a report page header (for example, "Page \##" yields "Page #1") • How to print more fields on a line than can show on screen • Printing only the first three screens of a five-screen database record • Getting year-end totals for each "crime class" in a police incident database • Nesting field labels in document JOIN commands • Using @XLookup on a peer-to-peer network |
| A p r 91 |
• Tracking the future with a personal
budget database (also monthly expense and finance reports) • How to perform a conditional IF statement in a derived column • Programming Q&A for area code changes • Retrieving records where one field has a specific relation to another • Storing a sequence of actions in multiple fields • Tricks for creating weekly reports • Forcing a check for a duplicate field value • Create a clock calendar display database • What happens to Sharing Mode when you copy a database design • Adding comments to macro files • Using Q&A's built-in text and string functions (a variety of examples) • Printing Write documents in two-column format • Retrieving the right customer information the first time (such as if you don't know the customer's ID No,) • How to double-space line draw when printing a Write merge document |
| M a r 91 |
• Using Q&A to help prepare bulk
mailings • Q&A's built-in date and time functions • Sort a report by birthdate • Finding the most recent date from several date fields • Using text / string functions to break down dates • Calculating elapsed time • Using XLookup(@Filename) on a peer-to-peer network • Handling a "000" file error • Tailor your Q&A sessions with batch files • Using XLookup and @XLookup on networks • Protecting your data (how to check for possible database corruption before it causes problems) • How to find a customer's account number without interrupting data entry • Updating a field based on the updated value in a previous field • When it takes too long to add a record to a database • Fixing a document file with a space in the filename • Create a phone contact and memo application • Using a special XLookup syntax to avoid IF-THENs • How to ensure field values aren't unique • Multi-tasking with Q&A • More uses for the "]" (non-standard value) search character • Solving too may serial devices problem |
| F e b 91 |
• How to update inventory records from
invoices (automated procedure for Q&A 3.0) • How to suppress duplicate fields in a database when mail merging • Setting page margins in inches when using proportional fonts • Printing a snaking column report (like a phone book) • Using macros in Write to fill in a questionnaire • Streamlining forms and questionnaires • Totaling a column of numbers in Write • Q&A utility finds and removes duplicate records • How to place warning screens within macros • Generating accurate counts in reports • How to use the Lookup and XLookup commands (the basics - comprehensive) • Getting a count of Keyword field entries |
| J a n 91 |
• Create billing statements using the
Report module • Duplicating data on long forms • Controlling access to your database • Programming logarithmic transformations • Using Q&A's "sounds like" ( ~ ) feature • Isolating weekend dates • Sorting and printing oddly-named quarters of the year • Troubleshooting mail merge, part 2 • Using Keyword fields to plan meeting sessions • Restricting input and adding custom help (summary of available restrictions plus programming them) • Why a Sort Spec is crucial when merge printing • Using ELSE IF for ranges and "all others" • Using Sideways to print a report sideways |