susan harkins

Articles

Making the decision to upgrade to Office 2003: Upgrading the Office core

May 12, 2003 7:00am PDT

Are you considering making the move to Office 2003? Find out about features, licensing, and what the new version can and can't add to your organization.

10 Latest comment by EriccS

Articles

Referencing command bar and control objects in Access

May 1, 2003 7:00am PDT

Consultants who design applications in Access are familiar with the Office Command Bar object model. Working with the command bar and controls can be frustrating. Here's a detailed look at...

7 Latest comment by lestertrad@...

Articles

Relational databases: Defining relationships between database tables

April 30, 2003 7:00am PDT

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

4 Latest comment by jrcondit@...

Articles

Relational databases: Achieving normalization

April 23, 2003 7:00am PDT

Even though your database design meets First Normal Form (1NF), you aren't finished yet. Find out how to apply the other normalization rules: 2NF, 3NF, and BCNF.

Articles

Demonstrate the value of accuracy to your data entry operators

April 17, 2003 7:00am PDT

Consultants and managers with data entry operators in their charge have a duty to provide proper training and motivation. Here are a variety of ways to help improve the accuracy of data...

5 Latest comment by cearl@...

Articles

Relational databases: Applying the First Normal Form

April 16, 2003 7:00am PDT

Just knowing the normal forms is not enough, you need to apply them to your database design. Find out how to apply First Normal Form as our database design series rolls on.

2 Latest comment by millerdq@...

Articles

Relational databases: Using normal forms to create databases

April 9, 2003 7:00am PDT

While you can create a database without understanding any design theory, it's best to learn a bit about normalization and how the normal forms are the keys to well-designed databases.

4 Latest comment by cderfv

Articles

Creating your first Web page with ASP.NET

April 8, 2003 7:00am PDT

If you're a classic ASP/ADO developer who hasn't started tinkering with .NET, this intro will help you get started. See how to use connection strings and server-side controls.

2 Latest comment by deepti.shetty@...

Articles

Relational databases: The inspiration behind the theory

April 2, 2003 8:00am PST

Who is Codd and why should you care? Discover the origins of the modern relational data model, how Codd helped develop the rules for relational database theory, and what every developer should...

13 Latest comment by cderfv

Articles

Use SQL to create a more friendly format for list items

April 1, 2003 8:00am PST

While it's versatile, the list box control for Microsoft Access doesn't have the formatting that users are accustomed to seeing. Here are two ways to create more familiar looking list items in Access.

4 Latest comment by macGold@...

Articles

Build Your Skills: Avoid problems with aggregate functions in Access reports

March 21, 2003 8:00am PST

Aggregate reports in Microsoft Access

5 Latest comment by saratogapete

Articles

Learn the differences between Is Null and IsNull() in Access

March 6, 2003 8:00am PST

How many null values exist? What is the difference between a null value and a blank entry? This article answers those questions and more by discussing what to look for when creating Access apps...

2 Latest comment by mark.j.breunig@...

Articles

Get IT Done: Using DTS and SQL Server Agent to schedule Access tasks

February 20, 2003 8:00am PST

Schedule tasks in Microsoft Access with SQL Server Agent and DTS

4 Latest comment by jillen04

Articles

The subtle differences between SQL Server Desktop and Access objects

February 18, 2003 8:00am PST

Once you make the move to SQL Server Desktop, you'll notice that most objects are different from Access objects, even if just a little. Here are a few SQL Server Desktop objects and how they...

4 Latest comment by tckim02@...

Articles

Allow users to send e-mail from inside Access

February 12, 2003 8:00am PST

The ability to send e-mail using the Access interface allows greater collaboration among your users. Although you'll have to plan the process, the user will have little to do but make a few...

2 Latest comment by jrb216_psu

Articles

Build Your Skills: Create connection-sensitive combo boxes in Access

February 6, 2003 8:00am PST

Build combo box controls in Access

34 Latest comment by macGold@...

Articles

SQL Server Desktop Engine: A realistic alternative to Jet

January 21, 2003 8:00am PST

For IT managers who are not comfortable with Access' somewhat unreliable nature, there's another choice: the SQL Server Desktop Engine. With this tool, you get the power and stability of SQL...

12 Latest comment by mwp.reid@...

Articles

Use XML in Access 2002 to generate Web-enabled reports

December 10, 2002 8:00am PST

Access 2002's ability to export data in XML format can come in handy when you have to create Web-ready files for viewing outside your client's office. Here's how this time- and sanity-saving tool...

13 Latest comment by ashok2

Articles

Microsoft Access could be the missing piece in your database solution

December 4, 2002 8:00am PST

Despite IT's general opposition to it, Access can be an excellent alternative to the larger database systems. Read up on some of the facts about Access, and find out why it may be the perfect...

78 Latest comment by brakamaric@...