Welcome to the 12th Class Computer Science Chapter 05 MCQs Online Test. We are presenting you with top MCQ questions from the 12th Class Computer Science Chapter Introduction of Microsoft Access.
We want to tell you that you can find all the 12th Class Computer Science Chapter 05 MCQs online tests on our website. These online tests are great for learning and as well as for scoring maximum marks in your Intermediate Exams. We are making these Class 12 Computer Science MCQs online tests for those who want full marks in their exams. Attempt all these Grade 12 Computer Science Online Multiple Choice Questions MCQs before going for the exam and it will be beneficial for you! These online tests contain all the important multiple choice questions in the important topics of the FSC Part-II Computer Science Chapter 05 Introduction of Microsoft Access.
12th Class Computer Science Chapter 05 MCQs with Answers
Youth For Pakistan has provided an excellent opportunity for the students of the 12th class to prepare their Computer Science Chapter 05 Introduction of Microsoft Access online with MCQs test.
This is a free platform for students to prepare for Computer Science Exams for Class 12 to get the best accomplishments in annual exams. 12th class Students can analyze themself by attempting this online test system as many times as they want until they find themself fully prepared.
MCQs Class 12 Computer Science with Answers
The purpose of these online MCQs tests is to help you evaluate your 12th Class Computer Science Chapter 05 MCQs. These Multiple Choice Questions (MCQs) will prepare you for your academic success in the 12th Class Exams. 12th Class Computer Science Chapters include Chapter No 1 Data basics, Chapter No 2 Basic Concepts And Terminology, Chapter No 3 Database Design Process, Chapter No 4 Data Integrity & Normalization, Chapter No 5 Introduction of Microsoft Access, Chapter No 6 Table and Query, Chapter No 7 Microsoft Access forms & Reports, Chapter No 8 Getting Started with C, Chapter No 9 Element Of C, Chapter No 10 Input/Output, Chapter No 11 Decision Constructors, Chapter No 12 Loop Constructors, Chapter No 13 Functions and Chapter No 14 File Handling in C.
Introduction of Microsoft Access
Ms Access is a database management tool that enables one to have a good command of data collected. The program enables one to retrieve, sort, summarize and report results speedily and effectively. It can combine data from various files by creating relationships, and can make data entry more efficient and accurate.
Chapter No 5 Introduction of Microsoft Access
1. A database consists of various components called the
- Tool
- Properties
- Entities
- Objects
2. Which of the following object is used to retrieve data from database and present in a formatted way choose which one is correct?
- Report
- Form
- Table
- Query
3. is the most popular and powerful DBMS choose which one is correct:
- Ms-word
- MS-Access
- Ms-Excel
- Ms-PowerPoint
4. MS-Access is a choose which one is correct:
- Network Database Management system
- Object-oriented database Management system.
- Relational database Management system
- All of these
5. represents of wizard of DBMS choose which one is correct:
- Database wizard
- Table wizard
- Form wizard
- All of these
6. is element MS-Access application window choose which one is correct:
- Title bar
- Tool bars
- Scrollbars
- All of these
7. Microsoft Access saves the database with the extension
- .mdb
- msdb
- madb
- None of them
8. A record is a complete set of __________fields
- Distinct
- Related
- Designed
- All of them
9. The actual data of database is stored in choose which one is correct:
- Tables
- Queries
- Forms
- Reports
10. is a collection of related data organized in rows and columns choose which one is correct:
- Table
- Query
- Report
- Form
11. In access, the structure of a table is created in ________view
- design view
- Datasheet View
- a and b both
- none of them
12. In a table each row represents a
- Record
- Field
- Form
- Data saet
13. In a table each column represents a
- Record
- Field
- Data set
- Entity
14. A query is a more flexible way of
- Selecting records from database
- Filtering records from database
- Sorting records from database
- All of above
15. A step by step procedure to perform a task easily available in a software is called
- Automation
- Manual
- Wizard
- None of Above
16. Using __________ you can create tables, forms, reports and queries in very short time
- Menus
- GUI
- Tools
- Wizard
17. A place where we can see all the tables and their relationship
- Window
- Dialog Box
- Relationship Window
- All of Above
18. is the fundamental property of relational database choose which one is correct:
- It may contain multiple tables.
- It contains only one table.
- It contains no tables.
- None of these
19. ________ is a statement that extracts specific information database.
- Table
- Query
- Report
- All of these
20. To automate repeated tasks __________are used
- Instructions
- Wizard
- Programming
- Macro
21. is true about query choose which one is correct:
- User can also change data in the database that fulfills certain criteria.
- A query also allows performing calculations of different number fields.
- The output of query is also displayed in the form of a table.
- All of these
22. is not true about a query choose which one is correct:
- A query can be used as source of records for Forms and reports
- A query is a stored question or request.
- A query allows to access data of only one table of database.
- None of these
23. objects of MS-Access database is used to create user-interface to perform different operations on database choose which one is correct:
- Report
- Query
- Macro
- Form
24. objects is used to display data as well as to change data of database choose which one is correct:
- Form
- Report
- Both (a) and (b)
- None
25. objects is used retrieve data from database and present in a formatted way choose which one is correct:
- Report
- Form
- Table
- Query
26. Which is not included in database wizard
- Template
- Selecting Fields
- Customizations
- Design Database
27. To create a database in file new database there is a button named
- Open
- Select
- Create
- None of Above
28. The bar which identifies the database application you are running in Microsoft Access
- Tool Bar
- Title Bar
- Status Bar
- Task Bar
29. In Access, the structure of a table can be created in choose which one is correct:
- Design View
- Datasheet View
- Both (a) and (b)
- None
30. is not a database object choose which one is correct:
- Form
- Table
- Window
- Query
31. The bottom most bar in Ms. Access is called
- Tool Bar
- Title Bar
- Status Bar
- Menu Bar
32. Which bar is used to see that CAPS button on keyboard is on
- Tool Bar
- Title Bar
- Status Bar
- Menu Bar
33. A window that organizes all objects in the database is called
- Window
- Database Window
- Dialog
- Database Dialog
34. A database may contain choose which one is correct:
- Only one table
- At least two table
- Many tables
- None
35. A report may be based on a choose which one is correct:
- Query
- Form
- Table
- Both (a) & (c)
36. Microsoft Access database window include __________ buttons
- Three
- Five
- Four
- Seven
37. There are _______ major database objects in Ms. Access
- Two
- Four
- Three
- Five
38. To database object which actually stores data is called
- Table
- Form
- Query
- Repor