Hot Microsoft Office How-Tos
How To: Create a simple form in Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about basic form design using tables. For more on creating forms in Access, watch this how-to.
How To: Create a combo box in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating an alphabetically sorted combo box search. For detailed instructions, and to get started using combo boxes yourself, watch this MS Access how-to.
How To: Add graphics to forms in Microsoft Office Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about adding, resizing and placing graphics as either standalone images, or as backgrounds. For detailed instructions on incorporating images into your Access projects, watch this how-to.
How To: Add OLE objects to tables and forms in MS Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about adding an individual graphic to each record in MS Access. To get started using OLE objects in your own tables and forms, watch this MS Access video how-to.
How To: Use calculated queries in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using calculated field to work out the tax payable on an item, then adjusting item value. For more, and to get started using calculated queries yourself, watch this MS Access how-to.
How To: Password protect databases with Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a login form and password protecting your database.
How To: Protect VBA code in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about protecting your VBA code from snoopy little trolls. For more information on keeping your VBA code secure, watch this MS Access how-to.
How To: Create a multiuser login system in Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a multi-user login form to password protect different areas of your database.
How To: Use Google-style queries in Microsoft Office Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using Access to create a search engine type query that can adapt to fragments of data. For more on using Google-style queries in MS Access, watch this how-to.
How To: Create subforms in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating subforms (assuming relationships have already been created). For more on subforms, watch this MS Access how-to.
How To: Use queries to pull data from tables in MS Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using relationships and queries to pull data from tables. For more information, watch this Microsoft Office Access how-to.
How To: Archive data in Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using an append and delete query sequentially using a macro. For more on archiving data in Microsoft office, take a look.
How To: Use append queries in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a table clone and appending data to it. To learn more about using append queries in Microsoft Office Access, take a look.
How To: Use delete queries in Microsoft Office Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using queries to selectively delete records. For more information on using delete queries in Access, take a look.
How To: Create a switchboard in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a simple four-button switchboard in Microsoft Access. For more information, watch this Access how-to.
How To: Create a message box in MS Access with a macro
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using a macro in the service of creating a simple message box. For more information, watch this Access how-to.
How To: Go to New Record in a form using macros in MS Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using a macro to force a form to open on new record. For more information on going to `New Record' in a form by using macros, watch this Access how-to.
How To: Create a form from a query in Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using a query rather than a table to create a form and select records. For more information, and to learn how to create a form from your own Microsoft Access queries, watch this how-to.
How To: Run queries from forms in Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about running a query from a form using a button. To get started running queries from forms in Access, take a look.
How To: Use parameter queries in Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about passing parameters to queries in Microsoft Office Access. For more information, and to get started running your own parameter queries, take a look.
How To: Use Boolean operators in Microsoft Access queries
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using the Boolean logical operators AND OR and NOT in queries in Access. To get started using Boolean operators in your own Access queries, take a look.
How To: Use logical operators in Microsoft Access queries
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using mathematical operands and other logical operators to select data in queries. For more information on using logical operators in your own Microsoft Access queries, take a look.
How To: Use wildcards in Microsoft Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Office Access 2007 video tutorial, you'll learn about using wildcards to fill in the blanks in Access. For detailed instructions on using Access yourself, watch this video how-to.
How To: Create simple queries in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using simple select queries on one or more fields. For more information, or to get started using simple queries in your own Microsoft Access databases, watch this how-to.
How To: Sort data with queries in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about sorting data using queries. For detailed instructions, and to get started using queries to sort data for yourself, watch this how-to.
How To: Use database queries in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about what queries are, and scratches the surface on what they can do, For more information, and to get started running your own database queries in Access, take a look.
How To: Add a clock to a form in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using a tiny bit of VBA to add a clock to a given form. For step-by-step instructions, take a look!
How To: Modify control buttons in Microsoft Office Access 2007
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about disabling the close, minimize and maximize control buttons and record selectors as well as adding your own graphical icon and program title. For more information on modifying control buttons in Microsoft Off...
How To: Add fields, tables and forms in Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn how to add and modifying fields to a pre-existing table, and applying these changes to an associated form. To get started adding and modifying fields, tables and forms in Access, take a look!
How To: Quickly navigate around in Microsoft Excel
Many seasoned users of Microsoft Excel, who have been using spreadsheets for years, still scroll through their spreadsheets, laboriously, with the horizontal and vertical scrollbars. In this software tutorial, you'll learn how to navigate around in Excel both quickly and efficiently. For more, take a look!
How To: Create a preview button in Microsoft Outlook Express
This video tutorial, designed for users of the Windows XP and Vista operating systems, offers instructions for creating a preview button in Microsoft Outlook Express or Windows Mail. For step-by-step instructions on disabling the automatic preview pane, watch this handy how-to.
How To: Wrap text around picture in Microsoft Word
Ever wanted to wrap text around a picture in Microsoft Word (or most any other comparable word processor) but weren't sure how to do so? If so, you're in luck: this video tutorial will take you, step by step, through the wrapping process. To get started wrapping your own text around your own graphics in Microsoft Word, take a look.
How To: Make NeoOffice documents Microsoft Word compatible
Microsoft Office is the defacto standard for document creation, but you can get that functionality and compatibility without paying a dime. For Macintosh users, use NeoOffice and learn to save your docs automatically in the MS Office formats.
How To: Use the Format Painter tool in Microsoft Word
If you use Microsoft Word quite a bit and have never used the Format Painter tool, it's a technique you need to learn, and learn today, because it's a technique that will save you a lot of time and a lot of grief in the future. To learn how to use the Format Tool in Microsoft Office Word documents to streamline the formatting process, watch this how-to.
How To: Convert Excel spreadsheet data to XML
Here is a quick video on how to convert Excel spreadsheet data to XML for import into Flash or Flex. Don't spend time typing all that data again, instead create a schema in Excel and convert it to XML.
How To: Drag and drop emails in Outlook
Outlook is one of those applications that has 100 ways to do the same task. Today I’m going to show you how to automatically extract data from an email and have it populate fields in various modules in outlook (Contacts, Tasks, Calendar)
How To: Create a histogram-like display in Excel 2008 for OSX
Here is how to make a histogram-like display in Excel 2008 for OSX. Note that you have to right click on the actual bars in the graph to get the menu to come up. If you work on a Mac and need to use Excel 2008 to make histograms, then watch this MS Office tutorial.
How To: Automatically create a table of contents in Word 2007
Putting together a table of contents is as easy as 1, 2, 3, especially when you use built-in heading levels as you begin writing your first draft. Then let Microsoft Office Word create the TOC with your headings. Watch the demo to see how to insert a table of contents and make revisions that Word will update automatically.
How To: Use headers and footers in Word 2007
In this 3-part series, you learn how to use headers and footers in Microsoft Word 2007. Part 1 shows you how to add page numbers to multiple-page documents, customize your document from a gallery of predesigned headers and footers, and even change the theme.
How To: Stay on top of things with Outlook 2007
Flags are colorful reminders for items you need to follow up on, whether tasks, messages, or contacts. Microsoft Office Outlook 2007 offers several options for setting flags to complement the way you work. Flags can give you pop-up reminders and they also appear in the To-Do Bar, where you can easily see what actions you need to take each day. Learn how to stay on top of things with reminders in Outlook 2007.