Data Management

Tech Tip: Match Word bullets to text/Excel value thresholds/Hide Access database window

Word: Match bullets and numbers to the rest of the text

When working with bulleted or numbered text, you might find that the numeral or bullet font format doesn't match the format of the rest of the text.

For example, in a document that contains numbered text, you might find that when you change the format of a page or section within the document, the numbers retain the old format although the text assumes the new one.

If this happens in your document, follow these steps to make the numbers or bullets match the text format:

  1. Select the numbered or bulleted text.
  2. Go to Format | Bullets And Numbering.
  3. In the Bullets And Numbering dialog box, click Customize.
  4. In the Customize dialog box, click the Font button, and make the necessary changes so the font will match the text.
  5. Click OK to return to the Customize dialog box, and click OK again to close the dialog box.

Your numbers and bullets should now match the surrounding text.

Excel: Point to value thresholds in a cell

You can use conditional formatting to alert you to significant changes in cell values. For example, in a worksheet that tracks students' grades, conditional formatting can draw attention to quiz averages that have fallen below a passing grade of 60 percent.

To apply conditional formatting so average values below 60 percent are displayed in red, follow these steps:

  1. Select the cells you want to format.
  2. Go to Format | Conditional Formatting.
  3. Under Condition, choose Cell Value Is.
  4. Select Less Than from the first drop-down list, and enter 60% in the text box.
  5. Click Format and change the font color to red.
  6. Click OK twice.

When you return to the spreadsheet, all averages below 60 percent will be displayed in red. As future grades are entered, the format of the cells with the students' average grade will change accordingly. You can apply other conditional formatting rules by clicking Add in the Conditional Formatting dialog box.

Access: Hide the database window from a form user

While it may be necessary for users to have access to a database form, it may not be necessary—or even desirable—for them to have access to the entire database.

Follow these steps to hide the rest of the database from form users:

  1. Open the form in Design view.
  2. Go to Tools | Startup.
  3. Under Display Form/Page, select the form that will be displayed upon opening the database.
  4. Deselect the Display Database Window check box.
  5. Click OK.

The next time the database is opened, only the selected form is displayed. However, users can still access the database Window by either pressing [F11] or selecting the database from the most recently accessed databases listed in the File menu.

To prevent users from accessing the database via [F11], deselect the Use Access Special Keys check box in the Startup dialog box. Create a custom menu to prevent user access to the database from the File menu.

Editor's Picks

Free Newsletters, In your Inbox