MS Access Section 1 Page 1


1.
Microsoft Access is a ……
Word Processing Software
Database Management Software
Presentation Software
Calculation Software
Answer: Option

2.
…… is a collection of data stored in a standardized format, designed to be shared by multiple users.
Database
Record
Database Management System
Relation
Answer: Option

3.
What is the file extension name of MS Access 2007?
.mdb
.access
.acc
.accdb
Answer: Option

4.
……is not the function of database management system.
Creating & Processing Forms
Creating Database
Processing Data
Administering Data
Answer: Option

5.
If you need to edit relationship……
Right click the relationship line and choose Edit Relationship
Double Click the relationship line
Both of the above
None of the above
Answer: Option

6.
If you write criteria values vertically one in a row it will means ……
OR conditions
AND conditions
NOT condition
None of the above
Answer: Option

7.
Query design windows has two parts, The upper part shows…
Name of the fields, field type & size
Tables with fields & relationship between tables
Criteria
Sorting check boxes
Answer: Option

8.
What do you mean by one to many relationship between student and class table?
One student can have many classes
One class may have many student
Many classes may have many students
Many students may have many classes
Answer: Option

9.
A table can have only one……
Alternative Key
Primary Key
Unique Key
Foreign Key
Answer: Option

10.
A ……name must be unique within a database.
Table
Field
Record
Character
Answer: Option

11.
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command…
File Menu
View Menu
Database Menu
Tools Menu
Answer: Option

12.
In one to many relationship the table in one side is called …… and on many side is called……
Child, Parent
Parent, Child
Brother, Sister
Father, Son
Answer: Option

13.
Which of the following key uniquely identifies a table?
Foreign Key
key Record
Primary Key
Unique Key
Answer: Option

14.
A search value can be an extra value or it can be……
Logical Operator
Relationship
Wild Card Character
Comparision Operator
Answer: Option

15.
What is the full form of SQL?
Sophisticated Question List
Structured Question List
Structured Query Language
Small Query Length
Answer: Option

16.
The ……button on the tool box display data from a related table.
Sub form sub report
Relationship
Select Object
More Controls
Answer: Option

17.
Database Management System are used to ……
Eliminate Data Redundancy
Manage File Access
Establish relationship among records in different files
All of the above
Answer: Option

18.
Form is used for……
Display Data
Input Data
Search Data
All of the above
Answer: Option

19.
Which of the following is a relational database management system?
Fox Pro
Oracle
Dbase
None of the above
Answer: Option

20.
To create queries in MS Access…
You can drag & drop fields on query builders
You can type the SQL command in SQL view
You can use query wizard or design view
All of the above
Answer: Option

21.
Which database object actually holds data?
Table
Format Menu
Query
Report
Answer: Option

22.
You can automatically include all of the field in a table in a query by …… a strike that appear list box in query design view.
Clicking
Right Clicking
Double Clicking
None of the above
Answer: Option

23.
A form can be used to……
Modify Record
Delete Records
Format Printed Output
All of the above
Answer: Option

24.
To create relationship between two tables……
drag the primary key of a table into foreign key of another table
drag the foreign key of a table into the primary key of another table
drag any field from parent table and drop on child table
any of above can be done to create relationship
Answer: Option

25.
The column of a table is referred to as the …..
Tuple
Attribute
Entity
Degree
Answer: Option

#buttons=(Ok, Go it!) #days=(20)

Our website uses cookies to enhance your experience. Check Now
Ok, Go it!