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

(b) What is the use of Tools menu in MS–WORD? discuss the use -of any 3 choices. four
(c) Write FoxPro commands for the following: 10
(i) To create a FoxPro table called TEASAL in floppy disk kept in Drive A.
(ii) To list the 1st 5 records from the current table.
(iii) To close only the index files.
(iv) To obtain the total of a numeric field called AC_BAL and store it in S.
(v) To mark the records for deletion from record no. five to 15.
(vi) To position the record pointer on the 1st record where field ENAME is "ANU".
(vii) To send the output of @ ROW,COL SAY command to the printer.
(viii) To display the numeric value stored in Y, accurate up to 4 digits after decimals.
(ix) To prevent automatic movement of cursor to the next field while entering data.
(x) To convert every letter in a field called CITY into uppercase in every record.
Q.7 (a) What is Taskbar in Windows-95? two
(b) discuss the use of New choice and print preview choice of file menu in MS–WORD four
(c) There is a table called WAGES.dbf containing fields worker no. (WNO,N,4,0), Name (NAME, C, 20), Number of days absent for work during a month(DABS,N,2,0) and his monthly basic pay (MBASIC, N,10,2). Write a FoxPro program to print a report showing worker no., name and his proportional basic pay assuming 30 working days in a month. four

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

(i) ACCEPT TO & INPUT TO (ii) ? & TEXT/ENDTEXT (iii) STORE TO & =
Q.8 (a) What is the purpose of shortcuts in Windows-95? two

(b) In MS–WORD, discuss the procedure to copy the 1st snippet of page 10 to the beginning of page 15 of the identical document 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) There are two tables 1st 1 called "COSHARE.dbf" containing fields, Identity no. (CID, C, 10), Name of share holder (SNAME, C, 40), No. of shares held (NSHARES, N. 5, 0), and Face value per share (FVAL, N, 10, 2). a different table "CODIV.dbf." containing fields, Identity no. (CID, C, 10), Address of the shareholder (ADDR, C, 40) and Dividend payable (DIVID, N, 10, 2). Write command in FoxPro for the subsequent.

(i) To index both the tables according to identity no. two

(ii) To update the field dividend payable in CODIV.dbf by computing dividend @4% of face value of shares held, where no. of shares and face value per share are in COSHARE.dbf. two

(d) There is a table called TEST.dbf containing fields roll no.(RNO,N,4), name (NAME, C, 20), and marks in three tests (T1, T2, T3 all Numberic, 3, 0). Write a FoxPro program to change mark as 35 whenever it is 31, 32, 33, or 34 in every test in the table and then print a report showing roll. no., name and marks in three tests of only those who are getting 35 or more in every subject. six

Q.9 (a) discuss how to create a folder in Windows -95? two
(b) How to perform the subsequent operations with reference to MS-WORD? 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 TALK ON/OFF (ii) EOF () (iii) COUNT (iv) SQRT().
(d) There exists a table SALARY.dbf containing fields Employee no,(EN,N,5,0) Name (NAME, C, 30) and Basic pay (BASIC, N, 10, 2) and Date of joining (DTJ, D, 8). Write a program in FoxPro to add new records to this table. This program should allow the user to continue on adding new record as long as he wants. Basic pay should be accepted ranging from 0 and 15000 only.

Earning:   Approval pending.