www.ehow.com Tutorials

Spit Text and Splatters
My goal is to take you step-by-step through the process of creating a very unique, if not gross, style of photoshop text. Not only can you use this tutorial for text, but spit splatters and drips as well.

How to Remove the Primary Key
Remove the primary key only if you're sure you won't need relationships between the tables in your database. Remember, you can only run queries on tables that have been joined in a relationship. These instructions are for Access 97.

How to Use the Wizard to Create a Simple Data-Entry
A form provides an interface for entering data into a database. Forms can be easier to use than Datasheet view, especially if others are typing in your data. You can create a simple form with the wizard in seconds. These instructions are for Access 97.

How to Use the Wizard to Create a Crosstab Query
Crosstab queries make it easier to view records by displaying the information in a compact view similar to a spreadsheet. With the wizard, you just need to answer some questions to create the query. These instructions apply to Access 97.

Add Fields to a Table
Access 2003 can appear to be a very confusing and frustrating program to run, requiring multiple tables and views to use properly. Adding fields will often require you to use both Design View� and Datasheet View.� The following steps will help you to add fields to a table in Access 2003.

Add Controls to a Form in Access 2007
A control in Access 2007 is an object on a form that passes information between the user and the form. Common control types include labels, boxes and buttons. Adding a control to a form is common task and most forms in Access contain many controls. The following steps will show how to add controls to a form in Access 2007.

How to Do an Access 2007 Update Query
Access 2007 is a database program created by the Microsoft Corporation. It is an important part of the Microsoft office suite because it allows users to effectively track items, make professional reports and share information. Update queries allow users to update data in a set of forms or records. Doing a update query in Access 2007 only takes a few minutes when you have the correct information.

Link Data From Another Database
Linking data allows you to create and maintain one database that can be used simultaneously in different applications. Access will automatically create a database and link data from another open application.

How to Join Two Tables in a Relational Database
The power of a relational database such as Oracle, SQL Server, MySQL and Access is the ability to relate two or more tables based on common fields. Here is how you can join two tables on a common field. I am using MS Access's Northwind database to write the SQL statement.

How to Prevent Duplicate Values
You can keep your Microsoft Access database free of confusing clutter by preventing duplicate values. These instructions are for Access 97.

How to Edit Field Rules in Access 2007
Microsoft Access is an efficient platform to collect, store, connect and relate large amounts of data. The processes to utilize this software program can seem a bit overwhelming at times. Break down each process to make completing the larger task much easier.

How to Use BETWEEN
BETWEEN is useful when selecting data that falls within a specific range. Learn how to use this powerful Microsoft Access SQL keyword.

How to Create a Query in Microsoft Access Using the AND and OR Criteria
This quick and easy tutorial will explain the differences between using the “AND” and “OR” syntax in a basic query.

Set or Change the Primary Key
The Access application uses the primary key to identify each item in a database table. When you set or change the key, you modify the ID number that the program uses to match records from one table to another. Here's how to set or change the key.

How to Insert Data into an Access Database
This article assumes that you have already read my article on how to create an Access database. We are going to use that database for this example. Here are the steps.

Create an Update Action Query
Microsoft Access 2003 lets you create an append action query to merge tables at the end of one or more existing tables. Appending tables saves you the effort of retyping data. Follow these steps to create an append action query in Access 2003.

Create a Microsoft Query Using Gender and Currency
This article describes how to perform a query in Microsoft based on Gender and Currency.

How to create a Database
A database is a structured collection of records or data, stored on your computers' hard drive. Setting up a database helps you to organize, display, and share your data with others. Setting up a database may seem a daunting task but with Microsoft Access setting up your DB is not as complicated as it sounds. All you need is a little practise. Here's how you set it up.

Use the Wizard to Create a Find Duplicates Query
Use a Find Duplicates query to discover whether your tables contain duplicate records. With the wizard, creating the query is just a matter of answering some questions. These instructions apply to Access 97.

How to Create a Relationship Between Two Tables in Microsoft Access
Access is a quick easy to use database for the home and small business owner. You get plenty of functionality for small to medium sized applications. In Access you have the ability to visually join two tables creating a relationship on to common fields, normally referred to as indexes. Here is how it is done.