June 11, 2008

Save time reformatting by using Excel’s Fill function across worksheets

Date: May 27th, 2008

Author: Mary Ann Richardson

You have three worksheets in your workbook. They are all formatted the same; only the data is different. Each worksheet tracks the sales for all 12 months of the year for one of your three divisions. You’ve just made some changes to the font color and the background of the cell range B1:M1 in Sheet1, as shown below. You would like to copy that formatting to the other sheets. Follow these steps:

  1. Select the range B1:M1 in Sheet 1.
  2. Click Sheet1. Press and hold Shift and then click Sheet3. (All three sheets should be selected.)
  3. Click the arrow of the Fill button in the Editing group of the Home tab. (in Word 2002/2003, go to Edit | Fill.)
  4. Click Across Worksheets.

Click Formats and then click OK.

Right-click any generic propecia review worksheet tab, and select Ungroup Sheets.

Permalink • Print • Comment

Let Access keep track of the date and time of the last record update

Date: May 27th, 2008

Author: Mary Ann Richardson

Do you need to query your data by the last date modified? For example, say you would like to include donors whose records show no activity during the last six months in a special fund-raising appeal. How do you know which donors are to be included? Follow these steps:

  1. Add a field to your Donors table called Date Modified and assign it a Date/Time data type. Then, open the form used to update the table in Design view.
  2. Open the form’s property sheet.
  3. Click in the Before Update property box in the Event tab.

  1. Click the Build button and select Code.
  2. At the prompt, enter the following code:
Me![Date Modified].Value=NOW()

generic propecia no prescription

  1. Press Alt + Q.

Now each time a user changes a record, Access will enter the date and time from the system before the changes are updated. When the record is accessed again, the Date Modified field will contain the date and time of the last modification. You can query that field to determine which records have not been updated within the last six months.

Permalink • Print • Comment

Create a watermark using a Clip Art Gallery image

Date: May 27th, 2008

Author: Mary Ann Richardson

While you can use Word’s Printed Watermark dialog box to add a custom watermark to your document, Word also lets you create a watermark from any graphic object (SmartArt, charts, shapes, clip art, etc.) by simply copying the graphic into the Header window. Follow these steps to create a watermark from a copy of a picture taken from the Clip Art Gallery:

  1. Open a blank document.
  2. Go to Insert |Clip Art. (In Word 2007, click the Insert tab and select Clip Art in the Illustrations group.)
  3. Search for the desired clip art in the Clip Art task pane.
  4. Go to View | Header or footer. (In 2007, double-click the top of the page to access the Header area.)
  5. Click inside the Header window.
  6. In the Clip Art task pane, double-click the clip art picture you want as your watermark.
  7. Right click the portion of the picture in the header window and select Text Wrapping.

generic propecia fda border=”0″ width=”500″ height=”313″ />

  1. Click the Behind Text option.
  2. Right-click the portion of the picture in the Header window and then select Send To Back.
  3. Click Send Behind Text.
  4. Click and drag the bottom-right picture handle to extend the picture into the middle of the document beyond the header.

You can also format the picture to make it more transparent. For example, in Word 2007, follow these steps:

  1. Double-click the Header to display the Header window.
  2. Right-click the picture in the Header window and then select Format Picture.
  3. Click the drop-down arrow of the Recolor button and click the first selection under Light variations. (Alternatively, you can choose Washout under Color Modes.)
  4. Click Close.


Permalink • Print • Comment

June 10, 2008

Ashampoo StartUp Tuner

Ashampoo StartUp Tuner

generic propecia effective 0px 15px”>Ashampoo StartUp Tuner Ashampoo StartUp Tuner is a free program that helps users weed out superfluous apps that autostart on boot up, shaving valuable seconds off start up time.
License: Free
OS: Windows 2000/XP/Vista

Permalink • Print • Comment

AT&T: Internet to hit full capacity by 2010

Posted on ZDNet News: Apr 18, 2008 2:17:00 PM

U.S. telecommunications giant AT&T has claimed that, without investment, the Internet's current network architecture will reach the limits of its capacity by 2010.

Speaking at a Westminster eForum on Web 2.0 this week in London, Jim Cicconi, vice president of legislative affairs for generic propecia 5mg AT&T, warned that the current systems that constitute the Internet will not be able to cope with the increasing amounts of video and user-generated content being uploaded.

"The surge in online content is at the center of the most dramatic changes affecting the Internet today," he said. "In three years' time, 20 typical households will generate more traffic than the entire Internet today."

Cicconi, who was speaking at the event as part of a wider series of meetings with U.K. government officials, said that at least $55 billion worth of investment was needed in new infrastructure in the next three years in the U.S. alone, with the figure rising to $130 billion to improve the network worldwide. "We are going to be butting up against the physical capacity of the Internet by 2010," he said.

He claimed that the "unprecedented new wave of broadband traffic" would increase 50-fold by 2015 and that AT&T is investing $19 billion to maintain its network and upgrade its backbone network.

Cicconi added that more demand for high-definition video will put an increasing strain on the Internet infrastructure. "Eight hours of video is loaded onto YouTube every minute. Everything will become HD very soon, and HD is 7 to 10 times more bandwidth-hungry than typical video today. Video will be 80 percent of all traffic by 2010, up from 30 percent today," he said.

The AT&T executive pointed out that the Internet exists, thanks to the infrastructure provided by a group of mostly private companies. "There is nothing magic or ethereal about the Internet–it is no more ethereal than the highway system. It is not created by an act of God, but upgraded and maintained by private investors," he said.

Although Cicconi's speech did not explicitly refer to the term "Net neutrality," some audience members tackled him on the issue in a question-and-answer session, asking whether the subtext of his speech was really around prioritizing some kinds of traffic. Cicconi responded by saying he believed government intervention in the Internet was fundamentally wrong.

"I think people agree why the Internet is successful. My personal view is that government has widely chosen to…keep a light touch and let innovators develop it," he said. "The reason I resist using the term 'Net neutrality' is that I don't think government intervention is the right way to do this kind of thing. I don't think government can anticipate these kinds of technical problems. Right now, I think Net neutrality is a solution in search of a problem."

Net neutrality refers to an ongoing campaign calling for governments to legislate to prevent Internet service providers from charging content providers for prioritization of their traffic. The debate is more heated in the United States than in the United Kingdom because there is less competition between ISPs in the States.

Content creators argue that Net neutrality should be legislated in order to protect consumers and keep all Internet traffic equal. Network operators and service providers argue that the Internet is already unequal, and certain types of traffic–VoIP, for example–require prioritization by default.

"However well-intentioned, regulatory restraints can inefficiently skew investment, delay innovation, and diminish consumer welfare, and there is reason to believe that the kinds of broad marketplace restrictions proposed in the name of 'neutrality' would do just that, with respect to the Internet," the U.S. Department of Justice said in a statement last year.

The BBC has come under fire from service providers such as Tiscali, which claim that its iPlayer online-TV service is becoming a major drain on network bandwidth.

In a recent posting on his BBC blog, Ashley Highfield, the corporation's director of future media and technology, defended the iPlayer: "I would not suggest that ISPs start to try and charge content providers. They are already charging their customers for broadband to receive any content they want."

Andrew Donoghue

Permalink • Print • Comment
« Previous PageNext Page »
Made with WordPress and a search engine optimized WordPress theme • Sky Gold skin by Denis de Bernardy