IT WORLD COMPUTER’S Module Mid Term
“O” Level & PGDCA
Model Question Paper
Ms Access
TOTAL TIME: 2:30 HOURS TOTAL MARKS: 100 (PART ONE - 40; PART
TWO - 60)
NOTE:
1. There are TWO PARTS in this Module/Paper. PART ONE contains FOUR questions and PART TWO
contains FIVE questions.
2. PART ONE is to be answered in the TEAR-OFF ANSWER SHEET only, attached to the question paper, as
per the instructions contained therein. PART ONE is NOT to be answered in the answer book.
3. Maximum time allotted for PART ONE is 30 minutes. Answer book for PART TWO will be supplied at the
table when the answer sheet for PART ONE is returned. However, candidates, who complete PART ONE
earlier than one hour, can collect the answer book for PART TWO immediately after handing over the
answer sheet for PART ONE.
PART ONE
1. Each question below gives a multiple choices of answers. Choose the most appropriate one.
1.1 Which type of query extract the data and put them into separate table?
(a.) A parameter query (b.) A make-table query (c.) An update query (d). A crosstab query
2. Which of the following criterion is NOT written using the proper syntax?
(a.) “Haris” (b.) <500 (c.) NO VALUE (d.) Between #1/1/2000# and #12/31/2000#
[Link] field type is used to store picture in a table?
a. Memo b. OLE c. Hyperlink d. None
[Link] of the following is NOT a report section?
a. Report Header section b. Summary section c. Page header section d. Details section
[Link] you are creating a cross tab query, what must table you are querying contain?
a. Lots of confusing information b. More than 100 records c. At least one field d. All of the above
6.A query summarizes information in a grid, organized by regions and months. Which type of query is this?
a. An update query b. A parameter query c. An action query d. A cross tab query
7. Which Of The Following Database Object Hold Data?
A) Forms B) Reports C) Queries D) Tables
8. Which Of The Following Store Command To Retrieve Data From Database?
A) Forms B) Reports C) Queries D) Tables
9. What Is The Difference Between ‘open’ And ‘open Exclusively’
A) Open Statement Opens Access Database Files And Open Exclusively Opens Database Files Of Other Program Like Oracle
B) Open Exclusive Locks Whole Database So That No One Can Access It Whereas Open Locks Only The Record That Is Being
Accessed
C) Both Open And Open Exclusively Are Same
D) Open Exclusive Command Does Not Exist In Ms Access
10. The Size Of Yes No Field Is Always
A) 1 Bit B) 1 Byte C) 1 Character D) 1 Gb
2. Fill in the blanks in 2.1 to 2.10 below, by choosing appropriate words and Phrases given in
the list below:-
2.1.----------------------data type is generally used for fields assigned as primary key in a table
a. inter b. number c . primary number d. auto number
2.2. A field with a --------------------------------uniquely identifies each record.
a. number b. primary key c. index d. identifier
2.3.----------------------------------------query is used to add records from one or more table into
existing table
a. add b. append c. insert d. delete
[Link] collection of related data and objects is called a-------------------
a. data base [Link] [Link] [Link] of above
2.5.----------------query is used to create a new table
a. delete b . insert c. append d. make table
2.6.----------------is the name of the database object that display data and can be used to edit
data.
a. report b. form c. query d. table
2.7.----------------------are form that are include in another form
a. sub forms b. child forms c. inner formd. none of above
2.8. large amount of data can be summarized by using -------------------table
a. pivot b. create c. tables d. reports
[Link] is stand for……………………………………………..
a. object linking and embedding b. on line execution
c. on line editing e. none of the above
[Link] -------------------obj is used for both as a input and output tool in access.
a. table b. form c. query d. report
3. Each statement below is either TRUE or FALSE. Identify and mark them accordingly in
the answer book.
3.1. Ms Access is DBMS
3.2. Ms Access Obj can be published in web
3.3. There are no wizards for creating g database
3.4. Table cannot be import from another database
3.5. Primary key uniquely indentify each record
3.6. Hyperlink is used to jump to any kind of information or data from a file
3.7. Update query is used to add record form one table to end on another existing table
3.8. Primary key can accept the null value
3.9. Report can be create by wizard
3.10. Macro is used to create short cut
4. Match words and phrases in column X with the nearest in meaning in column
Y.
SR x y
4.1 The extension of ms access database file A. .MDBX
4.2 In database date is store B. Table
4.3 Is the easiest way to create report C. By wizard
4.4 Is used to graphical analyses of records D. Pivot chart
4.5 Component of access database is known as E. Obj.
4.6 Size of yes\no data type F. One byte
4.7 Is present on the top of every page of reports G. Page header
4.8 Relationship is used to H. Join more than
one table
4.9 Report is the I. Output tool
4.1 Max size of text data type J. 255
0
K. .MDB
L. .dbf
M. Macro
By design
N. Pivot table
O. Two byte
P. Report header
Q. Input tool
PART TWO
(Answer ANY FOUR questions)
1. Why access is called RDBMS? Explain the querying a database and generating
report in ms access
2. Give a brief description about the macro in access
3 . What is query and why it is useful in access and give the brief descriptions
on the following operators that are used in query
(A) And (b .) or (c.) between (d.) null (e.)not null (f.) like (g.) in
4 . What is data type and explain the each data types in ms. Access.
5. What is relationship explain the different type of relationship in ms access