DATABASE USING FOXPRO

    UNIT-I
  • The RDBMS for PC
  • Concept of database
  • FoxPro - Versions, features, requirement of Hardware and Software
  • FoxPro Menu System
  • Working with FoxPro Creating Database File
  • Some common operations on data - CREATE, LIST, APPEND, CLOSE, QUIT
  • FoxPro Data Types
  • Viewing and Editing Data
  • Data Displaying Commands - LIST, DISPLAY, LOCATE, EDIT, CHANGE, BROWSE, REPLACE, DELETE, RECALL, PACK (All Commands with various Options)
     UNIT-II
  • File utilities in FoxPro Modify Structure
  • Memo Field and File Utilities - DISPLAY DIRECTORY, COPY, DELETE, RENAME
  • Sorting and Indexing of Database Files
  • Sorting & Indexing Concept
  • Sort Commands - Single & Multiple Key
  • Advantage & Disadvantages of Sort
  • Indexing Vs Sorting
  • Single & Multiple Key Indexing
  • FIND, SEEK
  • FoxPro Report - its creation, features & Utilities
  • Preview, Printing Custom Report, grouping & Sub grouping
  • FoxPro Label - Designing & Printing
    UNIT-III
  • Memory Variables, Date & Time Functions and Keyboard Macros
  • Memory Variables - Creation and Uses, Simple Vs Array
  • Saving and Restoring Memory Variables
  • ? [??/??? Commands
  • Time & Date Functions and Commands
  • Date Arithmetic, Converting Defining Function Keys
  • Keyboard Macros - Creating and Using Mathematical Commands, Functions, Arithmetic Operations, Mathematical Functions
    UNIT-IV
  • Programme with FoxPro Concepts of FoxPro commands file
  • Modify Commands Conditioning
  • Branching and Looping within Program files with Do-While Enddo, If-Endif, Scan-Endscan, For-Endfor, Docase-Endcase, Text-Endtext
  • Executing Commands from other command files
  • Macro Substitution
  • Common Error Massages
  • Debugging techniques and commands
    UNIT-V
  • Concept of Multiple Database Files - Using multiple database files
  • Relationing the database - SET RELATION, UPDATE, APPEND, FROM, COPY TO, JOIN
  • Relation Query by Example and SQL
  • CUSTOM SCREENS & USER DEFINE FUNCTIONS & OTHER TOOLS
  • Create Custom Screen with @, @_GET, @LEDIT, @_SAY GET READ
  • Creating Box & Lines
  • User Define Functions
  • Custom Screen Designing and their Use
  • FoxDoc for documentation


और नया पुराने