susan harkins

Downloads

10 tips for sorting, grouping, and summarizing SQL data

November 6, 2006 12:00am PST

Arranging data in a manner that's meaningful can be a challenge. Sometimes all you need is a simple sort. Often, you need more—you need groups you can analyze and summarize. Fortunately, SQL...

Provided by: Susan Harkins

Articles

10 tricks for handling null values in Microsoft Access

October 12, 2006 7:00am PDT

Null values indicate that data is missing or unknown, and if you don't take steps to handle them, you could wind up with runtime errors or erroneous data. These Access pointers will help you...

14 Latest comment by Tony Hopkinson

Downloads

10 tricks for handling null values in Microsoft Access

October 12, 2006 12:00am PDT

Null values indicate that data is missing or unknown, and if you don't take steps to handle them, you could wind up with runtime errors or erroneous data. These Access pointers will help you...

Provided by: Susan Harkins

Articles

How do I... Display summary values in Microsoft Access using UNION?

August 17, 2006 7:00am PDT

SQL's UNION operator lets you combine data from two or more tables or queries--but that's not all it can do. Here are some handy tricks for for using UNION to provide a quick-and-dirty display of...

2 Latest comment by Tony Hopkinson

Book Chapters

Create and manipulate Microsoft Access forms with VBA

November 14, 2005 12:00am PST

This sample chapter, taken from Automating Microsoft Access with VBA, discusses how manipulate Microsoft Access forms with VBA. Learn how to use VBA to work with forms in Microsoft Access.This...

Provided by: Que Publishing

Articles

Understanding roles in SQL Server security

October 11, 2004 2:09pm PDT

SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part...

10 Latest comment by phayman@...

Articles

Accommodating a many-to-many relationship in Access

July 30, 2004 7:00am PDT

You can take advantage of many-to-many relationships in your Access databases; it just requires a little extra work up front. This walk-through demonstrates a four-step process for creating an...

16 Latest comment by brharrii

Articles

Techniques for successfully importing Excel data into Access

July 23, 2004 7:00am PDT

Importing data from Excel to Access can be a little dicey, often resulting in missing information, incorrectly converted values, or data that's difficult to work with. These pointers will help you...

7 Latest comment by brigzy@...

Articles

Build Your Skills: Join syntax construction

February 2, 2004 8:00am PST

Building database joins requires a thorough understanding of the idiosyncrasies of each type. This article explains each type (inner, outer, cross, and self) and shows the syntax associated with each.

Articles

Build Your Skills: The underpinnings of SQL joins

January 30, 2004 8:00am PST

If a query retrieves the wrong data, the SQL join is an excellent place to begin troubleshooting. Thus, understanding SQL joins in database relationships is critical when problems arise. This...

3 Latest comment by BR-549

Articles

Define relationships between database tables

January 30, 2004 8:00am PST

Database normalization is the cornerstone of relational database theory. However, once a database is normalized, relationships between the data in multiple tables must be established.

7 Latest comment by Mphathi

Downloads

Access reference: Working with tables

January 28, 2004 12:00am PST

When users come to you with Access questions, it helps to have a resource you can refer to for quick answers. Susan Harkins has assembled those answers in an easy-to-read format, covering the...

Provided by: TechRepublic

Articles

TechRepublic Tutorial: Avoid errors by checking a form's closed/open status

December 1, 2003 8:00am PST

Determine a forms status before running SQL code

Articles

TechRepublic Tutorial: Use Windows to create a connection string

November 17, 2003 8:00am PST

Learn how to create ADO connection strings to data sources using a Windows dialog box

7 Latest comment by james.crowley@...

Articles

Quick Tip: Access report viewing is a snap using Snapshot Viewer

November 14, 2003 8:00am PST

Use Snapshot Viewer to create an Microsoft Access report

21 Latest comment by bdbhn_it@...

Articles

In T-SQL, use CASE...WHEN in place of IF...THEN

October 3, 2003 7:00am PDT

Add some flexibility to your program flow in T-SQL with the CASE...WHEN statement. Get a hands-on look at the statement's syntax and the advantages it can provide for your application.

9 Latest comment by YukYukYuk

Articles

Avoid a potential problem when searching for Null values with ADO

September 12, 2003 7:00am PDT

Searching for Null values in a database is a common query, but the way such a query is performed can be different depending on the environment. See how to avoid a problem stemming from a syntax...

Articles

Lock IT Down: Select the best authentication option for IIS

September 11, 2003 7:00am PDT

Criteria for selecting the best Windows NT security authentication for IIS Server

Articles

Use this handy function to determine an Access object's state and view

September 10, 2003 7:00am PDT

Manipulating an Access data object depends on its state and its view, but programmatically determining those attributes can lead to complications. Here's a library-level, generic function that...

Articles

Secure SQL Server: Application roles

September 9, 2003 7:00am PDT

When it comes to managing database security, at times you'd rather manage security for an application rather than for individual users. In SQL Server, this administrative flexibility is granted...

5 Latest comment by howeg