Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Tip: Avoid trouble with Word tables
- Word's table feature is easy to use and intuitive enough that most of us can insert a table without too much going wrong. The quickest way to create a table in Word is to enter the table's headings or the first row of items, tabbing just once between each item....
- Tags: Uncategorized
- Blog posts 2007-07-06
- Warning: New Outlook Patch Email a Fraud
- Thanks to Ben Camm-Jones at WebUser for this warning. A new scam is a foot. If you receive an email warning about an Outlook vulnerability and guiding you to download a patch, don't fall for it.I've not received the email myself and I don't have any more details than those...
- Tags: Uncategorized
- Blog posts 2007-06-27
- Tip: Hide sensitive data in Access
- Anyone who works extensively with Access knows that it's weak on security. Nothing Access offers will deter a determined hacker. That's just a quick warning—if you're working with top-secret data, Access might not be the database for you.If your security needs are simple, Access offers a number of easy-to-implement security...
- Tags: Uncategorized
- Blog posts 2007-06-21
- How-to change perspective in an Excel chart
- Oh my, I had no idea you could do this with an Excel chart! What am I raving about? You can reverse the order of the axis values. You have to see this in action to appreciate it. First, look at a simple column graph that compares sales for the...
- Tags: Uncategorized
- Blog posts 2007-06-14
- How to Disguise Hyperlinks in PowerPoint
- Every product seems to underline hyperlinks by default, which is a good visual clue that the text is actually a link. However, in a PowerPoint presentation that you're controlling, I find the format a bit distracting. I can't help wondering if the audience is thinking more about what's behind the link...
- Tags: Uncategorized
- Blog posts 2007-06-02
- Tip: Like-magic Ctrl+z
- Some of the simplest tips are also the best. Years ago, I learned a simple keyboard shortcut that can undo the last action—Ctrl+z. It’s similar to the Undo Typing feature, but allows you to keep your hands on the keyboard. Initially, it doesn’t seem like such a big deal, but...
- Tags: Uncategorized, Microsoft Office
- Blog posts 2007-05-10
- Basic Training on Office 2007 Ribbons
- Given the enthusiastic response to Jodys post on the Office 2007 Ribbon interface, I thought some of you might need a bit more help getting started. Microsoft has a short training program online: http://office.microsoft.com/en-us/getstarted/FX101938921033.aspxYou can click through an introduction or review a demo.
- Tags: Uncategorized, Office 2007
- Blog posts 2007-05-08
- Latest Office Update
- Office XP users should know that there’s a new Service Pack out—Office XP Service Pack 3 (SP3). Like most service packs, it includes security enhancements and other improvements. Now, if you have a resident IT or computer specialist who maintains your system, you probably don’t need to worry about this—they’ll...
- Tags: Uncategorized, Microsoft Office
- Blog posts 2007-05-08
- Comments are an easy way to attach information to your data. Unfortunately, they often block data in adjacent cells. You can hide them, but that’s counter-productive. Still, having comments pop up as you browse a spreadsheet can be annoying. One easy-to-implement solution is to make the comment’s background transparent. Youll...
- Tags: Uncategorized
- Blog posts 2007-04-17
- Good Indexing May Improve Database Performance
- Tons of data, complex calculations, busy forms, and even network traffic impact a database’s performance. Your first line of defense against poor performance is a good design that includes appropriate indexes. An index is an underlying structure that determines how Access stores and retrieves data. By default, Access applies an...
- Tags: Uncategorized
- Blog posts 2007-04-15
- Use Styles to Your Advantage
- Word provides many features for managing large documents. For instance, you can automate a table of contents or an index. Anybody working with large documents already knows the value of clicking a few buttons and having Word produce an index, as if by magic. In addition, keeping up with footnotes...
- Tags: Uncategorized
- Blog posts 2007-04-11
- Don't Ignore the My Places bar
- One of my favorite short cuts is the My Places bar, although I wish Microsoft would stop prefacing everything with “My.” The pronoun isn’t friendly; it’s juvenile. Despite its name, the bar is a great timesaver once you customize it. The My Places bar first appeared in Office 2000. It’s...
- Tags: Uncategorized, Microsoft Office
- Blog posts 2007-04-08
Additional Resources
- 10+ reasons to use Access (and a few reasons not to)
- Microsoft Access may not be the king of databases, but it does offer a number of advantages over solutions like SQL Server and Oracle in certain situations. Access guru Susan Harkins counts the ways. by Susan Harkins
- Tags: Microsoft Access, Microsoft SQL Server, Susan Sales Harkins, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
- Blog posts 2008-08-15
- 10+ mistakes to avoid when using VBA Recordset objects
- The Recordset object is an essential component in Access development, but it often trips up even experienced developers. Susan Harkins explains 12 common Recordset pitfalls you can anticipate and avoid. by Susan Harkins
- Tags: Method, Property, Microsoft VBA, Library, Data Access, Record, Error, Susan Harkins, ActiveX Data Objects, EOF, RecordCount, MoveNext
- Blog posts 2008-06-25
- 10+ ways to help your users transition to Word 2007
- If you're one Word 2007 support call away from a nervous breakdown, these tips may help. Susan Harkins addresses the most common areas of confusion and offers practical advice for helping users conquer the steep learning curve. by Susan Harkins
- Tags: Command, Microsoft Word 2007, Tab, Susan Harkins, Ribbon Word 2007, Commands, Word 2007 File, Docx, Docm, Dotx, Dotm, Susan Sales Harkins, Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software
- Blog posts 2008-08-26
- 10+ reasons why IT pros hate Microsoft Access (but really shouldn't)
- Microsoft Access may not be right for all situations, but it does have its place -- at least according to database expert Susan Harkins. Here's her take on some of the more common complaints she's encountered from IT pros who like to kick Access around. by Susan Harkins
- Tags: Microsoft Access, Information Technology, Microsoft Corp., Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
- Blog posts 2008-07-24
- How do I... Reseed a SQL Server identity column?
- Microsoft SQL Server's identity column generates sequential values for new records using a seed value. Seeding and reseeding an identity column is easy and relatively safe, if you do it correctly. Susan Sales Harkins shows you how it works. by Susan Harkins
- Tags: Microsoft SQL Server, Server, Column, Value, Identity, Table, Identity Column, Seed Value, Term Seed, TRUNCATE TABLE, Susan Sales Harkins, Databases, Enterprise Software, Software, Data Management, Susan Harkins
- Blog posts 2008-07-15
- 10+ things that are broken in Access 2007
- If you switch to Access 2007, you'll encounter more than just a radical new interface. As Susan Harkins explains, some things are just plain broken. See what you can hotfix and what you'll have to live with. by Susan Harkins
- Tags: Microsoft Access, Field, Access 2007, Memo, Microsoft Office Access, Susan Sales Harkins, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
- Blog posts 2008-06-30
- 10+ tips for getting the best performance out of your SQL Server data types
- Using the right data type can go along way toward minimizing problems and optimizing performance. Susan Harkins offers these practical tips to help you avoid getting bogged down by inappropriate data types. by Susan Harkins
- Tags: Performance, Microsoft SQL Server, Server, Column, Data Type, Susan Harkins, NULL, Susan Sales Harkins, Databases, Enterprise Software, Software, Data Management
- Blog posts 2008-07-10
- Don't risk a slide show nightmare: Save fonts with your PowerPoint presentations
- If you deliver a presentation on a system that doesn't have your slide show fonts installed, you could wind up with a font substitution mess. Susan Harkins shows how to save fonts with the presentation -- and how to find that elusive option in PowerPoint 2007. by Susan Harkins
- Tags: Microsoft PowerPoint, PowerPoint Presentation, Font, Susan Harkins
- Blog posts 2008-08-11
- << Previous
- page 1 of 1
- Next >>
