Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 10 tips for working more efficiently in Excel
- Excel is so powerful that nobody knows everything about it. If you use Excel frequently, you probably run into situations, from entering data to calculating complex workbooks, that slow you down. The following tips won't solve unique problems, but they will help you complete common tasks more efficiently.This entry originally...
- Tags: Tips, Support, Shortcuts, 10 things
- Blog posts 2007-04-12
- 10+ tips for designing flexible and efficient Access tables
- Access stores one of your most important assets--your data--in tables. Now, truthfully, the table you see onscreen is just a graphic representation, but you use this representation to determine how the rest of your database uses and reacts to your data. For this reason, it's important to spend time up...
- Tags: Tips, 10 things
- Blog posts 2007-03-08
- 10 tips for designing flexible and efficient Access tables
- 10 tips for designing flexible and efficient Access tablesDo you already follow most of these design practices when you build your Access tables? What other pointers would you add to this list?A few additionsIf you are going for byte or word a
- Tags: software, design, 10 things, tables, susan harkins, Access Table, Microsoft Access, byte, JodyGilbert
- Discussion threads 2007-03-08
- 10 tricks for working more efficiently in Microsoft Outlook
- Do you see your users doing a lot of things the hard way in Outlook? What kind of questions come up most often and what tips do you routinely share with them?
- Tags: JodyGilbert, software, tips, microsoft outlook, 10 things, susan harkins, Microsoft Corp.
- Discussion threads 2007-02-23
- 10 tips for using wildcard characters in Microsoft Access criteria expressions
- 10 tips for using wildcards in Microsoft Access criteria expressionsDo you frequently use wildcard characters to locate records in Microsoft Access? What other tips would you add to this list?
- Tags: Microsoft Access, JodyGilbert, software, data, 10 things, wildcards, susan harkins, Microsoft Corp.
- Discussion threads 2007-01-30
- 10 tips for customizing menus and toolbars in your Access apps
- How much do you customize the interface when creating an Access application? What tips or suggestions would you add to this list?
- Tags: 10 things, access, customization, development, JodyGilbert, Microsoft Access, software, susan harkins, toolbar
- Discussion threads 2007-01-03
- 10 tips for working with dates in Microsoft Access
- Have you sometimes run into problems with unexpected or unwanted results involving dates in Access? What other tips/shortcuts have you found useful when it comes to working with dates?
- Tags: susan harkins, dates, 10 things, data, access, software, JodyGilbert, Microsoft Corp., Microsoft Access
- Discussion threads 2006-11-13
- 10 tips for sorting, grouping, and summarizing SQL data
- Do these tips help clarify some of your options when it comes to arranging SQL data? What other suggestions or techniques would you add to the list?YesI work with sql on a daily basis. but, a lot of it is overly simplified. This will be a good
- Tags: susan harkins, query, 10 things, database, software, JodyGilbert, SQL, OrderNumber
- Discussion threads 2006-11-06
- 10 tricks for handling null values in Microsoft Access
- Have you ever run into problems caused by someone who neglected to accommodate null values? Are there any additional situations where you've had to work around or proactively handle null values to prevent errors?HmmWhere not(source.field) is null
- Tags: 10 things, JodyGilbert, Microsoft Access, Microsoft Corp., Null, software, sql, susan harkins
- Discussion threads 2006-10-12
Additional Resources
- 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+ 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
- 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.This download is also available as an entry in our 10 Things blog.
- Tags: Microsoft Access, Susan Harkins, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Download resources 2008-06-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+ 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.This download is also available as an entry in our 10 Things blog.
- Tags: Microsoft Access, Susan Harkins, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Download resources 2008-08-15
- 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.This download is also available as...
- Tags: Microsoft Access, Information Technology, Microsoft Corp., Susan Harkins, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management
- Download resources 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
- << Previous
- page 1 of 1
- Next >>