Scribd
Upload
7 views4 pages

Ms Visual FoxPro

Microsoft Visual FoxPro 6.0 is a database management software developed by Microsoft that allows users to create databases, tables, and reports. It includes various command functions such as Create, Browse, Delete, Append, and Modify, each serving specific purposes for managing data. The software operates through command-based inputs and is part of the Microsoft Visual Studio 6.0 package.

Uploaded by

biswasdebojit663
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views4 pages

Ms Visual FoxPro

Microsoft Visual FoxPro 6.0 is a database management software developed by Microsoft that allows users to create databases, tables, and reports. It includes various command functions such as Create, Browse, Delete, Append, and Modify, each serving specific purposes for managing data. The software operates through command-based inputs and is part of the Microsoft Visual Studio 6.0 package.

Uploaded by

biswasdebojit663
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Microsoft Visual FoxPro 6.

0
Microsoft visual FoxPro is data base package type application software. This software used to create a
data base, table, from, report etc. FoxPro is part of Microsoft visual studio 6.0 package. This software
developed by Microsoft Corporation from USA. The FoxPro version is 6.0. Another name of FoxPro is
Data base.

*FoxPro is a RDBMS (Relational Data base Management System).

*The Extension name of FoxPro =>.dbf

(Q)1. How to open FoxPro?

Step
 Start Button
 All Programs
 Microsoft visual studio 6.0
 Microsoft Visual FoxPro 6.0.

*Short cut key of command window =>Ctrl+F2.

*FoxPro is command based, it used only write command.

*Command No.1

Create Command

*Create Command is used to create a new table structure.

Command
Create [Link] Enter

NAME TYPE WIDTH DECIMAL


Name Character 20 X
Address Character 15 X
Dept Character 10 X
PH No Numeric 10 X
Basic Numeric 8 2
 Click ok
 Click yes

Name: Sangib Biswas


Address: Kandi
Dept: School
PH No:
Basic: 6000

 Press Ctrl+w (For Save & Close)

*Command No.2

Browse Command

*Browse command is used to open the file.

Browse
Or
Brow

(Q)1. How to Delete Any Record?

Step
 Open table (Brow)
 Select or Click Record
 Press Ctrl+T (For deletion mark)
 Press Ctrl+w
 Type pack and Enter
 Brow.

*Command No.3

Pack Command

*Pack Command is used to any Record Delete.

Command
Pack Enter

*Command No.4
Append Command

*Append Command is used to Add a new Record.

Command
Append Enter

*Command No.5

Modify Structure Command

*Modify Structure Command is used to Add a new Record and Edit field.

Command
Modi Stru Enter

*Command No.6

Edit Command

*Edit Command is used to Write in the table for Edit and Modify.

Command
Edit Enter

*Command No.7

List Command

*List Command is used to Record in the table and show the screen.

Command
[Link] Enter
[Link] Name Enter

*Command No.8

Clear Command

*Clear Command is used to Any Record in the screen for clear.

Command
Clear Enter
*Command No.9
Display Command

*Display Command is used to show the record in computer screen.

Command
[Link] All Enter
[Link] Record 2 Enter

*Command No.10

Zap Command

*Zap Command is used to Any Record for permanently Delete.

Command
Zap Enter

 Click Yes.

*Command No.11

Quit Command

*Quit Command is used to Close the FoxPro.

Command
Quit Enter

*Command No.12

Replace Command

*Replace Command is used to calculate any value of a table.

You might also like