We started the preparation sessions of this year with Database Management System – MS Access as I found most of the candidates find problems in Access compared to the Word and Excel questions.
Here is the fifth set of MCQ Bank for MS Access Database Management System. Gold Members of ICT Trends can download a PDF file containing all these questions through your ‘Downloads’ folder in Member’s Area.
Similarly, Gold Members can attempt online quiz for Database and MS Access by visiting Online MCQ Quiz.
ICT Trends has sufficient preparation materials available publicly and it is not compulsory to join Gold Membership. However, being a gold membership, you’ll enjoy some exclusive services such as:
User Question Forum – Ask your confusions and questions. I answer every questions you leave there.
Downloads – Get the files into your computer and prepare while you are offline
Online MCQ Quiz – Select the set and attempt online self-test. You can mark the correct answer from among the given options and submit. The system will check your answer and calculate score. It displays questions, options, your answer, correct answer so that you can find where you made mistake.
Notes, Handouts and Lessons – Some extra learning materials to help you understand the topic better.
Please visit http://prepare.icttrends.com to learn more about Gold Membership and know how you can join it.
MS Access 2007 & 2010 Database Management System
MCQ Set 05
1. It is a database object to view, change, and analyze data in different ways
a. query
b. form
c. report
d. None of the above
What is correct answer?Correct Answer: a. query
2. Which of the following creates a drop down list of values to choose from a list?
a. OLE Object
b. Hyperlink
c. Memo
d. Lookup Wizard
What is correct answer?Correct Answer: d. Lookup Wizard
3. To achieve AND effect when you are entering criteria in a query design window
a. write criteria values vertically one in a row
b. write criteria values horizontally
c. Write criteria values in same field separated with AND
d. Write criteria values in same field separated with &
What is correct answer?Correct Answer: b. write criteria values horizontally
4. A search value can be an exact value or it can be
a. Logical Operator
b. Relationship
c. Wild card character
d. Comparison operation
What is correct answer?Correct Answer: c. Wild card character
5. What are the columns in a Microsoft Access table called?
a. Rows
b. Records
c. Fields
d. Columns
What is correct answer?Correct Answer: c. Fields
6. What is a form in MS Access
a. It is a printed page where users will write their data to fill it up
b. It is an input screen designed to make the viewing and entering data easier
c. This is an important part of database used by analysts to draw conclusions
d. All of above
What is correct answer?Correct Answer: b. It is an input screen designed to make the viewing and entering data easier
7. 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
a. Clicking
b. Right clicking
c. Double clicking
d. None of the above
What is correct answer?Correct Answer: c. Double clicking
8. It is a sign or symbol that specifies, operator, and values that produce a result
a. operator
b. query
c. expression
d. None of the above
What is correct answer?Correct Answer: a. operator
9. We can remove a relationship defined between two tables by
a. From Edit menu choose Delete Relationship
b. Select the relationship line and press Delete
c. Choose Delete option from Relationship menu
d. All of above
What is correct answer?Correct Answer: b. Select the relationship line and press Delete
10. Unlike text data type, this can store up to maximum of 65, 535 characters.
a. memo
b. data/time
c. number
d. All of above
What is correct answer?Correct Answer: a. memo
Copyright secured by Digiprove © 2013 Suresh Khanal 
Sir,
Thank you very much for your reply.
especially i would like to know about conditional formatting in Ms-Access.
my question is:
1. i have table for result in access (which is As like Result sheet in excel)
2. i have many records in access result table
3. there are some records less then 32 marks in different subjects and different students list
4. now, i need to view records less than 32 with red color.
how is this possible in Ms-Access?
if possible then please send me the process or your suggestion.
Hi Ashok,
You posted the follow up to some other post and the original question to some other. Anyway, I could remember the earlier post. Please use ICT Trends Forum (http://icttrends.com/forum) if you are Gold Member.
I’ve prepared a video to solve your question. Please visit the link below to watch it:
Conditional Formatting in MS Access
Suresh Khanal recently posted…MS Access MCQ Bank Set 07