Database Software

How to Create a New Database From Scratch in Access 2003

By eHow Computers Editor

0 comments

Microsoft Access 2003 is a great program for making and managing databases of all kinds. You can create new databases manually or by using the Database Wizard feature. If you don't want to use the Database Wizard, here's how to create a new ... more »

How to Create a Report in Access 2003

By eHow Computers Editor

0 comments

Creating a report in Access 2003 requires some familiarity with the information you'll be assembling. For instance, will you need more than one table? Apart from that, the process is easy... more »

How to Create a Simple Budget in Excel

By eHow Computers Editor

0 comments

Let's face it - for most people, creating a budget is never fun. But at least with Excel it can be fairly easy. These steps work for Excel 97... 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 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 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 Link Data From Another Database in Microsoft Access

By eHow Computers Editor

0 comments

Linking data is similar to importing, but instead of placing a copy of the information into Access, you add a "link" to the external database. If you update the information in the external program, the changes appear in Access as well. Linking is ... more »

How to Make Your Windows XP Genuine.

By jaindinu

0 comments

This artcile will help you in making your windows xp genuine. Try this............. 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

0 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 Subtotals and Totals in an Excel Spreadsheet

By eHow Computers Editor

0 comments

Use Excel to automatically calculate subtotals and totals in your plans and budgets. These steps work for 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 Add Speaker Notes to a Presentation in PowerPoint 2003

By eHow Computers Editor

1 comments

Do you get nervous while giving presentations? Does your tongue get twisted or do you often forget what you were about to say? Adding speaker notes to a presentation in PowerPoint 2003 can help you feel more relaxed when giving a presentation. ... 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 Formula in Excel 2003

By eHow Computers Editor

0 comments

You already know that an Excel spreadsheet is a great place to keep a budget, track your caloric intake and perform a multitude of other activities involving numbers. You can easily amp up your worksheet by using formulas to do all sorts of ... more »

How to Create a Microsoft Access Form Based on More Than One Table

By eHow Computers Editor

1 comments

You can view or enter data into multiple tables using one form. For example, if you are a potter, you could create a form that shows information from both your Galleries table and your Pottery table. Forms showing data from more than one table ... more »

How to Create a New Database From Scratch in Microsoft Access

By eHow Computers Editor

3 comments

If you don't want to use the Database wizard, you can create your own database from scratch. These instructions work for Access 97... more »

Check Out All Categories

Articles in Database Software