Microsoft access Solved MCQ’s

Microsoft access Solved MCQ’s

Let us see the Microsoft access Solved MCQ’s.
1. A query is defined as?
A.user can also change data in the database that fulfills certain criteria
B.the output of the query is also displayed in the form of a table
C.a query can also allow performing a calculation on a different number of fields
D.all of these
Ans:D

2. Ms Access represents
A. Relational database
B. network model
C. object oriented model
D. none of these
Ans: A
3. Which of the following represents the wizard of DBMS?
A.Query wizard
B.form wizard
C.Table wizard
D.all off these
Ans:D
4. In which elements represented by the MS-Access Application Window?
A. scroll bar
B. Title bar
C. toolbar
D. all of these
Ans:D
5. The database access consists of various components called?
A.relatinship
B.tools
C.objects
D.entities
Ans: C
6. An actual data of database is stored in:
A.queries
B.wizard
C.form
D.table
Ans: A
7. The collection of related data organized in rows and columns called?
A.query
B.wizard
C.form
D.table
Ans:D
8. Each row in a table represents?
A. topple
B.record
C.table
D.field
Ans: B
9. which one is not true about the query?
A. a query can also allow performing a calculation on a different number of fields
B.a query allows accessing data of only one table of the database
C.a query is sorted question or request
D. none of these
Ans: B

10. A column is dived into one row is called?
A. Entities
B.relation ship
C.fields
D.record
Ans:C
11. Which of the following options represents the fundamental property of a relational database?
A. it may contain up to 10 column
B. it may contain many rows
C. it may contain multiple tables
D. none of these
Ans: C
12. Which one is the only used to display data?
A.report
B.query
C.form
D.none of these
Ans: A

13. The statement that extracts specific information is called?
A. query
B. report
C. wizard
D. table
Ans: A
14. In the form, the output of query is called?
A. table
B. query
C. wizard
D. form
Ans: A
15. The more flexible way of query is called?
A. add a record in a database
B. selecting record in the database
C.sorting record in a database
D.B&C both
Ans:D
16. The most powerful and popular DBMS is called?
A.MS-WORD
B.MS-outlook
C.MS-Access
D.MS-Powerpoint
Ans:C
17. every column in a table represents?
A.feild
B.field set
C.data set
D.topple
Ans: A
18. This object of the MS-Access database is used to create a user interface to perform different operations on the database to perform different operation on the database.
A.report
B.Query
C.form
D.wizard
Ans:C
19. At the following object, the object is used to display data as well as to change the data of the database?
A.report
B.form
C.table
D.wizard
Ans: B
20. The following objects used to retrieve data from the database?
A.merging records of the database
B.sorting record of the database
C.filtering record of the database
D.B &C both
Ans:D

Latest posts by Prof. Fazal Rehman Shamil (see all)

Buy advertisement space on T4Tutorials

For more details email [email protected]