Saurastra University 2006 B.C.A Computer Application Intro & Use of RDBMS(Access - 2000) - Question Paper

SD-6541]
1
[Contd..
*SD-6541*
SD-6541
Seat No.__________B. C. A. (Sem. III) ExaminationMarch
/
April – 2006Intro & Use of RDBMS(Access - 2000)
Time :
3
Hours]
[Total Marks :
100
1
ans the subsequent ques. : (any four
)
20
(i)
What is relationship? discuss various kinds ofrelationship with example.
(ii)
List various kinds of joins. discuss any 1 with example.
(iii)
Distinguish ranging from linking table and embedding table
(iv)
define Access as relational database
(v)
Write short note on charts in Access
2
ans the subsequent ques. : (any two
)
20
(i)
discuss Normalization
(ii)
discuss various kinds of reports in Access
(iii)
List various kinds of queries. discuss any 1 withexample.
3
describe the subsequent in brief : (any ten
)
20
(a)
Tuple
(b)
Foreign key
(c)
SQL
(d)
OLE
(e)
Bound Control
(f)
Database
(g)
Key field
(h)
Sub form
(i)
Union
(j)
Combo box
(k)
computed field
4
(a)
discuss subsequent properties : (any five)
10
(i)
Row source
(ii)
Required
(iii)
Inputmask
(iv)
Validation rule
(v)
On lost focus
(vi)
Default
(b)
discuss importance and use of data access page and
10
discuss kinds of data access pages.
5
Attempt (any four) :
20
(a)
discuss macro in detail.
(b)
discuss import, export and sharing of data.
(c)
discuss creation of tags in Access.
(d)
discuss properties of form.
(e)
Write down the steps to create new toolbar.
_____________
SD-6541]
2
[ 200 ]

Earning:   Approval pending.