Microsoft Office for iPhone

60 Seconds with Pogue.
David Pogue, tech blogger for the NYTimes.com, shares his review on Office for iPhone.

Send out the Search Party

Who doesn't love a party? But like many parties, there can be a lot of things to sort through when it's over.
When creating objects in Access, I often jump between object types. In doing so, I forget if what I created last week was a table or a query. If I have a lot of objects, it can be time consuming to look through everything, especially if I forgot exactly what I called it. Enter the Search bar.
On the Navigation pane, there is drop-down list allowing you to sort your objects by type, date, view, etc. But no option to search. If your right-click the bar, you'll get the option to turn on the Search Bar in the quick menu that appears.

1. Change the view of the Navigation pane using the drop-down menu. Change Navigate To Category to Object Type and Filter By Group to All Access Objects.
2. Click in the search box and as you type, the list of objects will begin to filter. The search will find the object name that either starts with, ends with or contains all or part of the search term you type.

To view all objects again, click the Clear Search String button at the end of the Search... field.

Nice part is, when you close and reopen Access, the Search Bar remains, so you don't have to turn it on every time. Happy searching!

Excel shortcuts for PC and Mac

Sorry to be lazy on this post, but I found this fantastic page from ExcelJet.net. They have popular keyboard shortcuts for the PC and Mac. It's visually easy to read and has BOTH platforms. I hope you can bookmark and use this page to make your work in Excel more efficient. Visit their homepage for many great Excel tutorials.

Some like it Hot

Have I got a HOT topic for you. No, not hot pants. It's hot corners in Windows 8. Yes, I know. I could go on and on with "hot" jokes and I very well may. You've been warned.
You should have heard by now that Windows 8 was designed for touch as well as mouse. If you are a desktop/mouse user, somethings will seem kind of foreign to you. Touch users will find it much more intuitive. This is the point in the conversation where I'd usually say, "sorry Mac lovers, you're out of luck." But not today. Mac users will likely be familiar with hot corners. They will also be thrilled to know that they have made their way into Windows 8.
There are four corners of your screen. Each corner has a function. When you move your mouse to the corner, a thumbnail or the Charms will be visible.

1. Top-right:  Charms (or Win+C). Move your mouse down and select the charm you want.
2. Bottom-right:  Charms (or Win+C). Move your mouse up and select the charm you want.
3. Bottom-left:  Start menu. When the thumbnail appears, do NOT move your mouse to the thumbnail to click. Instead, click the corner that made the thumbnail appear.
4. Top-left:  Recently used and open apps. In Windows 8, applications are those things you see on the left of the Start screen. You know, the live tiles and what not. Also, the desktop (where you have your open programs, folders, etc.) is an application. Again, do NOT move your mouse to the thumbnail to click. Instead, click the corner that made the thumbnail appear. One click will open the most recently used. A second click will open the next, and again for the next. Get the idea? If that's not enough, I have more for you. If the thumbnail is too small, click and drag it to the center of your screen. You'll get a bigger view. If you let go of the mouse, the app will open. If it's not what you're looking for, move the app back to the top-left corner.

For either hot corner on the left side, when you see the thumbnail, move your mouse up/down to the center and a bar will open with thumbnails of your open apps and the Start menu. If you click and drag an app on the side bar to the middle of the bar, it will snap to the left side of your screen, creating a sort of split-screen effect. This allows you to have your Mail app open as you work on your desktop.

Don't forget that there is no "close" button on apps. To close them, place your mouse cursor at the top of your screen. When the pointer turns to a hand, click and drag the app to the bottom of your screen.
Whew! I made it to the end of this article without another "hot" joke.

Happy Birthday, PowerPoint!

PowerPoint 1.0 was launched on the Mac platform on 20 April 1987 after its developers decided Windows was not able to support it. Robert Gaskins, is the proud father of PowerPoint. The first version produced black and white overhead transparencies (with speaker's notes as handouts). PowerPoint 2.0 came in May 1988 and eventually found its way to Windows in May 1990. This version added output of 35mm color slides and online transmission. It wasn't until PowerPoint 3.0 in 1992 that the output included live video color slideshows including slide transitions, builds, animations, and synchronized sound and video clips.

Office 2013 Quick Start Guides

Get to know the new Office 2013 with these downloadable and FREE Quick Start Guides. These printable guides contain useful tips, shortcuts, and screenshots to help you find your way around. If you are a Windows 8 user, you can open and view these guides in the Windows 8 Reader app without any additional steps.

Where was I? or RELOCATE!

Yes, there are two names for today's post. Because I'm old school, I used the old terminology, "relocate." If you spent any time on an electric typewriter, you may remember a fabulous button called RELOCATE. It would take you back to the last three places you were on your document. It worked great for when found a mistake and needed to fix it and then return to where you left off. These electric typewriters were the beginning of today's word processors.
This brings us to today's Word tip: Shift+F5.
If you are a person who likes to "jump around" your document as you type, you'll love this. Say you're typing a long thought. You stop and read what you have just finished typing. You notice an error. You click on the error and make the change and now need to return to where you left off to continue your thought. Pretty easy to do if your error is on the same page, but if it is on different pages, you might want a shortcut. After fixing your error, you don't need to scroll all the back to where you were to continue. Instead, just press Shift+F5. Word will remember will remember the last five places you've been for easy navigation as you type.