susan harkins

Downloads

A simple solution for tracking changes to Access data

March 13, 2007 12:00am PDT

When you have a lot of users changing data, it's easy for things to go wrong. But if you keep an audit trail of data input changes, you'll be able to determine which operators are consistently...

Provided by: Susan Harkins

Blog Post

10+ tips for designing flexible and efficient Access tables

March 8, 2007 8:00am PST

The way you build your Access tables makes all the difference in the world in terms of performance and reliability. These tips will help ensure an optimum table design.

Articles

10+ tips for designing flexible and efficient Access tables

March 8, 2007 8:00am PST

The way you build your Microsoft Access tables makes all the difference in the world in terms of performance and reliability. These concise guidelines explain how to effectively employ Access...

9 Latest comment by access@...

Downloads

10+ tips for designing flexible and efficient Access tables

March 8, 2007 12:00am PST

The way you build your Microsoft Access tables makes all the difference in the world in terms of performance and reliability. These concise guidelines explain how to effectively employ Access...

Provided by: Susan Harkins

Articles

How do I... Enforce domain integrity for SQL Server data using CHECK constraints?

March 5, 2007 8:00am PST

Even simple errors in data can result in huge problems. Luckily, you can eliminate at least some of those errors by using CHECK constraints to force users to enter data that meets specific conditions.

6 Latest comment by burkazoid2005@...

Blog Post

10 tricks for working more efficiently in Microsoft Outlook

February 23, 2007 11:08am PST

Outlook offers some powerful features for managing your e-mail, meetings, and contacts. The problem is, it offers so much that learning to use it all efficiently can take time. Some options are...

2 Latest comment by ErikaLambert

Articles

10 tricks for working more efficiently in Microsoft Outlook

February 23, 2007 8:00am PST

Outlook's extensive feature set stymies a lot of users. They learn a few survival skills on the fly (how to send e-mail, how to enter contacts) but don't take full advantage of Outlook's...

8 Latest comment by croc__7@...

Downloads

10 tricks for working more efficiently in Microsoft Outlook

February 23, 2007 12:00am PST

Outlook's extensive feature set stymies a lot of users. They learn a few survival skills on the fly (how to send e-mail, how to enter contacts) but don't take full advantage of Outlook's...

Provided by: Susan Harkins

Articles

How do I... Print a single Microsoft Access record in Form View?

February 20, 2007 8:00am PST

Microsoft Access lets users print data while browsing records in Form View, but it prints all of the records in the underlying recordset, not just the current one. By adding a command button and...

22 Latest comment by greenhart

Downloads

How do I... Print a single Microsoft Access record in Form View?

February 20, 2007 12:00am PST

Microsoft Access lets users print data while browsing records in Form View, but it prints all of the records in the underlying recordset, not just the current one. By adding a command button, you...

Provided by: Susan Harkins

Articles

10 tips for using wildcard characters in Microsoft Access criteria expressions

January 30, 2007 8:00am PST

Wildcards come in handy when you need to locate records with similar data or you're trying to track down a specific record based on limited information. But if you don't use the right wildcard...

7 Latest comment by kevinowpb

Downloads

10 tips for using wildcard characters in Microsoft Access criteria expressions

January 30, 2007 12:00am PST

Wildcards come in handy when you need to locate records with similar data or you're trying to track down a specific record based on limited information. But if you don't use the right wildcard...

Provided by: Susan Harkins

Articles

10 tips for customizing menus and toolbars in your Access apps

January 3, 2007 8:00am PST

When you build an Access application, you'll generally want to tailor the menus and toolbars so that users have all the tools they need but won't stumble over the built-in options. These tips will...

9 Latest comment by frz@...

Downloads

10 tips for customizing menus and toolbars in your Access apps

January 3, 2007 12:00am PST

When you build an Access application, you'll generally want to tailor the menus and toolbars so that users have all the tools they need but won't stumble over the built-in options. Access expert...

Provided by: Susan Harkins

Book Chapters

Administer SQL Server 2005 Express Edition

December 6, 2006 12:00am PST

SQL Server Express is a free, easy-to-use, simple-to-manage database without many of the features of the full-blown SQL Server, but powerful and flexible enough to meet the needs of low-end...

Provided by: Sybex

Articles

How do I... Generate a running total in an Access query?

December 4, 2006 8:00am PST

There's no built-in way to generate a running total in your Access queries, but you can still get the job done if you set up your table correctly and build the right expression. Database expert...

8 Latest comment by maggioant

Articles

10 tips for working with dates in Microsoft Access

November 13, 2006 8:00am PST

Despite the Date/Time data type and a selection of functions for manipulating date values and components, handling dates in Access is often a little tricky and nonintuitive. These tips will help...

13 Latest comment by RHinesBTS

Downloads

10 tips for working with dates in Microsoft Access

November 13, 2006 12:00am PST

Despite the Date/Time data type and a selection of functions for manipulating date values and components, handling dates in Access is often a little tricky and nonintuitive. Database expert Susan...

Provided by: Susan Harkins

Book Chapters

Use Visual Basic 2005 Express Edition to develop custom applications that link to an SQL Server Express database

November 8, 2006 12:00am PST

SQL Server Express is an innovative database product that combines power, flexibility, ease of use, and no cost, as well as the ability to develop custom applications using Visual Basic Express....

Provided by: Sybex

Articles

10 tips for sorting, grouping, and summarizing SQL data

November 6, 2006 8:00am PST

Arranging SQL data so that you can effectively analyze it requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure out how to build statements...

4 Latest comment by nil_arg@...