Site Meter Microsoft Office » Quick Tips

Quick Tips

Microsoft Access: Quickly get started tracking information

Monday, August 25th, 2008

Start working immediately with the results-oriented features in Office Access 2007:

Prebuilt solutions.

The new Getting Started screen includes a variety of prebuilt database solutions. Use these applications right out of the box to track contacts, events, issues, assets, tasks, and more — or treat them like templates, and enhance and refine them to accommodate the kind of information you want to track or the way in which you want to track it. As other application templates become available from Microsoft Office Online, they will be advertised in the Getting Started screen.
Office Fluent user interface. Office Access 2007 has been updated with a fresh look that makes it easier to create, modify, and work with tracking applications (Access database solutions).

The Office Fluent user interface (UI)

is context-sensitive and optimized for efficiency and discoverability. From the nearly 1,000 available commands, the Fluent UI displays only those relevant to the task you are performing at any given moment. In addition, the tabbed windows view and a new status bar, scroll bars, and title bar give applications built on Office Access 2007 a very modern look.

Improved navigation.

The new Navigation Pane provides a comprehensive view of tables, forms, queries, and reports. You can even create custom groups to organize and see all the forms and reports related to a single table.

Quickly create tables.

Office Access 2007 makes it easier to work directly within a datasheet to create and customize tables. Enter information into a data cell — just as you do in Microsoft Office Excel. When you enter a new value, Office Access 2007 automatically adds a new field and detects the data type (for example, date, number, or text). You can even paste Excel tables into a new datasheet, and Office Access 2007 will build all the fields and recognize the data types automatically.

How do you use Office Access 2007?

Browse Encouraging Health.

Top 25 Super Tweaks for Windows

Thursday, August 21st, 2008

Received these 25 tweaks in my inbox a few weeks ago. I haven’t done all of them and I cannot vouch for their safety. Just a little disclaimer, fyi. If you know of more tweaks, feel free to let us know.

1. Remove Unused Programs. Start/ Control Panel/ Add Remove Programs/ Remove/ Yes. If you are not using a program then get rid of it. If you don’t know what it is, enter it in Google and find out.

2. Clean your Desktop. After removing programs you no longer use, get rid of trash files, folders, and lost icons on your desktop. Put them where they belong. I bet many can go in the trash. Some might be left over from programs you just removed. If that is the case, just right click/Delete

3. Clear Browser Cookies And Files. Internet Explorer, Open Internet Explorer/ Tools/ Options/ General/ Delete Cookies, files, Clear History. Firefox, Open Firefox/ Tools/ Privacy/ Check, Accept cookies/ Keep Until I close Foxfire/ Check, Always clear my private data when I close Firefox.

To make short work of all cookies, browsing history, and downloads, use a program like “Erase” to assure there will be no traceable information left behind.

4. Remove Temporary Files. Start/ All Programs/ Accessories/ System Tools/ Disk Cleanup/Check all items/ OK/ Yes. If you have more than one drive connected, be sure to run the Disk Cleanup for it also.

5. Use a registry cleaner. Although the PC Pitstop Optimize program will clean some files from your registry it is also a strong Optimization program and not strictly a registry cleaner. Right now what’s needed is a thorough cleaning. There are many registry cleaners and none of them get all of the broken registry files. That can be a good thing because if you use a program that removes needed files you will be in trouble. One program that I’ve used for a long time with no problems is RegScrubXP. Another good thing about this program is that it’s free. Give it a whirl.

6. Remove Unused Windows Components. Start/ Control Panel/ Add Remove Programs/ Add Remove Windows Components/ uncheck the box of what you want removed/Next/ OK. Just like old programs, there are XP components that most people never use. For me I never use Indexing or MSN Explorer.

7. Defrag your hard drives. Even if all you use is the default Windows defrag program, defrag your hard drive. Start/ All Programs/ Accessories/ System Tools/ Disk Defragmenter/ Defrag/ OK. Whether Windows thinks you need to defrag has nothing to do with it. It’s always a good idea to defrag after installing and uninstalling programs, applications, and games. If you want to not only defrag your drives but set them to operate at maximum efficiency, then use the Disk MD program. Disk MD will defrag your hard drives and configure the files for easy access.

8. Update all your drivers from the manufacturers site. Sometimes this can be an easy task, but mostly it requires some searching to find the correct driver. Because all hardware is different, I can’t direct you from here. What I can do is direct you to Driver Alert. Download the free scan to see a list of drivers that need updating. If you decide to buy the program it will direct you to the correct download location.

9. Clean out your Start-up programs using msconfig..Start/run/type “msconfig” without the quotes/startup/uncheck any program that does not need to start with Windows/Apply/OK/Reboot. This will remove the resource wasters that open each time you boot Windows. Do not use msconfig to turn off system processes and services.

