Here is the MCQ Set 08 for MS Access Database Management System. I believe these questions are helping you to prepare Computer Operator or Data Entry Supervisor Examination. The questions are equally useful to the Assistant Computer Operator Exam as well.
We started this year’s preparation sessions with MS Access and by now, we’ve covered almost all of the probable questions from Access. However, we’ll still to go with a few more sets from MS Access to complete.
I guess Gold Members have already downloaded these sets as single PDF file and prepared with them. You are suggested to attempt different tests available in Online MCQ Quiz. Make sure that you can answer all of the questions in allocated time.
Allow a few moments for the system to check your answers and calculate score. It will display the correct answers and your answer on the same page. Have patience and wait for one or two seconds.
Please use User Questions Forum (http://prepare.icttrends.com) if you are facing problems in any aspect of Database concepts or MS Access.
MS Access Database Management System
MCQ Set 09
1. This is the stage in database design where one gathers and lists all the necessary fields for the database project.
a. data definition
b. data refinement
c. establishing relationship
d. none of the above
Show correct answerCorrect Answer: a. data definition
2. The two form layout types will display multiple records at one time are tabular and___
a. columnar
b. justified
c. date sheet
d. pivot table
Show correct answerCorrect Answer: b. justified
3. The size of a field with Number data type can not be
a. 2
b. 4
c. 8
d. 16
Show correct answerCorrect Answer: d. 16
4. A small button with three dots usually displayed at the right of field properties box
a. Make button
b. Expression button
c. Build button
d. None of above
Show correct answerCorrect Answer: c. Build button
5. The size of Yes No field is always
a. 1 bit
b. 1 byte
c. 1 character
d. 1 GB
Show correct answerCorrect Answer: a. 1 bit
6. This key uniquely identifies each record
a. primary key
b. key record
c. unique key
d. field name
Show correct answerCorrect Answer: a. primary key
7. The command center of access file that appears when you create or open the MS Access database file.
a. Database Window
b. Query Window
c. Design View Window
d. Switchboard
Show correct answerCorrect Answer: a. Database Window
8. A database language concerned with the definition of the whole database structure and schema is ________
a. DCL
b. DML
c. DDL
d. All of above
Show correct answerCorrect Answer: c. DDL
9. When creating a new table which method can be used to choose fields from standard databases and tables
a. Create table in Design View
b. Create Table using wizard
c. Create Table by Entering data
d. None of above
Show correct answerCorrect Answer: b. Create Table using wizard
10. What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
a. A relationship is created
b. Edit relationship dialog box appears
c. Error occurs
d. Nothing happens
Show correct answerCorrect Answer: b. Edit relationship dialog box appears
The most common reason to split a database is that you are sharing the database with multiple users on a network. If you simply store the database on a network share, when your users open a form, query, macro, module, or report, these objects have to be sent across the network to each individual who uses the database. If you split the database, each user has their own copy of the forms, queries, macros, modules, and reports. Therefore, the only data that must be sent across the network is the data in the tables. Note To split the database, you can also use the Database Splitter utility.