1.
MS-Access is a?
Answer: Option 'B'
Database Tool
2.
A part of database that stores only one type of data is
Answer: Option 'C'
Field
3.
How we save database file in MS Access 2007 for Ms Access 2000?
Answer: Option 'A'
Save As MS Access 2000 Database
4.
Which Of The Following Creates A Drop Down List Of Values To Choose From?
Answer: Option 'D'
Lookup Wizard
5.
_______ is a field property that determines what kind of data a field can store?
Answer: Option 'A'
Data select
6.
What are the columns in a Microsoft Access table called?
Answer: Option 'C'
Fields
7.
In MS-Access press CTRL+O to
Answer: Option 'B'
Open an existing database
8.
To add two cells (A1 and A2) together you use the following formula:
Answer: Option 'B'
=A1 + A2
9.
Any report, including a basic report, can be modified in _____.
Answer: Option 'C'
Layout View
10.
Which of the following is latest version of MS-Access?
Answer: Option 'D'
MS-Access XP
11.
Which symbol must all formula begin with:
Answer: Option 'B'
=
12.
This is the stage in database design where one gathers and lists all the necessary fields for the database project.
Answer: Option 'C'
data definition
13.
A database can be best described as
Answer: Option 'B'
Organized collection of data
14.
Which Of The Field Has Width 8 Bytes?
Answer: Option 'C'
Date/time
15.
In MS-Access to Open a combo box
Answer: Option 'D'
F4 or ALT+DOWN ARROW
16.
The Database Language That Allows You To Access Or Maintain Data In A Database
Answer: Option 'A'
DCL
17.
Which Of The Following Is Not A Type Of Microsoft Access Database Object?
Answer: Option 'B'
Worksheets
18.
HSAM stands for ________
Answer: Option 'D'
Hierarchic Sequential Access Method
19.
In MS Access “Lookup Wizard” is used to
Answer: Option 'A'
to select value from another table
20.
MDE file is a?
Answer: Option 'B'
Microsoft Access Database
21.
_______ is a field property that determines what kind of data a field can store?
Answer: Option 'C'
Data select
22.
What Are The Columns In A Microsoft Access Table Called?
Answer: Option 'A'
Fields
23.
This Is The Stage In Database Design Where One Gathers And List All The Necessary Fields For The Database Project.
Answer: Option 'A'
Data Definition
24.
Which of the following is not a database object?
Answer: Option 'D'
Relationships
25.
In MS-Access, minimum of _________data types can be assigned to a field?
Answer: Option 'D'
10