|
Office XP Tips
|
|
Access Your PC from Anywhere Free Trial 2x faster!
Home Bookmark us now Windows XP Stuff Windows XP Tips, Page 2, Page 3, Page 4 Windows 7 Tweaks Windows Vista Windows XP Tweaks FAQ, Networking, SP1, XP SP2, Starter Edition, Firewalls, Themes, Wallpapers, Screensavers, Skins, Visual Tools, Drivers, Software, Media Center Edition, Start Buttons, Start Menu, Explorer, Password Recovery, Web Buttons, Tablet Edition, Professional, Home, Plus, Downloads, Activation, Update, Icons, Training Windows XP for Newbies Keylogger HP Coupons Sony Coupons Dell Coupons Tigerdirect Coupons Winbackup 2.0 Standard Review Learn Windows XP Computer Hardware Discount Computers Refurbished Notebook Computers Computer Parts Sony Vaio Laptop Online Accredited Degrees Masters Degree Online Online College Degrees Windows Desktop Themes Taskbar Repair Tool Email Saver XE Auto Pilot for Windows XP VPN Solutions Dell Computers Overstock Computers Overstock Coupons Overstock Software Computer Monitors Laptop Batteries Laptop Computers Computer Sales Video Tutorials Protect your iPhone 3G from Scratches Computer Memory Spyware Remover Jump Drives Pen Drive Camera Mini Digital Cameras Apple Computers Apple iPod PC Remote Control Memory Upgrades Computer Case Mods ATX Cases Barebone Systems Computer Desks Sony Vaio Computers Stop Spam Screensavers Hard Drive Tools Windows Resource Management Windows Reinstall Customize Windows XP DVD X Copy Data Recovery Office File Fix Excel File Recovery Windows Backup Software PC Diagnostic Tools Monitor Instant Messaging Software Talisman Desktop 2.5 A+ Training MCSE Training SQL Server Training Increase Internet Speed Refurbished HP Computers Computer Bargains Computer Armoire XP Tweaking Toolbox Web Address Registration Spyware Removal Registry Mechanic Data Recovery Tool Case Mods Windows XP Speed Up Tweakmaster Internet Optimizer Wireless Internet |
Office XP TipsFREE Computer and Internet Technical problem solving, plus ... Free Tutorials, Free eBooks, Free Courses, Free Guestbooks, Free Autoresponders, Free help and advice, Free Newsletter, Free Affiliate program and FREE MEMBERSHIP. Wow! Did I mention it was Free? Newbies and Oldbies alike are buzzing about the NEW Newbie Club. It's the most exciting Newbie Site ever to hit the Web. Join now - it's FREE! TheNewbieClubTake firm fontrol of your PC and totally transform your internet experience with the most unique and entertaining PC learning course on the web, no technical jargon, designed from the ground up specifically for newbies, my mom loves it. :) Hey I'm a Newbie, not a Dummy, just tell me how! Access Your PC from Anywhere - Free Download You’re invited to try a new remote-access telework solution that CNET says could “change your life.” Gain the freedom to work from anywhere using GoToMyPC. It’s the fast, easy and secure way to access and control your PC via any Web browser — anytime, anywhere. GoToMyPC is perfect for teleworkers, travelers and after-hours access. Installs in 2 minutes – Get Your Free Download Now! Facing 'new world of work,' Microsoft locks up OfficeMay 24 2005-For most of their 20 years, Word and Excel documents have had free rein within corporate walls.In the early days, workers used an array of floppy disks to shuttle documents created with the programs from department to department. E-mail let the files become even more far-flung, easily moving them among branch offices around the globe. But with the advent of federal record-keeping regulations such as the Sarbanes-Oxley Act and the Health Insurance Portability and Accountability Act, which impose strict rules on how companies manage and archive information, those freewheeling days are nearly at an end. Go here for more. OFFXP: Error 1328 When You Apply Office XP Service Pack 1When you apply Microsoft Office XP Service Pack 1 (SP-1), you may receive an error message similar to one of the following:Error 1328. Error applying patch to file C:\Program Files\Microsoft Office\Office10\Msaccess.exe. It has probably been updated by other means, and can no longer be modified by this patch. For more information contact your patch vendor. NOTE: The Office program that appears in the error message may be different from Msaccess.exe. -or- The expected version of the product was not found on your system. Click here for more from Microsoft. Office XP Update: Service Pack 2 (SP2)Office XP Update: Service Pack 2 (SP2) provides the latest updates to Microsoft Office XP. Office XP SP2 contains significant security enhancements, as well as stability and performance improvements. Some of the fixes included with SP2 have been previously released as separate updates. This service pack combines them into one update. Microsoft recommends that users install the Office XP SP2 update using the Office Product Updates site. This site will detect your Office installation, prompt you to install exactly what you need to be fully updated, and can minimize the time required to download this update.Click here for more from Microsoft. Microsoft Issues Second Office XP Service PackYesterday, Microsoft released Microsoft Office XP Service Pack 2 (SP2), a collection of bug fixes for the company's best-selling office productivity suite. Office XP SP2 is available as a Web download, on CD-ROM, or as a special version for corporate rollouts. SP2 fixes affect the Office XP Web Components and all major Office XP applications, including Microsoft Word 2002, Excel 2002, Outlook 2002, PowerPoint 2002, Access 2002, FrontPage 2002, and Publisher 2002."The SP2 update contains significant security enhancements as well as stability and performance improvements," Microsoft states on its Web site. "Some of the fixes included with SP2 have been previously released as separate updates. This service pack combines them into one update." Click here for more from wininformat. Office XP vs. bugs, round twoMicrosoft on Wednesday plans to release its second collection of bug fixes, or service pack, to Office XP, the company confirmed Tuesday. Service Pack 2, a 15MB download, is supposed to enhance Office XP's performance, security and stability, while fixing a wide range of glitches, Microsoft said. "This is a very comprehensive service pack," said Simon Marks, Office product manager. The software giant issued the first Office XP service pack in December.Click here for more from zdnet. "This Installation Package Cannot Be Opened" Error Message When Installing Office XPWhen you try to install Office XP, you may receive an error message similar to the following:This installation package cannot be opened. Contact the application vendor to verify that this is a valid Windows Installer package. This behavior may occur when there is a problem with the installation of Windows Installer. Click here for more. Setup Stops Running and Reports an Internal Error 2350When you try to install Office XP, Setup may stop running, and you may receive an internal error 2350.This issue can occur if Windows Installer is outdated. To resolve this issue, follow these steps to update Windows Installer. Click here for more. ACC2002: Defragment and Compact Database to Improve Performance (Q288631)Note: This articles talks about Microsoft Access 2002.You can improve the performance of Microsoft Access if you periodically defragment your hard disk and compact your database. Because the data on a hard disk will become fragmented over time, you should periodically run a disk-defragmentation utility (or defragmenter). If you make changes often within a database, portions of the database may also become fragmented. Therefore, you should also periodically run the Compact Database utility within Microsoft Access. Click here for more. OFFXP: Error 1328 When You Apply Office XP Service Pack 1 (Q315152)This article describes an error that occurs in a home environment where Microsoft Office XP was installed from a CD-ROM. This article does not apply to you if you are in a corporate environment where you installed Office from a network server or a CD-ROM that was provided by your system administrator.When you apply Microsoft Office XP Service Pack 1 (SP-1), you may receive an error message similar to one of the following: Error 1328. Error applying patch to file C:\Program Files\Microsoft Office\Office10\Msaccess.exe. It has probably been updated by other means, and can no longer be modified by this patch. For more information contact your patch vendor. Click here for more. OFFXP: What Is CTFMON and What Does It Do? (Q282599)When you run a Microsoft Office XP program, the file Ctfmon.exe (Ctfmon) runs in the background, even after you quit all Office programs.This article answers some of the frequently asked questions about the Microsoft Text Services Ctfmon.exe file, which is loaded after installing Office XP Alternative User Input features.Unlike the Alternative User Input features, Ctfmon.exe is a system component that cannot be uninstalled. For more information about disabling Ctfmon.exe, refer to the "Can I remove the Ctfmon.exe file?" section earlier in this article. What amount of system resources is used when Ctfmon.exe is running? Ctfmon.exe uses little of the system resources if Advanced Text Services are not running. Advanced Text Services are those input technologies (speech recognition, handwriting recognition, and Input Method Editors) that are being controlled by Ctfmon.exe via a TIP. Click here for more. Office .NET Revealed?April 6 2002-Is Office NGO really the next version of Office?A number of readers alerted me this week to a fascinating Shockwave animation that purports to demonstrate some of the online/subscription features of the next version of Microsoft Office, which will be called Office .NET. Code-named Office NGO ("Next Generation Office") in the animation, this Office version will include links to a number of of online services, including a secure My Office Web site; a consolidated email account with Web-based Inbox; Office .NET Notifications; online scheduling with a sharable calendar; Meeting Workspaces for viewing agendas, pending tasks, and related documents, SharePoint Team Services-based Team Workspace for sharing information with team members; and a set of online content such as templates, online training, communities, and the like. So is it real? Is Office NGO really a sneak-peak at Office .NET? It's hard to say, and though some UI inconsistencies have me thinking that this is an April Fools prank, I will say this: If it is fake, it's the most elaborate fake I've ever seen. Let's take a look. Click here for more. OFFXP: Error 1328 When You Apply Office XP Service Pack 1 to a Workstation (Q315063)IMPORTANT : This article describes an error that occurs in a corporate environment and is intended for system administrators in that environment.This article does not apply to you if you meet any of the following qualifications: You installed your version of Office XP from a Retail CD-ROM (showing an Office Hologram). You attempted to update your version of Office XP to Office XP Service Pack 1 (SP-1) by using the Product Updates Web site (http://office.microsoft.com/productupdates). If you installed your version of Office XP from a network server or a CD-ROM that was provided by your system administrator, please contact your system administrator about this issue and reference this article number. When you apply Office XP Service Pack 1 (SP-1), you may receive an error message similar to the following: Error 1328. Error applying patch to file C:\program files\Microsoft Office\Winword.exe. It has probably been updated by other means, and can no longer be modified by this patch. For more information contact your patch vendor. Click here for the article from Microsoft. OFFXP: Error 1328 When You Apply Office XP Service Pack 1 (Q315152)IMPORTANT : This article describes an error that occurs in a home environment where Microsoft Office XP was installed from a CD-ROM. This article does not apply to you if you are in a corporate environment where you installed Office from a network server or a CD-ROM that was provided by your system administrator.When you apply Microsoft Office XP Service Pack 1 (SP-1), you may receive an error message similar to one of the following: Error 1328. Error applying patch to file C:\Program Files\Microsoft Office\Office10\Msaccess.exe. It has probably been updated by other means, and can no longer be modified by this patch. For more information contact your patch vendor. Click here for the article from Microsoft. OFFXP: Overview of the Office XP Service Pack 1 (Q307843)Microsoft Office XP Service Pack 1 (SP-1) provides the latest updates to Office XP. Office XP SP-1 contains significant security enhancements, as well as improvements in stability and performance. Some of the fixes that are included with Office XP SP-1 were released earlier as separate updates. This service pack combines the updates into one integrated package and includes a number of other changes that are designed to improve the reliability and performance of your Office XP programs.This article describes how to download and install the Office XP SP-1. Click here for the article from Microsoft. Office XP securityLearn how the new security technologies in Microsoft Office XP put you in control of your Office environment. Get information on today's top desktop security threats, and learn about security practices that work in conjunction with Office features to improve your overall security posture. Get the 411 KB Word 2000 Document on Office XP security, or goto the webpage here.Track Your Progress with Excel 2002 and Word 2002Do you need a way to keep track of your progress on health, fitness, or well-being goals? Microsoft Office XP is the ideal software to help you achieve your health and fitness goals. For example, you can use Microsoft Word 2002 or Microsoft Excel 2002 to create logs that you can use to track your goals, either online or in printed form.When planning to create a log, the first question you might ask yourself is, "Which application should I use?" The answer depends on how much information you want to track and how long you want to track it. Essentially, the more detailed your log is, the more you might want to use a data-driven program such as Excel instead of Word. By using the powerful Sort, Filter, or Graphing features in Excel 2002, you can easily view larger amounts of data in different ways to track your progress. On the other hand, the Table feature in Word works very well for creating logs for daily use. For step-by-step instructions on how to use these features, see Help in your Excel 2002 and Word 2002 programs. Working with Multiple Undo and Redo in Access 2002In Microsoft Access, the Undo and Redo options allow you to undo or redo one or several changes at once. However, the range of operations that you can undo or redo will always begin with the most recent operation and you may only undo or redo operations in the order in which they took place. For example, you cannot undo just the second, fourth, and eighth changes you have made to your table design.
Create a Family Newsletter in Word 2002Sharing information and keeping in touch has never been easier with the advent of the Internet and Microsoft Office software such as Microsoft Word 2002. For example, you can work together with your family to build a newsletter simply by sending or routing a Word document in e-mail to gather the information you need. With all information in hand, you can then send your newsletter to family members through regular mail or e-mail, or if you have a Web site, host it online.Deciding what to write aboutWhen writing a family newsletter, first consider what information sections to include. Feature pieces are often driven by recent family events such as holidays, births, and graduations. Regular sections might include an upcoming events calendar, Web site links, a humorous piece, or a message from Mom.Similar to a newspaper or magazine, and depending on how often you publish, you might have a weekly or monthly feature section followed by regular sections that provide updates on the lives of your family members. Typically one family member acts as lead organizer, ensuring all information is collected and included in the newsletter, and then sends it out. Organizing your informationWith Word 2002 you can organize your newsletter using columns, linked text boxes, or both. You can also insert a picture and format your text to wrap around it. If you choose to divide your newsletter into columns, text will snake across each page before continuing on to the next page. If you use linked text boxes, you can arrange information so that it is parallel or side-by-side down each page. To showcase a feature story on the first page but provide the remaining text on another page, you need to use linked text boxes regardless of how many pages are in your newsletter.For step-by-step instructions to complete any of these tasks, see Help in your Word 2002 program. Create Party Invitations, Envelopes, and Labels with Word 2002So you're having a party, you've done all the planning, and now you need to let people know about it. When you get the final guest list together, you are ready to send out the invitations. How can Microsoft Word 2002 help you from here?With a little help from Word 2002 and the Microsoft Office Template Gallery, you can create and print your party invitations, envelopes, and return address labels. You can also optionally perform a mail merge with the guest list (from your Microsoft OutlookŪ contacts) to print out attendees' addresses quickly. Create your invitationsYou can create your own party invitations in Word by starting with a blank document and adding text, formatting, and graphics to create the look you want. Or, to get a head start, you can use the Birthday party invitation in the Template Gallery. Open the template in Word, add the information for your party, make any design changes you want, and print your card. This template was designed to create a card that you can print on standard 8.5" x 11" paper and then fold in quarters to create a 4.25" x 5.5" card. You may choose to print your invitations on colored card stock, but make sure the paper is not too heavy since you will be folding it twice.Create and print your envelopesBefore you create your envelope, determine whether you want to print envelopes individually or all at once. If you are inviting a small number of guests, printing the envelopes one at a time is the simplest way to go. If you are inviting a large number of guests, you might want to set up the envelopes for a mail merge to address and print all the envelopes at once.Print envelopes one at a timeYou can either print each envelope directly from the Envelopes and Labels dialog box, or you can add the envelope to your party invitation document so that you can add graphics, make changes to the envelope directly from the document, and save the envelope to use again another time.Print all the envelopes at onceIf you have stored your party guests' names in your Outlook Contacts folder, you can follow these steps to select guest names and perform a mail merge from your Contacts folder. However, you can use just about any type of data source you want (such as a list of guests' names in a Word document) to complete the mail merge. For more information about data sources you can use for a mail merge, see Microsoft Word Help.
Print your return address labelsIf you want to print labels with a "party" theme, use the party return address labels template in the Office Template gallery. (This template works with Avery labels 5167, 5267, 6467, 8167, and 8667. To create return address labels from scratch on label sheets other than these, on the Tools menu, point to Letters and Mailings, point to Envelopes and Labels, and then click the Labels tab in the Envelopes and Labels dialog box.)
Using the Task Pane Feature in FrontPage 2002The Task Panes in Microsoft FrontPage version 2002, allow you to have easy access to frequently used commands like Open Page, new Empty Web, Web Site Templates, and Add Network Place.The Task Pane opens whenever you choose New and then Page or Web from the File menu or you can open the Task Pane in FrontPage 2002, by doing the following:
Accessing Clipboard and Search Task Panes in FrontPage 2002Multiple Task Panes in Microsoft FrontPage version 2002, allow you to quickly switch between different task areas including adding new templates and pages to your Web, Search, and special paste features of the Office Clipboard.To use these Task Panes in FrontPage 2002, do the following:
Exchanging Data between Excel and Access with AccessLinksIf you're working in Microsoft Excel and Microsoft Access, you can use several Access features to maintain your Excel data with the AccessLinks add-in program.If the Convert to MS Access, MS Access Report or MS Access Form commands are not available from the Data menu, you need to load the AccessLinks add-in. The AccessLinks add-in program is available from the Microsoft Excel Download Web site. Using Access to manage Excel dataConvert an Excel list to an Access database If you have a large Excel list and you want to take advantage of the Access data management capabilities, security, or multiuser capabilities, you can convert the data from Excel to an Access database. Use this method when you want to move the data from Excel into Access and use and maintain the data in Access from then on.Create an Access report from Excel data If you are familiar with designing Access reports and want to summarize and organize your Excel data this way, you can create an Access report from the data in your Excel list. For more information about designing and using Access reports, refer to Microsoft Access Help. Use an Access form to enter Excel data If you want to use a customized form to enter, find, or delete data in an Excel list (a series of worksheet rows that contain related data), you can create an Access form for your list. For example, you can create an Access form that lets you type the entries for an Excel list in a different order from the order of the columns on your worksheet. Use this method if you want the specific features available in Access forms. For more information about designing and using Access forms, refer to Microsoft Access Help. Convert Excel data to an Access database
Create an Access report from Excel data
View or update an existing reportTo view the report again in Microsoft Excel, click the View MS Access Report button on the worksheet to the right of your list. If you've added data or changed the data in the list since you created or viewed the report, the report is updated with the changes.For more information about the report, see Microsoft Access Help. Enter data into Excel with an Access formCreate a new Microsoft Access form
If Microsoft Excel can't find the form, the Create Microsoft Access Form dialog box appears. To look for the Access .mdb file that contains the form, click Browse. Saving a Text File to a Web Server in Excel 2002When working with text files in Microsoft Excel that are located on a Web server, you cannot use the Save command to save a text file to the Web server when that file was opened from the Web server. There is, however, a simple solution to this problem. This article describes how to save a text file to a Web server, how to open a text file from a Web server, and how to save a text file that was opened from a Web server back to that Web server.Saving a text file to a Web server
Opening a text file from a Web server
Saving a text file opened from a Web server back to that Web serverClicking Save after making changes to the file opened from the Web server brings up a message that states "The file could not be accessed." In order to save the text file back to the Web server, do the following:
Inserting References into Online Discussions in Excel 2002Why can't you create a discussion at a specific location in Excel?When you create discussions in Microsoft Excel 2002, you cannot create a discussion at a specific location within the document because Excel allows for hundreds of worksheets in a workbook, and several thousand cells for each worksheet. Because of this complex design, Web Discussions cannot apply to each worksheet or cell in a given workbook.What's the solution?When you post your discussion, put the worksheet and/or cell reference in the subject line of the discussion. That way others who use your document can easily reference the worksheet or cell you're describing in the text.Easily insert the latest stock quote into a worksheet with Excel 2002In previous versions of Excel, obtaining an up-to-date stock quote required the use of a Web query. But in Office XP, you can now get a stock quote inserted directly into your worksheet and have it updated on a regular basis with the help of a Smart Tag. To use this feature you must be connected to the Internet.To add a stock quote to your worksheet, enter the stock ticker symbol for the company in a cell, such as MSFT for Microsoft. Note that you must type the symbol in all capital letters. Then, point to the triangle in the lower-right corner of that cell to display the Smart Tag icon and click on it. From the Financial Symbol menu, select Insert Refreshable Stock Price. Then select where you want the stock price to be displayed. You can choose either On A New Sheet or Starting At Cell, which puts the stock price in the cell you specify. To have the price update automatically on a regular basis, right-click in the worksheet and choose Data Range Properties from the shortcut menu. Then, set the Refresh Every n Minutes setting to how often you want Excel to update the stock quote and click OK. |
|
||||||||
