Database Software

By eHow Computers Editor

1 comments

Building a database with MS Access is not difficult, but it can be confusing. In order to build a working database, you must create the database file as well as a table to enter your information. By creating each item one at a time, you will be ... more »

How to Change a Field's Data Type in Access 2003

By eHow Computers Editor

0 comments

When you first design and build a database, you plan one or more tables, define the fields (columns) for each table and set a data type for each field. For example, if you need to store dates and times, you set a field to the Date/Time data type. ... more »

How to Convert Numbers to Dates in Microsoft Access

By Amicron

0 comments

If you have ever received a database from someone that has dates stored as six-digit numbers, like 990104, this lesson will teach you how to convert those to proper Access dates... more »

How to Create a Bar Graph From an Excel Spreadsheet

By eHow Computers Editor

1 comments

For most people, a picture is more compelling than columns of numbers in cells, so convert your spreadsheet to a bar chart or line graph. These steps are intended for Microsoft Excel 97... more »

How to Create a Make-Table Action Query in Microsoft Access

By eHow Computers Editor

0 comments

You can use a Make-Table action query in Microsoft Access to create a new table from all or part of the data in one or many tables. For example, you may want to use records from various tables to create a new table that will be exported to a ... more »

How to Create a Microsoft Access Field That Automatically Generates Numbers

By eHow Computers Editor

0 comments

You can create a field that automatically generates unique numbers for each record. AutoNumbers are the simplest way to set up primary keys, which are vital if you want to establish relationships among the various tables in your database. A ... more »

How to Create a Microsoft Access Query That Uses Multiple Criteria in One Field

By eHow Computers Editor

0 comments

Creating a query that uses multiple criteria for a field is like running a filter on your query results. For example, if you have a table that contains complete addresses of all your friends, you can run a query that will display brief ... more »

How to Create a Simple Query in Microsoft Access

By eHow Computers Editor

0 comments

By creating a simple query in MS Access, you can display field information in various ways. For example, suppose you have one table that contains extensive information about of all of your business contacts. However, for now, you just want to see ... more »

How to Create an Index in Microsoft Access to Sort Records Faster

By eHow Computers Editor

0 comments

Access uses an index in the same way that you would use an index in a book: to find information more quickly. Indexing fields that you frequently search can speed up sorts. You can index multiple fields or single fields. These instructions are ... more »

How to Create an Update Action Query in Microsoft Access

By eHow Computers Editor

1 comments

Use an Update query to make global changes to a group of records or to many tables at once. For example, if you have changed the price on a product you are selling, you could update all pricing records simultaneously. These instructions apply to ... more »

How to Create Mailing Labels Using Microsoft Works

By eHow Computers Editor

1 comments

If you want to make your next mass mailing a breeze, use a simple program like Microsoft Works to create and print your labels... more »

How to Create MS Access Report by Selecting Indv Record

By Crymson

0 comments

This article explains how to select an individual MS Access record, and generate a report... more »

How to Decide When to Use a Database Program

By eHow Computers Editor

0 comments

You can use a database program to store, sort, retrieve and display information stored as records. You might select a database program to keep track of addresses, recipes, customers' buying habits, music CDs, or any other collection of items. ... more »

How to Define a Date Format for a Microsoft Access Field

By eHow Computers Editor

0 comments

You can define the way your want your dates and times to appear in a MS Access field. The format affects how the information will be viewed or printed, but does not change how it is stored. These instructions apply to MS Access 97... more »

How to Define a Many-to-Many Relationship in Microsoft Access

By eHow Computers Editor

2 comments

In a "many to many" relationship, one record in either table can relate to many records in the other table. For example, in a library database, one record in your Titles table could relate to several records in your Borrower table, since several ... more »

How to Find the Sum of a Group of Cells in Excel 2003

By eHow Computers Editor

0 comments

One of the major functions of an Excel worksheet is performing mathematical functions. Adding the numbers within cells together is one of the most common Excel tasks. Find out how to do it... more »

How to Interpret Descriptive Statistics

By Paul McDaniel

0 comments

These steps will lead you through each of the basic descriptive statistics calculated by standard statistical analysis software such as SAS, SPSS, STATA, Excel, etc., and how to interpret them. Descriptive statistics (mean, median, mode, range, ... more »

How to Limit Data in a Microsoft Access Field to Certain Values

By eHow Computers Editor

0 comments

Limiting data in a field prevents entry errors. For instance, suppose you are selling towels in three colors - red, blue, and yellow. Limiting the data values to "red," "blue" or "yellow" will prevent people from mistakenly ordering pink towels. ... more »

How to Record an Excel Macro

By eHow Computers Editor

0 comments

A macro automates a complex task. Excel macros can perform complicated series of actions or simply record commonly used commands. These instructions apply to Excel 97... more »

How to Sort Microsoft Access Records Using Multiple Criteria

By eHow Computers Editor

0 comments

You can sort Microsoft Access records using more than one field. For example, in your address book, you might want to sort according to last name and given name in ascending order. Amy Smith would come before Bruce Smith in this type of sort. ... more »

How to Use an Input Mask to Control How Data Is Entered Into a Microsoft Access Field

By eHow Computers Editor

0 comments

Adding an input mask minimizes the likelihood that people will omit information or enter the wrong data by mistake. For example, you could create an input mask that would only permit the number and type of characters that are found in a telephone ... more »

How to Use Provided Excel Formulas

By eHow Computers Editor

1 comments

You don't need to be a math whiz to use complicated Excel formulas - a number of them are already provided for you. These steps work with Microsoft Excel 97... more »

How to Use the Wizard to Create a Crosstab Query in Microsoft Access

By eHow Computers Editor

0 comments

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... more »

How to Add a One-to-Many Database Relationship in Microsoft Access

By eHow Computers Editor

0 comments

Use Access relationships to search for and share data across multiple tables. For example, suppose you are a potter and want to keep track of your business operations. You could create one table to keep records of your pottery and a second table ... more »

How to Connect to SQL Server Through VB.net

By Mike

0 comments

SQL Server is a great database to use and easy to connect to using VB.net. Here is how you do it... more »

Check Out All Categories

Articles in Database Software