10. Modify System Restore. Start/Help and Support/Undo Changes/System Restore Settings/Turn off System Restore/OK. If you are going for the fastest system you can achieve, just turn System Restore off. I do. If you are wanting to keep it as a backup safety feature then at least reduce the amount of space that is being set aside for this feature. PC Pitstop has suggested reducing this waste of expensive hard drive space for some time now. I suggest something in the 1300MB to 1500MB range. The % this represents will vary with the size of your hard drive. Start/Help and Support/Undo Changes/System Restore Settings/Disk Space Usage/Move the slider to correct position/OK. Keep in mind that while I don’t use System Restore, I do use Acronis True Image Home for creating backups. It’s as easy as clicking “Clone”. I create new clones at least every week.

11. Delete your old Emails. Start/Outlook Express (or email client)/Inbox/Inbox/Delete all unwanted emails/Deleted items/Right click each deleted item/Delete them permanently. Emails can waste space at an alarming rate. If you don’t need them, get rid of them.

(more…)

PowerPoint Tip: Copy a presentation to a CD or anyhwere

Tuesday, November 20th, 2007

type When you copy your Microsoft Office PowerPoint 2007 presentation to a CD, a network, or a local disk drive on your computer, Microsoft Office PowerPoint Viewer 2007 and any linked files (such as movies or sounds) are copied as well. For information about Office PowerPoint Viewer 2007, see Install and run PowerPoint Viewer.

Office PowerPoint 2007 does not support the direct burning of content to any DVD formats. As an alternative, follow the steps below to copy your presentation to a folder, and then use DVD-burning software to import the content and create a DVD.

Important   Before you copy and distribute your presentation, inspect your presentation for hidden data and personal information (see step 10 below), and then decide whether it is appropriate to include this information in the copied presentation. Hidden information might include your name as the presentation’s creator, your company’s name, and other confidential information that you might not want outsiders to see. Also, check your presentation for objects or hidden slides that are formatted as invisible.

Note   This solution is a more convenient method that replaces the Pack and Go Wizard, which you may have used in earlier versions of PowerPoint.

Copy your presentation

  1. Open the presentation that you want to copy, or, if you are working with a new presentation that has not been saved, save the presentation.
  2. Do one of the following:
    • If you are copying your presentation to a network or to a local disk drive on your computer, go to step 3.
    • If you are copying your presentation to a CD, insert a CD into the CD drive.

        Notes 

      • You can copy to a blank recordable CD (CD-R), a blank rewritable CD (CD-RW), or a CD-RW that contains existing content that can be overwritten.
      • In PowerPoint, if you copy your presentation to a CD, make sure that you copy all of the files in a single operation. After the first set of files is copied, you cannot add any more files to the disc by using PowerPoint. However, you can use Windows Explorer to copy additional files to a CD-R or CD-RW that contains existing files. See Windows Help for more details.
  3. On the Microsoft Office Button, point to the arrow next to Publish, and then click Package for CD.
  4. In the Package for CD dialog box, in the Name the CD box, type a name for the CD or the folder that you want to copy your presentation to.
  5. To choose the presentations that you want to copy and the order in which you want them to play, do the following:
    • To add a presentation, click Add Files, select the presentation that you want to add, and then click Add. Repeat this step for each presentation that you want to add.

      Note   If you want to add other related, non-PowerPoint files in the package, you can. These files will be copied, but Office PowerPoint Viewer 2007 will not play them.

    • If you add more than one presentation, the presentations will play in the order in which they are listed in the Files to be copied list. To change the order, select a presentation that you want to move, and then click the arrow buttons to move the presentation up or down in the list.

      Note   The presentation that is currently open automatically appears in the Files to be copied list. Files that that you linked to the presentation are included automatically, but they do not appear in the Files to be copied list.

    • To remove a presentation or file from the Files to be copied list, select the presentation or file, and then click Remove.
  6. Click Options.
  7. Under Package type, do one of the following:
  8. Under Include these files, do one or both of the following:
    • To ensure that files that are linked to your presentation are included in the package, select the Linked files check box. Files that are linked to your presentation can include Microsoft Office Excel worksheets that are linked to charts, sound files, movie clips, and more.
    • To use embedded TrueType fonts , select the Embedded TrueType fonts check box.

        Notes 

      • If your presentation does not currently include embedded fonts, checking the Embedded TrueType fonts check box includes the fonts when packaged. The Embedded TrueType fonts check box applies to all presentations that are copied, including linked ones.
      • If your presentation already includes embedded fonts, PowerPoint automatically honors the setting of the presentation to include the embedded fonts.
  9. To require other users to supply a password before they can open or edit any of the copied presentations, under Enhance security and Privacy, type the password or passwords that you want to require to open the presentation, edit it, or both.

    Passwords apply to .pptx, .ppt, .potx, .pot, .ppsx, .pps, .pptm, .ppa, .ppam, .mhtml, and .mht files that have been converted to .ppt files, in the copied presentations. If any of the files that you copy already have passwords assigned to them, PowerPoint prompts you to choose between keeping the previously assigned passwords for those files and overriding them with the new passwords. If you choose to override the previously assigned passwords, they are no longer accepted for the copied versions of the files. However, they are still accepted for the original versions.

  10. To inspect your presentation for hidden data and personal information, select the Inspect presentations for inappropriate or private information check box.
  11. Click OK to close the Options dialog box.
  12. Do one of the following:
    • If you are copying your presentation to a network or to a local disk drive on your computer, click Copy to Folder, enter a folder name and location, and then click OK.
    • If you are copying your presentation to a CD, click Copy to CD.

