1. Home
  2. Computing & Technology
  3. Databases

Keys and Transactions

As you may already know, databases use tables to organize information. Each table consists of a number of rows, each corresponding to a single database record. So, how do databases keep all of these records straight? It's through the use of keys.

Additional Resources

Mike's Databases Blog

Accounting Ledger Database Template for Microsoft Access

Thursday July 24, 2008
The Accounting Ledger Database Template for Access 2003 allows you to create a basic chart of accounts and transaction ledger. It's available for free from the Microsoft Access Templates library.

Download the Accounting Ledger Database Template.

Joining Data from Three or More Tables with an SQL INNER JOIN

Tuesday July 22, 2008
You can use SQL JOIN statements to combine data from three or more tables. In an earlier article, we took a look at using inner joins and outer joins to combine data from two different tables. In many cases, you’ll want to take this a step further and combine data from three or more tables. In Joining Multiple Tables with SQL Inner Join Statements, we look at the SQL statements that allow you to accomplish this goal for an inner join.

Read the full article: Joining Multiple Tables with SQL Inner Join Statements

Explore Databases

More from About.com

  1. Home
  2. Computing & Technology
  3. Databases

©2008 About.com, a part of The New York Times Company.

All rights reserved.