Software

Tech Tip: Word page orientation/Check Excel numbers in text/Search empty Access fields

Word: Change page orientation mid-document

Let's say you have a chart or table that you want to include in a document, but it's too wide to print across a standard sheet of paper. Using Word's Page Setup menu, you can print a chart or table horizontally across a page while printing the rest of the document vertically.

Follow these steps:

  1. Move the cursor to the line above the chart or table.
  2. Go to File | Page Setup.
  3. On the Margins tab, select Landscape under the Orientation section.
  4. In the Preview section, select This Point Forward from the Apply To drop-down list, and click OK.

The rest of the document will now print in Landscape mode. To resume printing the pages vertically, follow these steps:

  1. Move the cursor to the line below the chart or table.
  2. Go to File | Page Setup.
  3. On the Margins tab, select Portrait under the Orientation section.
  4. In the Preview section, select This Point Forward from the Apply To drop-down list, and click OK.

Use this method to apply any changes you make in the Page Setup dialog box to any section of your document.

Excel: Check for numbers stored in a text format

Excel can't perform calculations on cell values formatted as text, such as number values that you've imported as text from other databases into Excel. Excel 2002 includes a feature that alerts you to these cells and optionally converts them to numbers.

To activate this feature, follow these steps:

  1. Go to Tools | Options.
  2. On the Error Checking tab, select the Enable Background Error Checking and Number Stored As Text check boxes, and click OK.

Now, when Excel finds a number in a cell formatted as text, it will place a green error indicator in the upper left corner of the cell. To convert cells to a number format, select the cell, click the Error Checking Options button displayed to the left of it, and select Convert To Number.

Access: Search for fields with no data

It's not uncommon for a field to have no data. A user may have skipped the field or left it blank because there was no value for the field at the record's time of entry. For example, phone numbers may be missing for some customers in your Customer table.

To find all customers whose phone number field contains no data, follow these steps:

  1. Create a query using the Customer table.
  2. Select the Name and Phone Number fields from the Customer table for the query.
  3. Enter Null in the Criteria cell of the Phone Number field. (Access automatically replaces the entry with Is Null.)

When you run the query, the results will list all customers whose phone numbers are missing.

But suppose your salespeople need a list of all customers they can call for a special promotion. To create a list of all customers with phone numbers, follow the same steps.

But this time, enter Not Null in the Criteria cell. Access automatically replaces the entry with Is Not Null, and the query results will list all customers whose phone number fields are not blank.

Editor's Picks

Free Newsletters, In your Inbox