1. Technology

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.

Databases Spotlight10

Queries Using Multiple Tables in Access 2013

One of the primary benefits of using Microsoft Access is having the ability to pull data regardless of where it is saved within the database, especially if it is spread over half a dozen tables.

Saving Queries in Access 2013

After making tweaks and changes to a query, it can be difficult to remember exactly what changes pulled which results. This is one very good reason to get accustomed to saving queries with some frequency, even if they don’t provide exactly what the user is looking for at the time.

Printing Query Results in Access 2013

Access offers users a way to print queries and their results. This provides users with a way to later review the results if they cannot remember which query was used.

Indexing Access 2013 Tables

Tables can be indexed, giving the user the power to execute sorts and finds in a manner that is faster and more efficient for fields that are frequently searched

Filtering Data in Access 2013

Microsoft Access 2013 includes filters that pull specific information instead of users having to muddle through countless records.

Copying, Renaming and Deleting Tables in Microsoft Access

Copying, renaming and deleting tables in Microsoft Access often causes confusion for database administrators. In this article, we clarify the differences between the three operations and explain how to perform each.

INTERSECT Statements in SQL

Access Upsizing Wizard

SQL Server Stored Procedures

PCI DSS and Your Database

You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

©2014 About.com. All rights reserved.