Veer Narmad South Gujarat University 2011-3rd Year B.Com SB-0512 Computer Application : ( : 4 ) . - Question Paper
SB-0512
Third Year B. Com. Examination
March / April - 2011
Computer Application : Paper - IV
[Total Marks : 35
Time
Hours]
M CnsLLnlcj.L{l [qoicu u? snqw <h>h41.
Seat No.:
Fillup strictly the details of signs on your answer book.
Name of the Examination :
T. Y. B. Com.
Name of the Subject:
Computer Application - 4
Student's Signature
-Subject Code No.: |
|
-Section No. (1,2,.....): Nil |
-MdL JWftdi (3tR ?HlHl : USL UR)
(*0 Toolbox -41 'Max lenth' (lSLLcil.
(0 Fixed size -(I M &d *lWI ?lil ?
(3) Constant ?
M VBHL MlM SqrSil
(m) *Lbih Hia kefl. Ah d ?
(e) DML Statement dL MLl LLHl.
(0) $i. L kL<H06 WLL<Cl.
* (?h) VB Hi -MdL $d %LH*M.cCl : 6
(l) RUD (0 MID
(3) RGB M EXP.
(h) Visual BasicHL Procedure H'fttHl. H U) Recordset % ? <Wl Htfttoit =*Hd tftH# SlHWiL. X {$) Menu Editor H'fttHl. 3
H*l<U
* (*l) HL HL $Ltk %LH*M.cCl. 6 (<h) ADO data control H'fttHl. H (&) Common Dialog Control *{1 Hd Y
(i) VBHL UW>2L ?IU #LL ttH'SA'fl. 3
3 M H51 Hil'ii (3tR ?HLHl : 1 *
(h) Access Hi Constraints ;&Hcfclcil.
(h) dl&H MRHL Hl Format Property (&) Sub query Make Table Query ;&Hcfclcil.
U) Access Hi Aggregate
Instruction : As per the instruction No. 1 of Page No. 1.
1 Answer in brief : (any five) 5
(i) State the Max Length property of Text box.
(ii) How could you declare fixed size string ?
(iii) What is a constant ?
(iv) State the keyboard events in VB.
(v) How many size of statistical field ?
(vi) State the various DML statements.
(vii) State the different objects of database.
(a) Explain the following functions in VB. 6
(i) RUD
(ii) MID
(iii) RGB
(iv) EXP.
(b) Explain procedures in Visual Basic. 5
(c) What is Recordset ? Explain different methods and 4 properties of it.
(d) Explain Menu Editor. 3
OR
(a) Explain different file control.
(b) Explain ADO Data Control.
(c) Explain different properties and methods of common 5 dialog control.
(d) Explain any one looping structure in VB. 3
Attempt any three : 12
(i) Explain different data constraints in access.
(ii) Explain format property for date type field.
(iii) Explain sub query and make table query.
(d) Explain different Aggregate function in Access.
SB-0512] 2 [ 400 ]
Attachment: |
Earning: Approval pending. |