Articles on Database Software

How to Create a Yes/No, On/Off or True/False Microsoft Access Field

By eHow Computers Editor

1 comments

You can create a field in MS Access that allows you to choose between Yes/No, On/Off or True/False. Since only one of two values can be entered in this type of field, MS Access can easily generate very accurate reports or perform queries based on ... more »

How to Create an Access 2007 Multi-Column Lookup List

By eHow Computers Editor

0 comments

A multi-valued lookup column is a new feature in Access 2007. Previous versions of Access allowed only one value to be stored in a database field. A multi-valued lookup column will allow you to choose more than one item in a list. The following ... 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 Export Your Outlook Calendar

By mjbelluto

0 comments

Transfer Contacts from Office outlook to home outlook no palm pilot... more »

How to Filter Data in a Microsoft Excel Worksheet

By mar1965

2 comments

This article shows you how to filter data in Microsoft Excel, especially if you have a worksheet with many columns and hundreds or even thousands of rows. The article assumes that your table/data has a clear set of headings (preferably only a ... more »

How to get the CD key off any CD

By russostyle

8 comments

cant locate your cd or product key because your dog chew the cd case ? no problem :D.. more »

How to Install an Oracle Applications Patch

By eHow Computers Editor

0 comments

Patches bring Oracle databases up to date by adding extra security to protect against known threats and adding new features desired by the user. Each patch requires slightly different steps to install, but here is a general framework to get started... more »

How to Learn Database SQL Technology

By eHow Computers Editor

0 comments

Structured Query Language (SQL) is a language that was developed by IBM for processing data in mainframe databases. The relational nature of databases and the ease of SQL usage has made SQL the standard language for databases. SQL technology is ... more »

How to Open MySQL Database With MS Access

By khumbulau

0 comments

Shows you how to open A MySQL Database using Microsoft Access.. more »

How to Predict a Tsunami

By eHow Computers Editor

0 comments

Tsunamis have killed more than 70,000 people during the 20th century, and thousands more since the beginning of the 21st. The ability to predict a tsunami is still in its earliest stages. Predictors range from primitive visual cues to complex ... more »

How to Resize Columns in a Microsoft Access Table

By eHow Computers Editor

0 comments

You can resize your Access columns two ways: by dragging or with a menu command. Dragging is quicker, but you can be more precise with the menu. These instructions work for Microsoft Access 97... 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 Sort a Database in FileMaker Pro

By eHow Computers Editor

0 comments

FileMaker Pro is a relationship database that helps the user manage large amounts of data and keeps records in the order they were entered. The user may rearrange records based on a value in one or more fields. This process, called sorting, ... more »

How to Sort a Row or Column in Excel

By eHow Computers Editor

0 comments

Excel makes it easy to sort a range of values. You might not think of sorting spreadsheet values, but it can come in handy; sorting can help alphabetize a column of row names, for example. These steps are intended for Microsoft's Excel 97... more »

How to Use Keywords in Microsoft Access SQL

By Keith Johnson

0 comments

Use the LIKE keyword in Microsoft Access SQL to find an approximate match of data... more »

How to Use Online Database Tools

By Virginia DeBolt

0 comments

You no longer need to set up a database in Microsoft Access or some other software that you personally own--and then figure out how to publish it on the web in a useful way. You can now take advantage of powerful online database applications that ... more »

How to Add a Record to a Table Using SQL in Microsoft Access

By Keith Johnson

0 comments

Adding a record to a table is a bit tricky. But the following will help you master this common database task... more »

How to chart daily sales in excel

By bmerritt

0 comments

If you want to chart your daily sales revenue in Excel, it is easier than you may think. Once you get the template set up, all you have to do is just plug in your data daily. You can even track monthly sales as the date progress... more »

How to Choose Accounting Software for Your Business

By Paul M. J. Suchecki

1 comments

When my grandfather opened his grocery store in Wollaston, Massachusetts in the early part of the last century, he did his accounting in a double entry ledger and soon developed the ability to rapidly and flawless add long columns of figures in ... more »

How to Create a Delete Action Query in Microsoft Access

By eHow Computers Editor

0 comments

By creating a Delete action query in Microsoft Access, you can automatically delete a group of records from one or several tables. For example, in your CD database, you could use a delete query to delete all records pertaining to a CD that you ... more »

How to create a form letter in Microsoft Office

By Dubtrizzle

2 comments

This "E-How" will teach you how to create a form letter for when you are writing a repetitive letter to different recipients... 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 Microsoft Access

By eHow Computers Editor

1 comments

You can retrieve and display specific database records by creating a select query in Microsoft Access. For example, you could create a query to display the names and e-mail addresses from your Address table. These instructions apply to Access 97... more »

How to Create an Access 2007 Combo Box

By eHow Computers Editor

0 comments

A combo box in Access 2007 provides a way of selecting a value from a list. This is quicker than remembering which value to type and ensures that the entered value is valid. A combo box is a compact method of presenting a list of choices and ... more »

How to Determine Which Query to Use in Microsoft Access

By eHow Computers Editor

0 comments

You can select from five query types in Microsoft Access: select query, SQL query, crosstab query, parameter query or action query. These instructions apply to Access 97... more »

Check Out All Categories

Database Software

Articles in Database Software