Database Software

How to Calculate, Interpret, and Understand the Index of Dissimilarity

By Paul McDaniel

0 comments

The index of dissimilarity is an indicator of just how much one group is spatially segregated from another group. It is used frequently by population geographers and demographers. The index of dissimilarity is the standard measure of segregation ... more »

How to Create a Delete Action Query in Access 2003

By eHow Computers Editor

0 comments

By creating a Delete Action Query in Microsoft Access 2003, you can automatically delete a group of records from one or several tables. For example, in your CD database, you could delete all records pertaining to a CD that you have thrown out. A ... more »

How to Create Relationships in Access 2007

By eHow Computers Editor

0 comments

A database should be designed to minimize data redundancy by dividing the data into tables so that each fact is only represented once. A relationship between tables allows Office Access 2007 to bring this data back together by displaying ... more »

How to display fractions with MS exel 2002

By Tweek45

0 comments

How to display fractions with Excel.. more »

How to Recover deleted files....

By jaindinu

1 comments

This article will certainly help those who want to know 'how to recover files after deleting from recycle bin'. Please do read this article which will help you in recovering any of your important files which were been deleted mistakenly... more »

How to Search for Customers by Name in Quickbooks

By nethopperz

0 comments

In Quickbooks it seems that it should be easy to search for, of all things, a customer's name. Unfortunately, for users of Quickbooks versions prior to the 2007 edition, this is just not possible. While the company name is searchable, the ... more »

How to See The Hidden Files In Any PC

By jaindinu

1 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 Select Unique Values Using SQL in Microsoft Access

By Keith Johnson

0 comments

When you extract information from a database, you may have to look through thousands of duplicate values. Fortunately, there's a way to see only unique values. Here's how to get the data you really need... 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 the AutoFill Function in Excel 2003

By eHow Computers Editor

0 comments

The AutoFill function in Excel lets you save time by automatically filling in certain cells in your spreadsheet. For example, if you are creating a schedule, you can enter "Monday" and use AutoFill to complete the remainder of the days... more »

How to Use the Freeze Pane Command to Create Static Headings in Excel 2003

By eHow Computers Editor

0 comments

Excel is the leading spreadsheet program existing today. With each new edition, improvements are made. As you view the information in your rows and columns, allow yourself to see the headings that go along with it. Follow the steps below to use ... more »

How to Add a Subform in Access 2007

By eHow Computers Editor

0 comments

The main form in Access 2007 may have another form inserted into it called a subform. The combination of form and subform may be called a hierarchical form, master/detail form or parent/child form. Subforms are most commonly used to show data ... more »

How to Create a Bar Graph in Excel 2003

By eHow Computers Editor

0 comments

Excel is the leading spreadsheet program on any home or office computer. It contains calculation abilities and graphics options. Follow the steps below to create a bar graph in Excel 2003:.. more »

How to Create Labels From Microsoft Access Reports

By eHow Computers Editor

1 comments

One of the most convenient Access features for many a user is automatically printing mailing labels from your database. The labels are really just a kind of report. These instructions apply to MS Access 97... 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 Insert a Picture, Graph or Office Document in an Access 2003 Database

By eHow Computers Editor

0 comments

With Microsoft Access 2003, adding a picture, graph or another Office document into a database can enhance the database and may even make it easier for you to understand. Take these steps to insert a picture, graph or Office document into Access ... more »

How to Live the Pirates Life - Get Anything, Anytime, Anywhere...

By TheStorm

0 comments

ARRRR!!!! Pirate to Pirate, you can get almost anything for free. Music, movies, games, software, et cetera... more »

How to Make Quickbooks Run Faster

By nethopperz

1 comments

Many small businesses use Quickbooks to manage their bookkeeping. At first, the software performs wonderfully and really simplifies many tasks. Over time, however, the performance of Quickbooks will begin to noticeably degrade, leaving users ... more »

How to Set or Change the Primary Key in a Microsoft Access Database

By eHow Computers Editor

0 comments

Primary keys are unique record identifiers that MS Access uses when retrieving information for a query or a report. With primary keys, you can join tables in relationships so that you can query both of them at once. These instructions are for ... more »

How to Use Cell Ranges in Formulas in Excel 2003

By eHow Computers Editor

0 comments

Once you know how to create a formula in Excel, you can easily incorporate cell ranges into those formulas. Here's how to do it using Excel 2003... more »

How to Use the Wizard to Create a "Find Unmatched" Query in Microsoft Access

By eHow Computers Editor

0 comments

A Find Unmatched query will locate records in one table that do not have related records in another table. For example, you could find customers that do not have orders pending. These instructions apply to Access 97... more »

How to Add Comments to a Worksheet in Excel 2003

By eHow Computers Editor

0 comments

If you want to make a great impression with your Microsoft Excel 2003 spreadsheets, add comments to the various cells. Comments make a spreadsheet easier to follow and help the reader comprehend the information. Follow these steps to add comments ... more »

How to Add Fields to a Table in Access 2003

By eHow Computers Editor

1 comments

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

How to Calculate, Interpret, and Understand the Location Quotient

By Paul McDaniel

0 comments

The location quotient is most frequently used in locational analysis, economic geography, and population geography, but it has much wider applicability. The location quotient (LQ) is an index for comparing an area's share of a particular activity ... more »

How to Contribute to a Wiki (Wikipedia, Wikihow, etc.)

By Anthony Delgado

1 comments

A wiki is a user-friendly, collaborative database. Essentially, many parties can enter this database and enter in their own information or edit and/or elaborate on existing data. Probably the largest example of this is Wikipedia; a virtual ... more »

Check Out All Categories

Articles in Database Software