This is the Set 10 of MCQ Questions from MS Access Database Management System. Hope these questions are helping you to prepare the exam.
Please click on ‘Show correct answer’ link to reveal the correct answers.
Gold Members of ICT Trends can download all these sets as a single PDF file so that it will be easier for you to revise and prepare while you are offline.
Gold Members can attempt Online MCQ Quiz so that you can test yourself and know your score. Check where you standing among other candidates.
Please visit http://prepare.icttrends.com to learn about ICT Trends Gold Membership.
MS Access Database Management System
MCQ Set 10
1. When a picture or other graphic image is placed in the report header section it will appear____
a. Once in the beginning of the report
b. At the top of every page
c. Every after record break
d. On the 1st and last pages of the report
Show correct answerCorrect Answer: a. Once in the bugging of the report
2. Cascade delete option
a. is used to delete all the records of all tables in a database
b. will repeat the recent delete operation to all the records of current table
c. is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted
d. None of above
Show correct answerCorrect Answer: c. is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted
3. This data type allows alphanumeric characters and special symbols.
a. text
b. memo
c. auto number
d. None of the above
Show correct answerCorrect Answer: a. text
4. Query design window has two parts. The upper part shows
a. Name of fields, field type and size
b. Tables with fields and relationships between tables
c. Criteria
d. Sorting check boxes
Show correct answerCorrect Answer: b. Tables with fields and relationships between tables
5. In a database table, the category of information is called ____________
a. tuple
b. field
c. record
d. All of above
Show correct answerCorrect Answer: b. field
6. To create a new table, in which method you don’t need to specify the field type and size?
a. Create table in Design View
b. Create Table using wizard
c. Create Table by Entering data
d. All of above
Show correct answerCorrect Answer: c. Create Table by Entering data
7. Which of the following is not a database object?
a. Tables
b. Queries
c. Relationships
d. Reports
Show correct answerCorrect Answer: c. Relationships
8. In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______
a. Child , Parent
b. Parent , Child
c. Brother , Sister
d. Father , Son
Show correct answerCorrect Answer: b. Parent , Child
9. The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
a. relationship
b. Join
c. Query
d. None of these
Show correct answerCorrect Answer: a. relationship
10. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
a. Home Tab
b. Create Tab
c. External Data Tab
d. Database Tab
Show correct answerCorrect Answer: d. Database Tab
Great posting. I hope this can give me more value especially in learning MS Access Database Management System. Thank you very much for sharing this useful information
Thank you Heru for the comment. I hope it will help the candidates of Computer Jobs Exams.
Suresh Khanal recently posted…MS Access MCQ Bank Set 10
hello sir good after noon. sir hame le questions kasari daily update dareko pauna sak6u ni plz information deyama very aabhari hune 6u sir.
Please enter your email address in ‘Free email notification’ box on the right panel. You’ll get an email notification whenever a new post is added.
Suresh Khanal recently posted…Celebrating Birthday! 3 Months Free Gold Membership till January 30