Locking Row and Column Titles in Excel
Quick Sum or Average in Excel
Access Creating a Form
Create a new form.
To create a new form, click on NEW. In the next
window, click on DESIGN VIEW. Then choose the table that you want your
information to come from. Then click on OK.
What you get next, is a small gray area with a grid
of black dots on it. This is the start of your form. If you wish to see
what your new form looks like, from the top menu, choose VIEW then FORM
VIEW. You will then see your form you can watch each of your changes
as you make them. To get back to the design screen, from the top menu,
choose VIEW then DESIGN VIEW.
Right click on the bar entitled DETAIL and choose
PROPERTIES. This opens a window that allow you to set the background color
of your form. Click on the FORMAT tab and look for BACK COLOR. When you
click in this field, you will see a button to the right that has three
dots on it. Click on the button and choose the color you want then click
on OK.
Now, lets add our fields to the form. From the top
menu, choose VIEW FIELD LIST. This places a small window near the top
that shows all of the fields from your table. Click on a field name that
you wish placed on your form and drag it to the area on the form where
you wish it. Do this for all of the fields that you want on the form.
Notice that when you add these fields, you see the
name of the field twice once as a label and once as the area where you
enter the data. Lets remove the label to all of these. Left click on the
first label then as you hold the SHIFT key down, left click on the rest
of the labels. Then from the keyboard, press the DELETE key. All of the
labels should disappear.
Click on the first field and you will see the
handles where you can adjust the size of the box. Adjust this box to the
height that you wish all of your boxes to be. Then while holding down the
SHIFT key, left click on the rest of the fields. Now using your right mouse
button, right click on one of the fields from the menu, choose SIZE
TO TALLEST. This will make all of the boxes the same height. While they
are all still highlighted, set the font, font size and justification from
the menu.
To add a title to this form (or add any additional
text), from the top menu, choose VIEW TOOLBOX. This opens up a small
window of tools. Click on the label tool (Aa) and notice that your cursor
changes to a capital A with a plus sign. By holding the left mouse button
down, you can draw a box where you wish to place your text. Type your text
in and then make any adjustments to it for font style, font size, color,
etc.
If you wish to add a picture to your form, click
on the IMAGE tool. Choose a picture from your hard drive.
When you are through designing your form, click
on the X to close the window. You will be ask if you wish to save your
changes. Choose YES and then give your form a name.
How Do I Clean My Scanner Glass (and other questions)
IBM Aptiva Booting when the Telephone Rings
We also found the following -----
QUESTION: Can you explain what the Aptiva Wake up
on Ring is used for?
ANSWER: Wake Up on Ring is a Rapid Resume feature.
When you enable it, the computer will turn on when the phone rings (assuming
you have the telephone line connected to the computer). If you have fax
or fax/voice software open, the computer can receive faxes or messages
after it turns on. If the computer is off at that time, it will turn on
automatically. The Aptiva systems will answer the telephone from each of
the following states:
1.Powered on
2.Standby
3.Suspend (Rapid Resume enabled, power off)
4.Powered off (Rapid Resume disabled)
For the first three, the telephone answering software
(ex: Faxworks, Aptiva Communication Center) must be running (when the system
goes into that state) in order for the telephone to be answered. For the
powered off state (RR disabled), the system will turn on if wake-up-on-ring
is enabled; however, to answer the phone, the Operating System's StartUp
Group needs to be setup to run the software (FaxWorks, Aptiva Communications
Center) After the phone has been answered and the FAX or message received,
the system will return to its previous state: If standby is enabled, the
system enters standby after the time period set by the user (15-90 minutes).
If auto-power off is enabled, the system will power down after the time
period set by the user (15-90 minutes). If Rapid Resume is enabled when
the system powers down, then the state will be saved and the
system will go back to the suspend mode.
We also found that you can put your computer into
hiberation. The hibernate feature turns off your monitor and hard disk,
saves everything in memory on disk, and turns off your computer. When you
restart your computer, your desktop is restored exactly as you left it.
It takes longer to bring your computer out of hibernation than out of standby.
Since it did not state where to find the control
that turns this Wake Up On Ring on or off, this is my guess. From MY COMPUTER
choose CONTROL PANEL then POWER MANAGEMENT.
Internet Phone Calls
Printing Handouts of your PowerPoint Presentation
Storage Requirements
(in kilobytes)
|
|
|
|
|
|
|
|
|
8.5" x 11" 8.5" x 5.5" 5" x 7" 4" x 5" 3" x 5" |
- - 65 33 25 14 11 |
- - 257 130 97 55 42 |
- - 1,028 514 385 220 165 |
- - 4,109 2,055 1,540 880 660 |
- - 16,435 8,218 6,153 3,516 2,637 |
- - 65,742 32,872 24,010 14,063 10,547 |
|
8.5" x 11"
|
- 514 257 193 110 83 |
- 2,055 1,028 770 440 330 |
- 8,218 4,109 3,077 1,758 1,319 |
- 32,872 16,436 12,305 7,032 5,274 |
- 131,484 65,743 49,219 28,125 21,095 |
- 825,938 262,969 196,875 112,500 84,375 |
|
8.5" x 11"
|
- 1,541 771 577 330 248 |
- 6,164 3,082 2,308 1,319 989 |
- 24,654 12,327 9,229 5,274 3,955 |
- 98,614 49,307 36,915 21,094 15,820 |
- 394,453 197,227 147,657 84,375 63,282 |
- 1,577,813 788,907 590,625 337,500 253,125 |
|
8.5" x 11"
|
- 2,311 1,156 865 495 371 |
- 9,245 4,623 3,461 1,978 1,484 |
- 36,980 18,490 13,843 7,910 5,933 |
- 147,920 73,960 55,371 31,641 23,731 |
- 591,680 295,840 221,485 126,563 94,922 |
- 2,366,719 1,183,360 885,938 506,250 379,688 |