Database Software

Articles in Database Software

By Ron Auerbach 0 comments
One of the biggest gripes I hear from OpenOffice users is not being able to save their files in a MS Office format. For example, MS Word or MS Excel. Or they have to do each file separately, which is a nuisance! My article will show you how ... more »
By eHow Computers Editor 0 comments
Content management is important to improving and to updating your system. With the help of various Content Management Systems (CMS), you can control, organize and publish documents and other content like multimedia resources and images. The ... more »
By eHow Computers Editor 0 comments
Access is a popuular Microsoft database program, designed to quickly gather and manipulate information. Access features a greater range of database objects than many of its competitors, as well as the ability to convert databases by importing ... more »
By sheldonsubnaik 0 comments
If you have written an MDB database file and you want other users to preform applications with it, then you can convert it into an MDE file. But now you want to convert it it back into an MDB file and you don't want to change any codes. This ... more »
By socrtwo 0 comments
You can compile an Access database into a program of sort with an MDE extension (accde for Access 2007). The question is if you need to redesign the database how can you extract necessary parts to do so, since an MDE file is compi8led into ... more »
By Keith Johnson 0 comments
Copying a table is simple and quick using Microsoft Access SQL. Here’s how it’s done... more »
By eHow Computers Editor 0 comments
Copying a worksheet in Excel 2003 allows you to paste the information into another spreadsheet, saving you the time it would take to retype everything. Follow these steps... more »
By eHow Computers Editor 0 comments
Copying a field definition ensures that your new field will be identical to the original, which can save some time. Keep in mind that this procedure only copies a field's definition; it doesn't copy any values in the field. Here’s how to copy one ... more »
By eHow Computers Editor 0 comments
A "crosstab query" in Microsoft Access 2003 compresses selected data into a viewable space. This allows you to quickly locate values and trends. To create a crosstab query in Access, follow these instructions... more »
By eHow Computers Editor 0 comments
A currency field is needed when a price is desired in a record. When using currency fields, Access 2003 is able to calculate totals, subtotals and averages. These steps will help you to create a field for currency in Access 2003. If creating a ... more »
By eHow Computers Editor 0 comments
Sometimes notes and text are needed in a record. There are two different kinds depending on how much information will be stored in the field. A text field can hold up to 255 characters, and a memo field can hold up to 65,536. These steps will ... more »
By eHow Computers Editor 0 comments
The AutoNumber field in Access 2003 automatically generates a unique number whenever you enter a new record in a table. Here’s how to use it... more »
By eHow Computers Editor 0 comments
Once you create a form or datasheet with some data, you may filter it by using the filter option in Microsoft Access 2003. You can then create a Microsoft Access form or report from these filtered records. For example, you might filter all ... more »
By eHow Computers Editor 0 comments
A table in Access 2007 is a list that contains rows and columns. It is used to store subject-based data and should be created before any other objects when designing a database. You can create a table in a new or existing database in Access 2007. ... more »
By eHow Computers Editor 0 comments
Use a currency field instead of a number field if your data involves money or if you require a high degree of accuracy in the calculations. These instuctions are for Microsoft Access 97... more »
By eHow Computers Editor 0 comments
An Access text field can contain both numbers and text (as you might find in a street address or a zip code). MS Access will not perform calculations on the numbers in a text field. These instructions are for Microsoft Access 97... more »
By Flipper1975 0 comments
When working with Microsoft query you can query a external data and import it into an office program. I am using Excel for this example. When working with data, its good to know what type of data is being stored. For example gender could be ... more »
By Crymson 0 comments
This article describes how to perform a query in Microsoft based on Gender and Currency... more »
By seventy4 0 comments
If you are installing a program like Wordpress.org or Pligg, come across these instructions to "create a MySql database" and it has left you not wanting to continue the install? Don't worry, you don't have to do any programming to ... more »
By eHow Personal Finance Editor 0 comments
A professional service corporation is made up of licensed professionals who provide a specific service. When paired with advice from reliable legal counsel, it is a strong business foundation that protects corporation members from the effects of ... more »
By eHow Computers Editor 0 comments
Creating a Query from a Filter in Access 2003 is accomplished by performing the "Advanced Filter/Sort” feature. This feature allows you to sort information from a single table in the database. Follow these steps to create a Query from a Filter in ... more »
By eHow Computers Editor 0 comments
You can create a query from an existing filter in Microsoft Access instead of designing your query from scratch. These instructions apply to Access 97... more »
By eHow Computers Editor 0 comments
In Microsoft Access 2003 you can use the Query Wizard to compare, contrast and integrate the information in different databases. Here’s how to create a query that uses more than one table in Access 2003... more »
By Mike 0 comments
Access is a quick easy to use database for the home and small business owner. You get plenty of functionality for small to medium sized applications. In Access you have the ability to visually join two tables creating a relationship on to ... more »
By eHow Computers Editor 0 comments
To create a SQL (Structured Query Language) query in Access 2003, you’ll need enough information to create a SQL statement. Fortunately, the program will create the statement for you, so it’s not necessary to write it... more »