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