Introduction To Microsoft Access - MCQs Quiz

 

Introduction To Microsoft Access - MCQs Quiz. Find the most important and more conceptual multiple-choice questions (MCQs) with answers of Computer, ICS Part-II Chapter No.5: Introduction to Microsoft Access, for the exams and entry tests i.e. ECAT and general database interview MCQs based questions for jobs:

 

This post regarding ICS Part-2 Computer Chap No.5: Introduction to Microsoft Access MCQs | Online Quiz covers the topics i.e., an overview of the database, DBMS (Database Management System), RDBMS (Relational (Database Management System), features of Microsoft Access database, creating a new database, create database using wizard, open an existing database, MS-Access application window, database window, and database objects (i.e., tables, queries, forms, and reports):

 

➤ Introduction To MS-Access - Short Questions
➤ Forms & Reports - MCQs
➤ Data Integrity & Normalization
➤ Database Design Process
➤ Basic Concepts & Terminology of Databases
➤ Data Basics
➤ Getting Started with C
➤ Elements of C
➤ Input/Output 
➤ Decision Constructs
➤ Loop Constructs
➤ Functions in C
➤ File Handling
➤ Table and Query

Chapter No.5
Introduction to Microsoft Access

MCQs | Online Quiz

 

1. An application programmer creates forms with the help of?
   1.   Database
   2.   Queries
   3.   DBMS
   4.   Database objects
2. Another name used for columns of a relation is?
   1.   Records
   2.   Forms
   3.   Fields
   4.   Reports
3. Followings are the database objects except?
   1.   Report
   2.   Table
   3.   Window
   4.   Form
4. Following operations can be performed through query languages except?
   1.   Data deletion
   2.   Data insertion
   3.   Data creation
   4.   Data editing
5. If you have already created database and create another with same name, the data will be?
   1.   Same
   2.   Printed
   3.   Overwritten
   4.   None of these
6. In a database, each separate piece of information is stored in?
   1.   Records
   2.   DBMS
   3.   Fields
   4.   None of these
7. The database wizard includes?
   1.   Database templates
   2.   Adding pictures
   3.   Selecting fields
   4.   All of these
8. The duplication of information refers to?
   1.   Data integrity
   2.   Photocopy
   3.   Data redundancy
   4.   Backup
9. The queries are most flexible way for?
   1.   Selecting data from database
   2.   Sorting data from database
   3.   Filtering data from database
   4.   All of these
10. To automate the repetitive task, the term used is?
    1.   Macro
    2.   Wizard
    3.   Loop
    4.   None of these
11. To interact with database which of the following database object is used as interface?
    1.   Table
    2.   Form
    3.   Report
    4.   Query
12. We cannot use reports for?
    1.   Retrieving data
    2.   Presenting data
    3.   Changing data
    4.   Retrieving data + presenting data
13. Which of the following can be used to identify name of document?
    1.   Menu bar
    2.   Tool bar
    3.   Title bar
    4.   Scroll bar
14. Which of the following database object is used to analyze the data?
    1.   Table
    2.   Form
    3.   Report
    4.   Query
15. Which of the following is an example of DBMS?
    1.   FoxPro
    2.   MySQL
    3.   MS Access
    4.   All of these
16. Which of the following operation can be performed through forms?
    1.   Entering data
    2.   Editing data
    3.   Deleing data
    4.   All of these
17. Which of the following view is used to create a table structure?
    1.   Design view
    2.   Dataset view
    3.   Datasheet view
    4.   Database view
18. ___ refers to a step by step technique to complete an assignment in particular software?
    1.   Algorithm
    2.   Wizard
    3.   Macro
    4.   Statements of procedure