Chapter-05(Introduction to Microsoft Access)
|
1
|
Which
of the following is the correct association?
|
|||
|
|
File = column
|
Record = row
|
Field = row
|
Record = table
|
|
2
|
A
collection of data that consists of name, address and email of a person is
called:
|
|||
|
|
Byte
|
Record
|
Character
|
Field
|
|
3
|
The
smallest meaningful unit of data in a database is called:
|
|||
|
|
Byte
|
Record
|
Character
|
Field
|
|
4
|
Each
separate piece of information stored in a record is called a:
|
|||
|
|
Form
|
Field
|
Table
|
Cell
|
|
5
|
A
report may be based on a
|
|||
|
|
Table
|
Query
|
Both a and b
|
None
|
|
6
|
A
database may contain:
|
|||
|
|
Only one table
|
At most two tables
|
At most three tables
|
None
|
|
7
|
The
comlumn of a table corresponded to:
|
|||
|
|
Table
|
Record
|
Field
|
Cell
|
|
8
|
A
database consists of various components called:
|
|||
|
|
Tools
|
Properties
|
Entities
|
Objects
|
|
9
|
The
output of the query is in the form of a
|
|||
|
|
Table
|
Form
|
Report
|
Query
|
|
10
|
A report
is a complete set of _________ field:
|
|||
|
|
Distint
|
Related
|
Designed
|
All
|
|
11
|
An
MS access table contains:
|
|||
|
|
Records but no fields
|
Fields but no records
|
Both records and fields
|
None of these
|
|
12
|
Which
of the following is NOT a database object:
|
|||
|
|
Table
|
Query
|
Report
|
MS Word
|
|
13
|
Which
of the following are objects in an MS Access database:
|
|||
|
|
Table, forms, queries and reports
|
Database,datasheet and forms views
|
Folders and tools
|
All of these
|
|
14
|
Which
option in MS Access is used to create a new database from scratch:
|
|||
|
|
Access
|
Blank database
|
Existing database
|
New folder
|
Q-2: Write short answers any TEN, each question
carry 2 marks. 2x10=20
i.
How does a database is differ from a table?
ii.
What is MS Access.
iii.
List some disadvantages of IDE.
iv.
Define IDE.
v.
Define Menu Bar.
vi.
What is database wizard?
vii.
Why Reports are important?
viii.
Define form.
ix.
What are reports?
x.
Define query.
xi.
Define any two database objects.
xii.
What is database object?
xiii.
List some advantages of IDE.
Q-3: Write detail answers any 2 of the following
questions. 2x8=16
·
What is an IDE? Discuss its advantages and
disadvantages. 8
·
What is database object? Discuss the database
objects used to store and retrieve data? 8
·
Describe Form and Report. Discuss their
advantages and disadvantages. 8
ICS Part-2 notes for Computer Science free download :
FBISE Islamabad ICS Part-2 computer science notes
BISE Lahore ICS Part-2 computer science notes
BISE Multan ICS Part-2 computer science notes
BISE Gujranwala ICS Part-2 computer science notes
BISE Rawalpindi ICS Part-2 computer science notes
BISE Bahawalpur ICS Part-2 computer science notes
BISE Peshawar ICS Part-2 computer science notes
BISE Abbottabad ICS Part-2 computer science notes
BISE Kohat ICS Part-2 computer science notes
BISE Bannu ICS Part-2 computer science notes
BISE Mardan ICS Part-2 computer science notes
BISE Swat ICS Part-2 computer science notes
BISE Malakand ICS Part-2 computer science notes
BISE Hyderabad ICS Part-2 computer science notes
BISE Sukkur ICS Part-2 computer science notes
BIE Karachi ICS Part-2 computer science notes
Copyright all data
www.studyspk.blogspot.com
for more info and sugestion please contact
Studyspk@gmail.com
Model paper 12th class
class 12th model paper free download
ICS Computer model paper download
ICS Computer Science important questions