Types Databases

There are several types of known file in the package database, these files have different extensions in accordance with the content and functionality of the file. File Ekestensi provided directly by the computer as with other packages.

Database File

This file contains data in accordance with the structure that had been prepared previously. This type of file extension is a DBF (database files). Database file is very important that nearly all data collection activities will feel lighter when it is missing. This file must be made in advance of other file types, because in this file the necessary data centers.

Example : STOCK.DBF  : contain inventory data

Index File

The file type that is used to accommodate the desired field indekskunci. This file can only work if the database file has been created. Key Field is the key to sort the files that already exist. Types of files have the extension NDX

Example : Product.NDX : Contain Index By Product Name

Report File

File a report that contains the skeleton form of a report that was created earlier. This file can provide reports in tabular form, this will certainly facilitate the reading of reports from existing data. To enable these files must be activated in a database file in question. Types of files have the extension FRM

Example : Journal.FRM : Contain report journal

Format File

The shape and arrangement of diprinter output screen can be stored in separate files, so biladiinginkan will be entering data or displaying data in a specific format, file format can be called. File format is not dependent on other files directly, this file has the extension FMT.

Exmaple : Menu.FMT  : screen form program settings.

Memory File

Memory variables dismpan not permanent, when power is lost then the variable will be lost. One time when we need a variable memory can be saved into an external disk or other memory, the memory variable both variable name and its contents are stored in a file that ends with MEM

Example Password.MEM : contain variable for password

Program File

Program file is a file type that is very important to arrange all the necessary commands in the database applications problems for an application. Structured program or sequence of commands entered into a separate file with extension PRG

Example Menu.PRG contains command menu setings

Memo File

When we need a record or a brief description of the data that will establish a database (DBF), then this information can be incorporated into a separate file. However, this file can not stand alone, together indukny must submit the relevant database files. The existence of this file are marked with the file extension DBT. Memo file name will follow the same master file with the file name database.

Labels File

This file labels can be used to create a label that contains simple information, such as labels are affixed at the time of sending a letter or a magazine subscription. So this file must be operated together with the corresponding database file.

Text File

This file is a file that is written in the form of a common form of ASCII characters, so it can easily be communicated with other packages outside the database package

Posted in: Introduction Fox Base