Database Software

How to Record a Macro in Excel 2003

By eHow Computers Editor

0 comments

Macros are mini programs that help you quickly do tasks in Excel. If you can perform a series of actions in Excel, you can create a macro for that series of tasks and use it as a shortcut. Learn how to record a macro in Excel 2003... more »

How to Remove the Primary Key in a Database in Access 2003

By eHow Computers Editor

0 comments

A primary key in a relational database uniquely identifies each record. To remove the primary key in Access 2003, you first must familiarize yourself with the program's basic functionality. Read on to learn more... more »

How to Remove the Primary Key in a Microsoft Access Database

By eHow Computers Editor

0 comments

Remove the primary key only if you're sure you won't need relationships between the tables in your database. Remember, you can only run queries on tables that have been joined in a relationship. These instructions are for Access 97... more »

How to repair a Mysql database with PHPMyAdmin

By John the Expert

0 comments

You have a MySQL database that has an error. The first thing you can do to try and fix the error is run the repair option in PhpMyAdmin... more »

How to Require Data Entries in a Field in Access 2003

By eHow Computers Editor

0 comments

Access has many built-in features that can make managing your database much easier if you understand their functions. One option allows you to require the entering of data in a field... more »

How to Require That Data Be Entered in a Microsoft Access Field

By eHow Computers Editor

0 comments

You can make certain Access fields "required," which ensures that necessary information cannot be left out of the database, either accidentally or deliberately. For example, in a customer database, a first and last name and address might be ... more »

How to Resize Columns in a Table in Access 2003

By eHow Computers Editor

0 comments

When designing a database it is difficult to know all the specifics at the outset. Data may be too big for a table field or smaller than a data field. Once you create a database, it is easy to resize columns in a table to avoid wasting space... more »

How to Restrict the Data in a Field in Access 2003

By eHow Computers Editor

0 comments

In a Microsoft Access 2003 table or database, you can restrict the data in a field to certain values. Controlling the types of data that someone can enter into a field prevents bookkeeping errors and incorrect database entries. Take these steps ... more »

How to Save a Worksheet as HTML in Excel 2003

By eHow Computers Editor

0 comments

The Internet can be a great way to spread information, talent and get your foot in the door. Excel is the leading spreadsheet program on any home or office computer. Put the two together and you could be on your way to good things. Follow the ... more »

How to Save Computer Files From Crashing

By Lindaperry

0 comments

You do not have to lose all your files if your computer crashes IF you prepare ahead of time. Here is how to save your photos, files, legal papers and more so that you will never lose them. After this email and comment box, continue reading... more »

How to Set Field Data Format in Access 2007

By eHow Computers Editor

0 comments

The field data formats in Access 2007 have been enhanced to improve the way that tables display information. They are dependent on the data types and a data format may be applied to an input mask. The following steps will show how to set the ... more »

How to Set Field Data Type in Access 2007

By eHow Computers Editor

0 comments

A field data type in Access 2007 specifies the data that a field may contain and its size. The data types in Access 2007 include boolean, currency, date, double, integer, long, string and variant. You should make a copy of a table before changing ... more »

How to Set or Change the Primary Key in an Access 2003 Database

By eHow Computers Editor

0 comments

The Access application uses the primary key to identify each item in a database table. When you set or change the key, you modify the ID number that the program uses to match records from one table to another. Here's how to set or change the key... more »

How to Set the Maximum Characters for a Text Field in Access 2003

By eHow Computers Editor

0 comments

Before setting the maximum characters for a text field, you must understand database tables and be able to navigate Access 2003. Think about who will access the data and how they will use it as you plan your database table's design. Then follow ... more »

How to Set the Maximum Number of Characters for a Microsoft Access Text Field

By eHow Computers Editor

0 comments

Shorter text fields reduce storage space, speed up searches and discourage people from entering more data than is wanted. These instructions apply to MS Access 97... more »

How to Set the Number of Decimal Places for a Table Field in Access 2003

By eHow Computers Editor

0 comments

In Access, you can alter many field properties to help you manage your databases, including how many decimal places appear in a table field. Follow the steps below... more »

How to show quick launch icons on windows taskbar

By kiwi800321

0 comments

Quick launch icons provide an easy way to run applications... more »

How to Sort Records Using Multiple Criteria in Access 2003

By eHow Computers Editor

0 comments

Are you trying to sort records using multiple criteria in Access 2003? This can be a confusing step if you have not already tried it. With just a few short and simple steps this article will show you how to sort records using multiple criteria in ... more »

How to Sort Records Using SQL in Microsoft Access

By Keith Johnson

0 comments

Sorting database records in Microsoft Access SQL is easier than you think. Read on... more »

How to stop programs from starting up with windows XP

By kiwi800321

0 comments

If your PC takes a long time to startup, it can be because you have to many processes starting up with windows. Here is how you can disable these startup items... more »

How to Sum Up Values in a SQL Statement for a Specific Selection

By Mike

0 comments

There will come a time when you need to sum up values for a specific customer in your database. Here is how you do it... more »

How to Transpose a Data Array in Microsoft Excel

By eHow Computers Editor

0 comments

When using Excel, it sometimes becomes necessary to change a horizontal array of data to a vertical position. To do this without copy and paste, enter the following formula... more »

How to Update Values in a Table Using Microsoft Access SQL

By Keith Johnson

0 comments

If information in your Access database needs to be updated, you can do it quickly using SQL. Here's how it's done... more »

How to use "MICROSOFT OFFICE SUITE"

By jull14

0 comments

Microsoft Office Suite is for most people a difficult program to understand but I believe that the reason this happen is because not everybody take time to learn about this. My purpose is to show you a little be about this and maybe this ... more »

How to Use a Database Template in Access 2007

By eHow Computers Editor

0 comments

Some database templates are included in Access 2007 and are frequently used by beginners to create applications without knowing anything about database design. Advanced users may also find that templates save time in setting up an application. ... more »

Check Out All Categories

Articles in Database Software