MS-Access Multiple Choice Questoins - Set 1 for objective exam
1. Modules are
a. a selection of commands used to automate repetitive tasks
b. programs written in Visual Baisc
c. Object tabs
d. A group of records
Correct Answer: a
2. APPEND command is used to
a. Add Record to the start of active database file
b. Add record to the start of active database file and starts full screen data entry
c. Add record to the end of database file
d. Add record to the end of active database file and starts full screen data entry
Correct Answer: d
3. Append from command is used to
a. Adds records from a file
b. Add records from a variable
c. Add records from stock
d. Add records from information in an array
Correct Answer: d
4. Examples of centralized multi-user databases are
a. Airline reservations and other national global booking systems,
b. Barclays’ Bank customer accounts
c. Supermarket stock control, organ donor database, client database
d. None of above
Correct Answer: a
5. New record is added using
a. Append record from browse menu
b. Append record into from browse menu
c. Add record from edit menu
d. All of above
Correct Answer: a
6. When a customer makes an online hotel booking, the database is updated in
a. Batch mode
b. Pseudo real-time
c. 2 days
d. All of above
Correct Answer: b
7. What is the name for match between the words or phrases being searched and the items found in an electronic database?
a. Bug
b. Hit
c. It
d. Default
Correct Answer: b
8. A database that contains tables linked by common fields is called a
a. Centralized database
b. Flat file database
c. Relational database
d. None of above
Correct Answer: c
a. Collection of data
b. Set of programs to access those data
c. Set of programs to update those data
d. All of above
Correct Answer: d
10. COPY STRUCTURE command is used to
a. Copy contents of an active database to a new file
b. Copy all records of an active database to disk
c. Copy contents of an active database to disk
d. Copy structure of an active database to a new file
Correct Answer: d
11. COUNT command is used to
a. Count the number of data fields in an active database file
b. Count the number of data files which are active
c. Count the records which are updated
d. Count the number of records in an active database file
Correct Answer: d
12. What is the term to ask the computer to pt information in order numerically or alphabetically
a. Crop
b. Report
c. Sort
d. Organize
Correct Answer: c
13. The raw facts are called ….
a. Data
b. Programs
c. Commands
d. Responses
Correct Answer: a
14. What term refers to a collection of related information?
a. Database
b. List
c. Outline
d. Record
Correct Answer: a
15. A form that is used to collect data in a structured manner for entry to a database is called a
a. Database deign form
b. Systems flowchart
c. Data capture form
d. None of above
Correct Answer: c
16. The use of integrated collections of database records and files for data storage and processing. Select the best fit for answer:
a. Database management approach
b. DBMS uses
c. Database administrator
d. Query language
Correct Answer: d
17. A DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer
a. Database management approach
b. DBBMS uses
c. Database administrator
d. Query language
Correct Answer: d
18. A specialist in charge of the database of an organization select the best fit for answer
a. Database management approach
b. DBMS uses
c. Database administrator
d. Query language
Correct Answer: b
19. This DBMS feature allows users to easily interrogate a database. Select the best fit for answer
a. Database management approach
b. DBMS uses
c. Database administrator
d. Query language
Correct Answer: c
20. ….. presents data in a way similar to an excel spreadsheet
a. Datasheet view
b. Design view
c. Print preview
d. Layout preview
Correct Answer: c
|