University of Mumbai 2006 B.A Economics Computer Systems and Applications - Question Paper

(ii) To display all the records where a string "EN" appears as part of a field called NAME.
(iii) To execute a FoxPro program called as PRM1.prg.
(iv) To obtain the number of records where field BASIC is less than 2000.
(v) To obtain the remainder after dividing numeric memory variables A by B and store it in R.
(vi) To compute DA as two times the BASIC for all records.
(vii) To move the record printer to the 1st record.
(viii) To sort the table in use according to the field CITY and in city according to NAME to a different table called CNM.dbf.
(ix) To display content of a memory variable A using 10 columns and accurate up to two digits after decimals.
(x) To accept the value of a field called "LOAN" which should be in ranging from 0 and 99999 only from 4" row and 10 column onwards,
Q.7 (a) What is use of My Computer facility in Windows-95? two
(b) discuss the use of Insert menu in MS–WORD. Mention any 3 choices. four
(c) (c) There is a FoxPro table called PASS.dbf containing fields Roll no. (RNO, N, 4, 0), Name (NAME, C, 20), Marks in two tests (T1, T2, N, 3, 0) of only those who are passing. Write a FoxPro program to print a report showing roll no., Name and their grade in the alphabetical order of name. Grade is A if avg. mark is 80 or more, it is B if avg. is beneath 80 but not beneath 60. Otherwise it is Grade is C. four

(d) discuss the difference ranging from the subsequent in FoxPro: six

(i) Single INDEX and Compound INDEX (ii) ? & TEXT/ENDTEXT (iii) SET EXACT ON & SET EXACT OFF.
Q.8 (a) What is an Icon in Windows-95? two

(b) How to perform the subsequent operations with reference to MS–WORD? four

(i) To insert date and time.
(ii) To insert row in a table,
(iii) To obtain a word.
(iv) To make the cursor reach page 10.
(c) There are two FoxPro tables 1st 1 called "CSDEPO.dbf" containing fields Account no. (ACNO, C, 10), Customer name (CU–NAME, C, 40), amount deposited (DEPO, N, 10, 2), No. of days of deposit (NDYS, N, 3, 0) and Data of deposit (DDATE, D, 8). a different table called "MAT.dbf." containing fields, Account no. (ACNO, C, 10), Date of maturity (DMAT, D, 8). Write command in FoxPro to perform the subsequent.

(i) To index the 2 tables according to account no. two

(ii) To update the field date of maturity in MAT.dbf by adding no. of days of deposit to date of deposit which are in CSDEPO.dbf. two

(d) There is a FoxPro table called PHLIST.dbf containing fields Customer code, (CCODE, C, 5), Customer name (CNAME, C, 40), Office phone numbers (OFF–NO, C, 30), Mobile no. (MOB–NO, C, 30) and Residence number (RES_ NO, C, 30). Write an interactive program requesting the user to enter customer code and if he record is not found, allow the user to add it as a now record otherwise display "Record Already Entered". This program should allow the user to continue on as along as he wants. six

Q.9 (a) What is the use of Recycle Bin in Windows -95? two

(b) Currently you are editing a document using MS-WORD. discuss how to add a five x four table at the current cursor position and then arrange the table according to column two in the descending order. four

(i) To search for a provided word in the opted text.
(ii) To cancel the last editing.
(iii) To open an existing file.
(iv) To add bullets to the opted text.

(c) discuss the subsequent commands or functions in FoxPro: four
(i) SET DEFAULT TO (ii) VAL() (iii) DAY() (iv) SUM.
(d) (d) There is a FoxPro table called DETAILS.dbf containing fields Account no. (ACNO, C, 10), Customer name (NAME, C, 30), his Date of birth (DOB, D, 8) and Account balance (ACBAL, N, 15, 2). Write an interactive program. requesting the user to enter Account no. and the program must search whether the Account no, is obtained in the file or not if so display Customer name, Data of birth and Account balance otherwise display "Account no. does not exist". This program must allow the user to continue on as long as he wants. six

Earning:   Approval pending.