Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 10+ tips for upsizing an Access database to SQL Server
- When the time comes to migrate your Access database to SQL Server, you could be in for a bumpy ride. These suggestions will help you sidestep problems -- or at least wrestle them into submission. by Susan Harkins
- Tags: Function, Microsoft Access, Microsoft SQL Server, Server, Column, SSMA, NULL, MMSA, Susan Sales Harkins, Databases, Microsoft Office, Enterprise Software, Software, Data Management, Office Suites, Susan Harkins
- Blog posts 2008-07-31
- Create a custom letterhead template in Word
- Printing your own stationery can save you significant bucks -- you can print on an as-needed basis and make changes whenever you want without incurring any charges. Here's what you need to know about using Word to set up a letterhead template. by Susan Harkins
- Tags: Page, Margin, Template, AutoShape, Susan Sales Harkins, Document Management, Microsoft Word, Word Processors, Printers, Microsoft Office, Enterprise Software, Software, Finance, Managerial Accounting, Office Suites, Hardware, Peripherals, Susan Harkins
- Blog posts 2008-07-30
- 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+ 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
- 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 ways to prevent Access database corruption
- By Susan Sales Harkins and Gustav Brock Nothing frustrates the full spectrum of Access users -- from casual user to developer -- quite like a corrupted database. With a little know-how, you might get lucky enough to repair the database or at least recover the data. Sometimes,...
- Tags: Microsoft Access, Workstation, Network, Data, Susan Sales Harkins, Storage, Databases, Hardware, Enterprise Software, Software, Data Management, Susan Harkins
- Blog posts 2008-04-01
- How do I... Display multiple values in an Access value list control?
- The title's a mouthful, but don't get too hung up on the terminology. The technique is simple, although not commonly implemented. You can populate a Microsoft Access list control with an explicit list of values and generally that list consists of one column, although you can display more. Creating a...
- Tags: Technique, Data Source, Microsoft Access, Property, Column, Difference, Form, Title, GetString Method, Susan Sales Harkins, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Susan Harkins
- Blog posts 2008-01-23
- 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+ 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
- Return to the record you were working on when you reopen an Access form
- If you get interrupted while working on a record in an Access form, finding your way back to it can be time-consuming. Here are two ways to bookmark the current record so that you can hop straight to it when you reopen the form. by Susan Harkins
- Tags: Microsoft Access, Command Button, Record, Form, varID, OrderID, vbOKOnly, Sub, Susan Sales Harkins, Databases, Microsoft Office, Storage, Enterprise Software, Software, Data Management, Office Suites, Hardware, Susan Harkins
- Blog posts 2008-08-28
- Keep supporting details handy for your PowerPoint presentations
- When someone raises a question during your presentation, you can try to wing it -- or you can smoothly bring up an ancillary slide that clarifies the issue. Having a few extra slides up your sleeve can make all the difference in the success of your delivery. by Susan Harkins
- Tags: Slide, Microsoft PowerPoint, PowerPoint Presentation, Presentation, Hyperlink, Default Button, Susan Sales Harkins, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-08-29
- Generate a descending-order numbered list in Word
- Word can't automatically produce a numbered list that counts down instead of up. But with the help of a bookmark and some fields, you can work around that limitation. by Susan Harkins
- Tags: Item, Field, List, Value, Numbered List, SEQ, Insert, F9, Susan Sales Harkins, Microsoft Word, Word Processors, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-09-25
Additional Resources
- Encourage IT consulting clients to call before acting
- Susan Harkins shares a story in which a fellow IT consultant's client reinstalled Windows Vista and lost everything on the system. She details how easy it would have been to just reset the password. by Susan Harkins
- Tags: Password, Disk, Information Technology, Microsoft Windows Vista, Consulting, Admin Account, Microsoft Windows Vista (Longhorn), Operating Systems, Microsoft Windows, Software, Susan Harkins
- Blog posts 2008-10-06
- 10 ways to get more mileage from your Office hyperlinks
- Hyperlinks are now a standard fixture in Office documents, but many users don't know much beyond how to click on them. Susan Harkins has rounded up an assortment of tweaks for fine-tuning the behavior of hyperlinks and using them for specialized tasks. by Susan Harkins
- Tags: Hyperlink, Link, Web Browser, Hyperlinks, Susan Harkins, ScreenTip, Web Browsers, Microsoft Office, Microsoft Outlook, Internet, Office Suites, Software
- Blog posts 2008-09-29
- 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+ tips for combating Computer Vision Syndrome
- Recent studies indicate that those who spend even a few hours a day working on a computer could suffer significant vision problems. Susan Harkins offers an overview of symptoms and causes and then shares some practical suggestions for reducing eyestrain. by Susan Harkins
- Tags: Monitor, Computer, Susan Harkins, Productivity
- Blog posts 2008-09-18
- 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
- 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
- How do I... Share a PowerPoint presentation for comments and changes?
- Most of us don't have the creative expertise to create a professional presentation without a little help. Microsoft PowerPoint's advanced reviewing tools make it easy for everyone to collaborate at their convenience. Susan Sales Harkins shows you how to use these PowerPoint tools to your advantage.
- Tags: Microsoft PowerPoint, PowerPoint Presentation, Susan Harkins, Microsoft Office, Productivity, Office Suites, Software
- Download resources 2008-02-27
- How do I... Add items to an Access combo box on the fly?
- On occasion, an application developer working with Microsoft Access may need a list control that's a bit more flexible by allowing users to update the control's list. Handing over a bit of control, in the right circumstances, can be helpful for everyone, including you. Susan Sales Harkins shows you how...
- Tags: Microsoft Access, Control, Microsoft Office, Sales Strategy, Databases, Office Suites, Software, Sales, Enterprise Software, Data Management
- Download resources 2008-02-07
- << Previous
- page 1 of 1
- Next >>