Source

Recommend Reading:

Download IE7 without WGA

New Xbox 360 Console for Families

Quick Tip - Read Office 2007 files with older versions

Monday, April 23rd, 2007

Quick Tip

If you’re like me, you usually download the latest and greatest versions of software, and wait until you’re all comfortable with our new setup when a thought hits you.

What about people who dont have this?

Well, if you’re using Office 2007, that shouldnt be a problem anymore. Docx Converter.com lets you upload your Office 2007 files, and it will convert them to html. It will still keep most of your formatting, and then you can just cut and paste the page into your earlier version of Office, and save it out in a more supported version.

Give it a shot, let me know your thoughts, and if you wind up using it a lot, they have a free desktop widget you can use.

, , , , ,

Quick Tip: Directories from the Command Line

Tuesday, April 17th, 2007

Quick Tip

Have you ever needed to make some directories with subdirectories in a hurry? You might not want to have to open the folder, right click, choose ‘New Folder’, highlight it, rename it, and repeat. Well here’s a quick tip that you can use from the command line, and will also check to see if the directories exist!

Here’s how to do it:

  • Go to the command prompt (click start->run->type “cmd.exe”)
  • Type (without quotes) mkdir -p a\b\c\d

What this will do is make a directory called “a”, and inside that directory it will create “b”, and so on and so on. If the directory already exists, it will give you an error message, but still make the ones that aren’t there.

Don’t forget, if you’re going to have spaces in a name, enclose it with quotation marks.

Stay tuned for more.

, , , , , ,

About Microsoft Office

We’ll be discussing Microsoft Office products, the suites, updates and upgrades, tips and tricks. There are wonderful programs that Microsoft has come out with, especially Word, Excel and Outlook. There are programs for everyone out there, from home and student workers, small businesses and corporations. So, keep in contact, watch this space, as the saying goes, contact me with your tips, comments

Microsoft Office Author(s)
    » Brick-ONeil

Technology Channel Posts

Hot Off The Press

  • finally, I draw names from a hat
    I've decided it's about time to announce some winners. Who has won what? I'm not sure what I promised, or what people want (I am distressingly vague today) so if your name is on the list, email [...]
  • Onobun, Hill lead big men in frontcourt
    He's built like a linebacker, has the smile of a child and the patience of a saint. After three years of under-accomplishment and the contemplation of a transfer from Arizona, this is finally [...]
  • Statue Unveiled & Shelter Celebrates
    Sid Patterson Statue Unveiled Mayor Kathy Taylor assisted in the unveiling of a statue, "Planting for the Future," commemorating Up With Trees founder Sid Patterson last week. The event took [...]
  • Preview for SPECIAL TNA Thanksgivings
    PREVIEW FOR THURSDAY'S SPECIAL THANKSGIVING "iMPACT!" BROADCAST ON SPIKE TV After the turkey, tune into Spike at 9pm ET for TNA's holiday event This Thursday night, TNA Wrestling returns to [...]
  • FSU weekly news (November 17 - November 21)
    In this edition of FSU Headlines (15:20): - FSU Goes to Omaha - FSU Driving the Future - FSU Making Cents for Students - FSU Going Global - FSU Goes Hands-On with Tuition, Music Subscribe to FSU [...]
  • Seattle Weekend Edition for 11/22/08
    We are just one week from Thanksgiving and just over a month away from Christmas. The Christmas sales are everywhere and stores are doing everything they can to lure your into their stores. Have you [...]
  • Friday Free-for-All - Romance
    Hello and welcome to the Friday Free-for-All! I don't know about you, but I am more than ready for this week to be over... Inspired by the Weekend Soiree over at Wifely Steps (and pretty much [...]
  • The Office Season 5 Episode 8 Frame Toby
    Toby is back at his old HR desk, causing a lot of anxiety for Michael who wasn't aware of this and who still haven't come to terms with Holly, former HR and the love of his life, leaving [...]
  • People Magazine Names Some Sexy Men
    Ok, I'm going to get to all ten of the Sexiest Men of the Year but I'm telling you, I may have to cheat and add some of my favorites in here because, really, they just missed the boat on some of [...]
  • Week-long activities educate about transgender daily lives
    Transgender Awareness Week has brought education and attention about transgender issues. Shannon Jolliff, Office of Gay and Lesbian Programs director, said it has been a success on campus. "The [...]