Create a question-and-answer form using hidden text (Word
97-2000-2001-2002)!
When you create quizzes, tests, and other types of Q&A forms,
you'll often want to create an answer key that you can use to
correct it. Instead of saving a test and its answer key as two
separate files, or manually deleting the answers so you can print
a clean test, you can kill two birds with one stone by putting
hidden text to the task. By applying the hidden-text format to
each answer, you can easily hide and display them at will. To
apply the hidden-text format,select the text you'd like to hide,
and then choose Format | Font from the menu bar, or press [Ctrl]D
([command]D in Word 2001). In the Font dialog box, click on the
Font tab, select the Hidden check box in the Effects panel, and
then click OK. When you return to your document, Word
automatically hides the selected text from view. However, you can
toggle its onscreen display by clicking the Show/Hide button on
the Standard toolbar. When hidden text is in view, it's
accompanied by a dotted underline.
Keep in mind that by default, Word doesn't print hidden text.
However, you can print your answer key by enabling hidden text
printing. To do so, choose File | Print from the menu bar, then
click the Options button to access the Print property sheet.
(Note: You can also access this property sheet by choosing Tools |
Options from the menu bar (Edit | Preferences in Word 2001) and
clicking on the Print tab.) Select the Hidden Text check box, and
then click OK. Specify any additional printing options as desired,
and then click OK to print the document and its hidden text.
(Note: After you enable hidden-text printing, it remains enabled
until you disable it.)
Teach them to create a custom list in Excel 2000!
Here's another timesaving tip to pass on to your users. If your
users often make use of the same lists of data, you can teach them
to create a custom list instead of typing the same information
repeatedly.
If the data you want to copy is already in a worksheet, follow
these steps:
1. Select all of the cells containing the information you want to
copy.
2. Go to the Tools menu.
3. Select Options.
4. Click the Custom Lists tab.
5. Click Import.
If you want to create a list from scratch, follow these steps:
1. Go to the Tools menu.
2. Click Custom Lists.
3. Click in the List Entries box.
4. Type each item for your list, hitting [Enter] after each item.
5. When you're finished, click OK to create the list.
To use a custom list, type the first entry of the list. Use the
fill handle at the bottom right corner of the cell to drag the
whole list across adjacent cells.
Lookup lists can come in handy when using forms in Access 97,
2000, or 2002. !
However, when designing a form, you don't have access to the
Lookup Wizard as you do in tables. Forms have a list box and combo
box wizard that can help you create a list. A list box is a box
that lists the values and is open at all times. A combo box is a
drop-down list. The procedure to create either a list box or combo
box is basically the same as creating a lookup list in tables.
Although list boxes and combo boxes function in much the same way,
there's a major difference between the two: A combo box allows a
user to enter new values that aren't currently contained in the
list while a list box allows a user to choose only values that are
in the list.
In this tip I will briefly step you through the process of adding
a list box to a form.
1. Open your form in Design view and display the Toolbox if
necessary by choosing View | Toolbars | Toolbox from the menu bar
or by clicking the Toolbox button on the Form Design toolbar.
2. Make sure that the Control Wizards button is selected in the
Toolbox, and then click the List Box button.
3. Click and drag to place the list box on the form and to launch
the List Box Wizard. Follow the instructions in the List Box
Wizard in accordance with the knowledge you've gained from dealing
with the Lookup Wizard.
If you choose the I Will Type In The Values That I Want option,
the values you enter become a value list.
The third option available in the List Box Wizard, Find A Record
On My Form Based On The Value I Selected In My List Box, creates a
list box on your form that's used to find records. When a value is
selected in this type of list box, the data for that record
appears in the form
|
|