Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Create an Excel data entry form that includes check boxes
- Excel provides a simple data form to enter data into an Excel database. The form only only contains text box controls, which can be cumbersome when entering certain types of data.For example, you want to create a table that lists the educational level of your latest batch of job applicants....
- Tags: tip, Microsoft Office, Excel
- Blog posts 2007-07-31
- Create process diagrams in less time with Word 2007's SmartArt
- Prior to Word 2007, adding process diagrams to Word documents required a lot of resizing of both the graphics and the text. If you applied a different format and decided you did not like it, you had to undo it. Word 2007's SmartArt feature automatically resizes text and graphics for...
- Tags: Word 2007, tip, Office 2007, Microsoft Office
- Blog posts 2007-07-31
- Use Word 2007's contextual Spell Checker to avoid embarrassing errors
- Word's spell checker can help you cut down on spelling errors, but what if you type the word right, and it should be write? Until Word 2007, the spell checker would have ignored the error.For those of us who consistently type to for too, there for their, or site for...
- Tags: Word 2007, tip, Office 2007, Microsoft Office
- Blog posts 2007-07-24
- Quickly convert text values to numbers with Excel's Paste Special
- After copying data from an Access table, you notice that you cannot perform any calculations on what you thought were number fields. Instead of numbers, the imported values behave as text. By using Excel's Paste Special feature, you can quickly convert those values to numbers. Follow these steps:1. ...
- Tags: tip, Microsoft Office, Excel
- Blog posts 2007-07-24
- Add a Total row to your Access 2007 table
- Before Access 2007, you could calculate totals on your data in query, report, or form view. Access 2007 lets you add a Total row field to your tables.For example, say you want to find out the average number of hours your employees worked per week in June. Follow these steps...
- Tags: tip, Office 2007, Microsoft Office, Access 2007, Access
- Blog posts 2007-07-24
- Save time by creating tables from Access 2007 field templates
- Easily create fields for your tables by using Access 2007 field templates. A field template is a design for a field, complete with a name, data type, length, and predefined properties. All you need to do is decide which fields pertain to your data and then drag the appropriate field...
- Tags: tip, Microsoft Office, Access 2007, Access
- Blog posts 2007-07-17
- Add a help button to Excel 2002/2003 applications
- It's quick and easy to create help messages using Excel's 2003/2002's Data Validation feature, as long as your help message is 250 words or less. If you need to write a help message that exceeds this limit, such as a mini-manual with examples, you can create a text box that...
- Tags: tip, Microsoft Office, Excel
- Blog posts 2007-07-17
- Insert directions into Word using Smart Tags
- When you invite clients to company events, such as training seminars, you need to include directions in the invitations.You are sending letters out to several of your clients, inviting them to a special training seminar your company is presenting, and you would like to send directions along with your letter....
- Tags: Word 2007, tip, Office 2007, Microsoft Word, Microsoft Office
- Blog posts 2007-07-17
- Print mailing labels using the Label Wizard in Access
- You don't need to import your Access data to an Excel worksheet to create mailing labels in Word; Access provides a Label Wizard for creating mailing labels from your data. The Label Wizard supports a large variety of labels and allows you to specify your label's dimensions.For example, you have...
- Tags: tip, Microsoft Office, Access
- Blog posts 2007-07-11
Additional Resources
- What to do when styles don't seem to match
- Sometimes, there may be variations in the appearance of your text, even if it carries the same style. As Mary Ann Richardson explains, Word's Reveal Formatting feature can help you ferret out any discrepancies. by Mary Ann Richardson
- Tags: Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-07-22
- Create an Access form that calculates how many months a project has been underway
- Set up a simple form that can quickly tell you how long you've been working on a project. Mary Ann Richardson walks through the process. by Mary Ann Richardson
- Tags: Box, Microsoft Access, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
- Blog posts 2008-09-30
- Add upcoming renewal dates to your Access database
- Calculating future dates in Access is easy, thanks to the DateAdd function and SQL UPDATE command. Mary Ann Richardson walks through an example to demonstrate this technique. by Mary Ann Richardson
- Tags: Microsoft Access, SQL, Microsoft Office, Databases, Programming Languages, Office Suites, Software, Enterprise Software, Data Management, Software Development, Software/Web Development, Mary Ann Richardson
- Blog posts 2008-09-16
- Create a title style in Word to save time and mouse clicks
- It's easy to define a custom style for your document titles -- and it will greatly simplify the task of formatting title text. Mary Ann Richardson explains how to do it. by Mary Ann Richardson
- Tags: Mouse, Title, Mary Ann Richardson, Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software
- Blog posts 2008-08-19
- Transfer data from a Word form to an Access table using the Import Text Wizard
- When you've collected info via a Word form, you don't have to manually enter it into Access. Mary Ann Richardson steps through an example that demonstrates the wizard way to knock out the task more efficiently and accurately. by Mary Ann Richardson
- Tags: Microsoft Word, Microsoft Access, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
- Blog posts 2008-09-23
- Use color to flag Access form fields
- Colorizing a form field can bring important data to your notice. Mary Ann Richardson details a trick that tells Access to change the color of a field depending on its value. by Mary Ann Richardson
- Tags: Microsoft Access, Mary Ann Richardson, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Blog posts 2008-08-19
- Use Word bookmarks to make addressing envelopes a snap
- Word offers special bookmarks that let you automate the process of addressing your envelopes. Mary Ann Richardson explains this handy feature. by Mary Ann Richardson
- Tags: Mary Ann Richardson, Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software
- Blog posts 2008-09-09
- Use Excel's Lookup functions to search a database
- With the help of Excel's Lookup functions, you can build a worksheet that will enable you to search a database table. Mary Ann Richardson steps you through the process. by Mary Ann Richardson
- Tags: Database, Cell, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2008-06-16
- Quickly add special formats to Word with Find and Replace
- Use Word's Find and Replace command to add a specially formatted word or phrase to your text instead of formatting each instance of the word or phase individually. Mary Ann Richardson lets us in on the secret to special formats. Last week, Mary Ann Richardson showed us how to...
- Tags: Microsoft Word, Microsoft Office, Mary Ann Richardson, Word processors, XYZ Inc., Microsoft Office Suite Word Tips Newsletter, Replace, Company Logo, Office Suites, Software
- Technical articles 2006-03-28
- Hide Excel's error values in your printout
- If you print out a spreadsheet only to find that it contains error codes you would prefer to keep hidden, there's a way to avoid this from happening in the future. With this Excel tip from Mary Ann Richardson, learn how to keep the errors where they belong—on the screen,...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, PRODUCTIVITY, Microsoft Office Suite Excel Tips Newsletter, Spreadsheet, Error, Office Suites, Software
- Technical articles 2006-06-26
- Ensure images fit within the boundaries of your Access report
- This Access tip from Mary Ann Richardson explains how to make an image fit within the boundaries you set—even if you change the boundary. When you add an unbound picture or graphic to an Access report, you want the entire image to fit within the boundaries you set....
- Tags: Microsoft Access, Microsoft Office, Mary Ann Richardson, image, Microsoft Office Suite Access Tips Newsletter, Boundary, Databases, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2006-06-13
- << Previous
- page 1 of 1
- Next >>
