VFP tutorial part five

In this tutorial we will create a menu that will be used in SIA ANIQOH. As always make sure you’ve opened the Visual Foxpro. Open aniqoh project which we have previously made. From the project window select the other tab.

From these we select the other tab and press the new menus, new window will display a menu as follows:

From the new window menu we select the menu. Then the designer window will pop up menu

From the window we input the designer menu menus that we will create, ie the file menu, input data, transactions, records, reports, utilities. While in the result column we select the submenu, the goal is so that we can create sub menu from the main menu we have created. If we press the button beside the submenu then edit the existing text, we click on it to edit the file menu. Window will display the sub menu from the file menu. And we fill the sub menu files as follows:

To return to the main menu on our level menu select the menu bar, then we will return to the main menu. From the main menu of the result window of our data input menu click edit, and input the data input to the sub menu like the following:

While sub menu from the menu of the transaction are as follows:

For sub menu from the menu listing is as follows:

And for the sub menus from the menu is the report:

• Goods

• Supplier

• Employees

• Account

• Purchase

• Sales

• General Journal

• Ledgers

• Financial Reports

• Expired goods

Menu and sub menu of the utility are as follows:

To view the interim results of the menus we have created is by pressing the preview button located on the menu window designer. So that the results from the menu we’ve created is as follows:

Dan untuk sub menu dari menu laporan adalah :

· Barang

· Supplier

· Karyawan

· Rekening

· Pembelian

· Penjualan

· Jurnal umum

· Buku besar

· Laporan keuangan

· Expired barang

Dan sub menu dari menu utilitas adalah sebagai berikut :

VFP Tutorial part four

In the previous tutorial we have created the main tables, which will serve targeted tables used to store data from SIA ANIQOH applications. In addition to the main tables needed to store data, the SIA ANIQOH also require auxiliary tables (temporary) to store data temporarily. To create auxiliary tables, make sure you’ve open vfp earlier, and set default directory to be at C: / aniqoh. If already open vfp application then we open our aniqoh project, and from the window of our project, we select the tab aniqoh all – free tables – new. So that new windows will appear as the following table:

From the window we select a new table, so it will create a window appear like the following:

From a window table at the enter name type of assistance, then press the save button. It means we will create an auxiliary table with the name bantuan.dbf. Input the following data in table designer window bantuan.dbf

The next step we will create a table to help with the name kategori.dbf. Same way as before when we create a table to help with the name bantuan.dbf. Kategori.dbf table structure is as follows:

To help kelompok_rekening.dbf table structure is as follows:

For semj.dbf table structure is as follows:

For tempj.dbf table structure is as follows:

To help temp_jurnal.dbf table structure is as follows:

To help templaba.dbf table structure is as follows:

To help username.dbf table structure is as follows:

Such auxiliary tables that we need to make this ANIQOH SIA applications. From the first tutorial up to four tutorials that we’ve managed to create a project, the database, the main table and the table also helped. It’s as authorized to make an app in vfp. On my fourth tutorial ends up here, and in the next tutorial we will learn to create a menu that is needed in the application ANIQOH SIA. Happy learning.

Vfp tutorial part three

In the second part of the tutorial we have discussed how to create a database aniqoh and main table table goods. In this tutorial, we will continue to make the main table to build applications ANIQOH SIA. Before we make a table, make sure if you’ve opened vfp, and enable the project aniqoh. Next we’ll create a table and purchase with the following structure:

Explanation:

Table purchases are used to store the purchase transaction, which consists of five fields. Where the field no_transb, kode_Sup, and since ode_kary is the key (primary key). If you have press the ok button. The next table that we will create is detail_beli, with a structure as follows:

Explanation:

Table detail_beli consists of three fields, with the main key no_transb, and since ode_brg.The next table that we will create a table detail_jual, with the structure:

Explanation:

Detail_jual table consists of three fileds, with key nofak_j, and since ode_brg.The next table is a table d_jurnal with the following structure:

Explanation:

D_jurnal table consists of five fields, where no_jurnal, kode_rek as key. The next table is a table sales, with the following structure

Explanation:

Table sale consists of three fields, with nofak_j, kode_kary in an ascending index. Table journals with the following structure:

Employees table with following structure:

Account table with the following structure:

Table status with the following structure:

Table supplier with the following structure:

Thus the main tables are required in making application ANIQOH SIA. Similarly pembahsan in vfp tutorial part three, hopefully useful. Good luck

VFP tutorial part two

In the first tutorial we have discussed how to create a project with the name aniqoh in vfp. In this second part tutorial we will create a database within the project aniqoh, as well as tables whatever it takes to make this ANIQOH SIA application. To create a database, make sure you’ve open vfp and the drive is directed to a folder aniqoh. From the File menu of your open windows aniqoh project, so the project window will appear with the name aniqoh we have ever previously made.

From the project window select the tab of all these aniqoh, select the Data menu, select the databases, and press the new button. Will present a new database window.

From the window select the new database new database, then create a window will appear

Enter the database type on dbaniqoh, then click the save button. If a window comes up then we close the database designer is just a window. From here we’ve managed to create a database with the name dbaniqoh. To find out the results we are biased view by selecting a tab of all – data – databases – dbaniqoh.

The next step we will create tables in dabatase dbaniqoh. In making this application we need the SIA ANIQOH 11 main tables and nine table-free. In this tutorial we will discuss the making of the main tables that are required on ANIQOH SIA. To create the main tables in the database aniqoh are as follows:

From the project window select the tab aniqoh us all – databases – dbaniqoh – tables. After that press the new button, then the new window will appear as the following table

From the new window select the new tables the table, and then create a window will appear, and the type of goods enters the table name. And press the save button.

When we press the save button will display a window designer-barang.dbf table, from the window of designer goods such as data input the following:

Explanation:

At table the item consists of nine fields, where kode_brg, kd_kateg, the unit becomes the primary key (primary key). In an ascending index.

Okay vfp second part of this tutorial we ends up here first. We will continue on the next tutorial to supplement the main table and table-making aids. Good work

Tutorials VFP part one

MADE APPLICATION  SIA ANIQOH WITH VFP 9.0

vfp on the first tutorial, we will create an accounting application that I gave the name ANIQOH SIA, SIA ANIQOH which is an accounting application that is used for Counter Handphone. To make the SIA ANIQOH the first step is to create a new folder on drive C, and we give the name ANIQOH. After that we create a new project that I gave the name aniqoh too. The trick is to make sure you have opened Microsoft Visual Foxpro. Then from the File menu select New. New window will then appear as follows:

New select Project from the window and press the New File. When we press the button then, New File Create a window appear like the following:

From the windows create the input files to enter aniqoh project, then click the Save button. From here we’ve managed to create a new project with the name aniqoh. So if we see the result is as follows:

From here we’ve managed to create a project in Microsoft Visual Foxpro with aniqoh name. The next step we will create a database and tables used to create this SIA ANIQOH aplication which will be discussed at the next tutorial.

Laptop

Dell is an updated brand that has its specialization in manufacturing amazing models of laptops and notebooks. This laptop model has gained a complete room and reputation among the laptop users of today. The screen laptop screen has a favorable screen size of 12.1 inches along with 1280×800 dpi resolution. Modern laptops weigh 3 to 12 pounds (1.4 to 5.4 kg); older laptops were usually heavier. In 2008 and 2009 more laptops than desktops were sold in the US. When buying used computers or refurbished computers, check whether the seller is providing you with related software documents, licenses and paperwork. Today companies are more focusing on sale of Refurbished Computers which are more profit generating then new ones. Any one who are on tight budget can go for a Refurbished laptops.