Database Software

An aging report is a report that shows accounts receivable amounts grouped by age. The report makes it easy to spot customers who are late with their payments. The key to creating these types of...

On-line computer applications fall into two broad categories: 1. consumer applications such as Microsoft Word, Quicken and other applications used both at home and at work; 2. business...

There are several different methods for removing spaces from data retrieved in an Oracle results set. Oracle PL/SQL provides several different character functions for removing spaces, and which...

Microsoft Office Access is used to create many different forms of databases. These may be relational or even object-oriented databases. You can create databases for anything from inventory...

Accurate record-keeping is essential to the success of your business. If you have employees, an essential ingredient to successful record-keeping is an accurate way to track the time that they...

Building reports in Microsoft Access can aid the user in determining the results of data that has been filtered through queries and/or stored in tables. As an Access user becomes more proficient...

You store a huge amount of data on your hard drive and other storage devices or media everyday, which is extremely critical for your business. You might have your significant tax files, project...

A RAW volume in a hard drive is primarily written to by a program that does not require any file system such as, FAT or NTFS. For instance, Microsoft SQL Server performs direct Input/Output to RAW...

The following is a list of good hardware and operating system advice for good mysql performance. Much of it would apply to any database, really. Enjoy.

Though cursors are the slowest possible way to move through data that is stored in the SQL server, they can be useful when trying to access only one row of data at a time. As opposed to update...

XML (Extensible Markup Language) databases are flexible because they can be read on many platforms. Developers can modify tags so visitors to find their documents more easily on the Web and within...

Returning data from a stored procedure is an important part of web and desktop application programming. Databases store information for retrieval for business representatives, or it allows users...

Restoring a database is part of the administration process that happens after failure or severe corruption in the data. It's important for a database administrator to know how to back up and...

Sometimes users accidentally create multiple duplicates in the system, and as a database administrator, you're tasked with finding them. Unfortunately, duplicates take up resources and make it...

Data is very important for every computer users. How we can recover our data fron crashed hard drive is in this article.

Database administrators know that occasional errors occur, and duplicate records are inserted into the database. The issue is a common problem for administrators to fix, but deleting records from...

Though SQL is a very powerful nonprocedural data-manipulation language, sometimes the need comes up to work with table data row-by-row in the procedural way, as if you were writing a traditional...

Microsoft Access is a powerful, consumer-friendly database program. It can be used for individual households and for businesses. Some components of the database include tables, queries, forms,...

SQL mirroring is a process in which a "mirror" version of a database is created that, while not accessible to the website's visitors, serves as an up-to-date copy of the primary server. As with...

CSS servers are great tools for managing Web hosting, game server hosting and many other types of media. The MOTD (message of the day) function for your CSS server allows you to commonly update...

I ran into a situation where I was migrating from one server to another and didn't have time to manually bring these settings over. In order to do this you must use the system registry. It is very...

If you are a confident Access user or database programmer, you may want to use Design view to create your Access database tables. Tables are the place in Access where the data records are stored....

This software looks user friendly, but you can easily use it incorrectly. Follow these steps and you will start off on the right foot.

This article will give a brief introduction on how to design a relevant, useful, normalized database schema that will scale well to enhance the capabilities of any dynamic program you may be writing.

Have you had a toolbar you use regularly seem to disappear on you when you are using an Office application? It can be frustrating trying to figure out where the toolbar went and how to get it...

Migrations, Site Definitions, and MergeContentDB's

Creating a SharePoint Growth Model

One of the benefits of using a computer is that you're able to save time by printing address labels instead of writing each one out by hand. Whether you're printing address labels or return...

When writing a stored procedure, sometimes it is helpful to be able to find out if a temporary table already exists. Amongst other things, this will help you to avoid errors that occur when you...

How Business people can protect against Computer Threats & Misuse of Company computers.

Often it is necessary to consolidate data from various individual Excel worksheets into one master worksheet. Microsoft Excel allows users to easily consolidate worksheets from the same workbook...

Visual Basic for Applications, or VBA for short, allows users of Excel to go above and beyond the basic functions of Microsoft Excel. One common use for VBA in Excel is macros. Whenever a macro is...

Creating a data model for email messages requires that each email be accessible in the proper context and also that the appropriate relationships are labeled. This is the job of a database...

Each column in a MySQL database has a type--or a specific kind of data that it will store. Good database programming takes into account what kind of data will be stored in each column and assigns...

When downloading files online, or even receiving an email you will often receive a ZIPPED folder. A zipped folder is a compressed version of a large document which allows it to be sent and...

Oracle has thousands of employees in offices around the world. Getting a job with Oracle requires some advanced training, high-level job skills and experience. As one of the premiere database...

A Wiki is an online application intended to allow users to create, edit, link and manage web pages; probably quite like eHow.com.

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

Tables in Access 2007 may be edited in several ways, including datasheets, find-and-replace, forms, queries and the Data Collection feature, which is new for Access 2007. Remember that the term...

The Advanced Filter/Sort function in Access 2007 allows you to sort data in a user-defined order rather than the sort orders defined for that data type. For example, if you have a field containing...

Microsoft Access is an efficient platform to collect, store, connect and relate large amounts of data. The processes to utilize this software program can seem a bit overwhelming at times. Break...

A script is series of user-defined instructions that automate repetitive or complex tasks on a set of records, similar to a macro in word processing. A FileMaker Pro database script can work...

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

Tons of data can be stored within a MySQL database. With its capability to store large amounts of data, accessing a single piece of information within the MySQL database can seem like a daunting...

Incorporating tables is the most common form of controlling a layout. However, with the onset of Cascading Style Sheets (CSS), table-free layouts have become the design of the future. With CSS, it...

If you are moving your Web site to a new server or just backing up your MySQL database, you will need to export a MySQL database. To do this you can either use the phpMyAdmin interface or the SSH...

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.

You can use Microsoft Access 2003 to search for and share data across multiple tables. For example, suppose you are a potter and you want to keep track of your business operations. You could...

Let's face it - for most people, creating a budget is never fun. But at least with Excel it can be fairly easy. These steps work for Excel 97.

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.