Database Software

How to Keep Track of Changes in Excel 2003

By eHow Computers Editor

0 comments

If several people are working on the same Excel document, it helps to keep tabs on what has been changed and by whom. Tracking changes in Excel is simple. Learn how to do it in a few short steps... more »

How to Look Up Values From One Table and Automatically Insert Them in Another Table in Access 2003

By eHow Computers Editor

0 comments

An append query automatically looks up fields that you select in one table and attaches them to another table within the database. Be careful though--once you make the attachment you cannot easily undo it... more »

How to Partition a Hard Drive with Windows XP

By deepthinkin

0 comments

Partitioning a hard drive is a fairly simple operation with the utility tool already installed on Windows XP. However, if you have difficulty finding the desktop on your computer, you’ll want to leave this job to someone with a little more ... more »

How to Prevent Duplicate Values in a Microsoft Access Database

By eHow Computers Editor

0 comments

You can keep your Microsoft Access database free of confusing clutter by preventing duplicate values. These instructions are for Access 97... more »

How to See The Hidden Files In Any PC

By jaindinu

2 comments

This article will help you to see all the hidden files of any pc. Its common to hide files by clicking "do not show the hidden files option" in the tools ----> folder options. But most of them dont know that by clicking "show ... more »

How to Sort a Row or Column in Excel 2003

By eHow Computers Editor

0 comments

Excel is one of the most widely used programs on home and office computers. Even so, improvements are being made for each new edition. Follow the steps below to sort a row or column in Excel 2003:.. more »

How to Understand Cascading Updates or Cascading Deletes in Microsoft Access

By eHow Computers Editor

0 comments

You can automatically update or delete related records from various MS Access tables by using cascading updates or cascading deletes. These instructions are for Access 97... more »

How to Understand Referential Integrity in Microsoft Access

By eHow Computers Editor

1 comments

You can ensure that relationships between records in related tables are valid by enforcing referential integrity in Microsoft Access. For example, if referential integrity is enforced, you will not be allowed to delete a record from your Customer ... more »

How to Use an Access 2007 Lookup List

By eHow Computers Editor

0 comments

A lookup list in Access 2007 is a column in a table whose values are retrieved from another table or query. They are frequently used to display a list of choices in a combo or list box. A lookup list may be created manually but you should use the ... more »

How to Use Cascading Updates or Cascading Deletes in Access 2003

By eHow Computers Editor

0 comments

If you have defined relationships between tables in an Access 2003 database, you can use cascading updates or cascading deletes to propagate changes across all the tables with that relationship. Once you have the cascade enabled, changes that you ... more »

How to Add Data to a Microsoft Access Table

By eHow Computers Editor

0 comments

This is how you get your information into a database table you've set up. These instructions work for Access 97... more »

How to Align Text in Cells in Excel 2003

By eHow Computers Editor

0 comments

You must properly align the text in your Excel 2003 spreadsheets so that readers can follow the information it contains. To clarify your spreadsheets, follow these steps... more »

How to build a basic income statement model in excel

By Chap

0 comments

Building a basic P&L model is really quite simple. With a working knowledge of excel and how a company operates its business you can project future revenues and profitability... more »

How to Choose Database Software

By eHow Computers Editor

0 comments

Database programs store, sort, categorize, import and export data. Businesses use them for products, prices, mailing lists, personnel, customer information and other data. At home, you might use a database for personal inventories such as a ... 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 Date/Time Field in Access 2003

By eHow Computers Editor

0 comments

Having a Date/Time field would be useful sometimes, if not necessary in an Access 2003 record. It makes it easier to calculate the number of days between two different dates and to add hours to a time to calculate a new time. Follow these steps ... more »

How to Create a Microsoft Access Query That Uses More Than One Table

By eHow Computers Editor

0 comments

You can use queries to display information from a combination of tables. For example, suppose you have one table that lists the books available in a library. A second table contains information about the registered users. By creating a query ... more »

How to Create a Parameter Query in Access 2003

By eHow Computers Editor

0 comments

Queries help you to quickly look up information on an Access 2003 document. There are many different types of Queries. When you are looking for information that meets specific criteria then you want to create a Parameter Query in Access 2003... more »

How to Create a Select Query in Access 2003

By eHow Computers Editor

0 comments

Select queries retrieve data from other fields and can sum, count or average values as well. Initiate a select query in Access 2003 using the wizard, or follow these steps to create one... more »

How to Create a Simple Budget in Excel 2003

By eHow Computers Editor

0 comments

Using Excel 2003 to keep track of your home finances is an easy and simple alternative to the pencil and paper method used in many households. You can keep track of your expenditures, your credit card balances and even make a budget. Here is how ... 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 a SQL Query in Microsoft Access

By eHow Computers Editor

0 comments

SQL queries use Structured Query Language (SQL), a standard scripting language, to make requests from databases. You can use four types of SQL queries in Access 97: union, pass-through, data-definition and subquery... more »

How to Create a Table Using SQL in Microsoft Access

By Keith Johnson

0 comments

Although, it may be simpler to create a table using design view in Microsoft Access, it’s useful to know how to create one using SQL, too. Here's how... more »

How to Create an Append Action Query in Microsoft Access

By eHow Computers Editor

0 comments

With an Append action query, you can add a group of records from one or several tables to the end of one or more tables. You might do this if you acquire a new database of information that is pertinent to one or more of your tables. Appending the ... 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 »

Check Out All Categories

Articles in Database Software