Please keep at least one language enabled. || కనీసం ఒక భాషను ఎంచుకోండి.
Question 1
ప్రశ్న 1
Microsoft Access is primarily classified as which type of application software?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Microsoft Access is a database management application used to create and work with databases.
• It provides objects such as tables, queries, forms and reports for storing, retrieving, entering and presenting data.
• PowerPoint is presentation software and Excel is primarily spreadsheet software.
• It provides objects such as tables, queries, forms and reports for storing, retrieving, entering and presenting data.
• PowerPoint is presentation software and Excel is primarily spreadsheet software.
వివరణ:
Question 2
ప్రశ్న 2
Which term best describes an organized collection of related information that can be stored, managed and retrieved using Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A database is an organized collection of related information designed for storage, management and retrieval.
• Microsoft Access provides tools for creating and managing such databases.
• A workbook belongs primarily to spreadsheet software, while documents and slide shows serve different purposes.
• Microsoft Access provides tools for creating and managing such databases.
• A workbook belongs primarily to spreadsheet software, while documents and slide shows serve different purposes.
వివరణ:
Question 3
ప్రశ్న 3
Which file extension is the default modern Microsoft Access database format?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Modern versions of Access normally create new databases in the .accdb file format.
• The older Access 2000 and Access 2002-2003 database formats use the .mdb extension.
• .xlsx and .pptx are associated with Excel and PowerPoint respectively.
• The older Access 2000 and Access 2002-2003 database formats use the .mdb extension.
• .xlsx and .pptx are associated with Excel and PowerPoint respectively.
వివరణ:
Question 4
ప్రశ్న 4
Which Access object is primarily used to store the actual database data in rows and columns?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Tables are the fundamental Access objects used to store database data.
• A table organizes related information into rows and columns.
• Queries retrieve or manipulate data, forms provide interfaces for working with data and reports present data in formatted form.
• A table organizes related information into rows and columns.
• Queries retrieve or manipulate data, forms provide interfaces for working with data and reports present data in formatted form.
వివరణ:
Question 5
ప్రశ్న 5
A database contains thousands of records, but a user wants to retrieve only the information satisfying specified conditions. Which Access object is primarily designed for this task?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Queries are used to retrieve and work with selected information from database data sources.
• A query can focus on data that satisfies specified conditions or includes particular fields.
• Reports are mainly intended for formatted presentation, while macros and modules are associated with automation and programming.
• A query can focus on data that satisfies specified conditions or includes particular fields.
• Reports are mainly intended for formatted presentation, while macros and modules are associated with automation and programming.
వివరణ:
Question 6
ప్రశ్న 6
Which Microsoft Access object is commonly used to provide a convenient screen for entering, viewing or editing database data?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Forms provide a user-friendly interface for working with data stored in tables or returned by queries.
• They can be designed to make data entry, viewing and editing easier than working directly in a table.
• Reports serve a different purpose by presenting information in a formatted output-oriented form.
• They can be designed to make data entry, viewing and editing easier than working directly in a table.
• Reports serve a different purpose by presenting information in a formatted output-oriented form.
వివరణ:
Question 7
ప్రశ్న 7
A police office wants a neatly formatted monthly summary of database information suitable for viewing or printing. Which Access object is most appropriate?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Reports are designed to present database information in an organized and formatted manner.
• They are especially useful for summaries, grouped information and printable output.
• Tables principally store data, while macros and modules are associated with automation.
• They are especially useful for summaries, grouped information and printable output.
• Tables principally store data, while macros and modules are associated with automation.
వివరణ:
Question 8
ప్రశ్న 8
Which Access object can be used to automate a sequence of database actions without requiring the user to manually perform each action?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• An Access macro can automate tasks by carrying out one or more predefined actions.
• Macros are useful for repetitive database operations and interface behaviour.
• Tables store data, forms provide interfaces and reports are used mainly for formatted output.
• Macros are useful for repetitive database operations and interface behaviour.
• Tables store data, forms provide interfaces and reports are used mainly for formatted output.
వివరణ:
Question 9
ప్రశ్న 9
What is the primary purpose of the Navigation Pane in Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Navigation Pane lists database objects and provides a convenient way to locate and open them.
• Objects such as tables, queries, forms, reports, macros and modules can appear there.
• It is an object-navigation interface rather than a database backup or conversion tool.
• Objects such as tables, queries, forms, reports, macros and modules can appear there.
• It is an object-navigation interface rather than a database backup or conversion tool.
వివరణ:
Question 10
ప్రశ్న 10
Which Microsoft Access object can contain Visual Basic for Applications (VBA) procedures for more advanced database automation?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• An Access module contains VBA declarations and procedures used for programming database behaviour.
• Modules provide capabilities beyond simple stored data or formatted output.
• Tables store data and reports present information; the Navigation Pane is an interface component rather than a programmable database object of this type.
• Modules provide capabilities beyond simple stored data or formatted output.
• Tables store data and reports present information; the Navigation Pane is an interface component rather than a programmable database object of this type.
వివరణ:
Question 11
ప్రశ్న 11
Which sequence correctly starts the creation of a new database from scratch in current desktop Microsoft Access?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• File > New opens the options for creating a new Access database.
• Choosing Blank Database allows a database to be built from scratch rather than from a prepared template.
• The user can then specify the file name and location before selecting Create.
• Choosing Blank Database allows a database to be built from scratch rather than from a prepared template.
• The user can then specify the file name and location before selecting Create.
వివరణ:
Question 12
ప్రశ్న 12
When a standard new Blank Database is created in current desktop Access, what does Access normally create and open initially?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• When a standard blank database is created, Access creates an empty table named Table1.
• Table1 is initially opened in Datasheet view so that data can be entered or fields can be added.
• Access does not automatically create a report, form or query as the initial object in this standard blank-database workflow.
• Table1 is initially opened in Datasheet view so that data can be entered or fields can be added.
• Access does not automatically create a report, form or query as the initial object in this standard blank-database workflow.
వివరణ:
Question 13
ప్రశ్న 13
What is an Access database template?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• An Access template is a ready-to-use database starting point designed for a particular data-management purpose.
• A template can contain predefined tables, queries, forms, reports, macros and relationships.
• Using a suitable template can save substantial setup time compared with building every database object from scratch.
• A template can contain predefined tables, queries, forms, reports, macros and relationships.
• Using a suitable template can save substantial setup time compared with building every database object from scratch.
వివరణ:
Question 14
ప్రశ్న 14
Which statement best describes Microsoft Access Backstage view?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Backstage view is accessed through the File tab and deals with the database file rather than ordinary object-level editing.
• It provides operations such as creating a new database, opening an existing database and other file-related commands.
• Editing individual table records occurs within database objects rather than primarily in Backstage view.
• It provides operations such as creating a new database, opening an existing database and other file-related commands.
• Editing individual table records occurs within database objects rather than primarily in Backstage view.
వివరణ:
Question 15
ప్రశ్న 15
In the Access Navigation Pane, what is a standard method for opening an existing table, form or report?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A database object can normally be opened by double-clicking it in the Navigation Pane.
• An object can also be selected and opened using other supported commands, such as pressing Enter or choosing Open from its shortcut menu.
• The object does not need to be renamed, deleted or converted before it can be opened.
• An object can also be selected and opened using other supported commands, such as pressing Enter or choosing Open from its shortcut menu.
• The object does not need to be renamed, deleted or converted before it can be opened.
వివరణ:
Question 16
ప్రశ్న 16
A user is building a database from scratch and needs to add a new database object. Which Ribbon tab contains commands for creating objects such as tables, queries, forms and reports?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• The Create tab contains commands for creating major Access database objects.
• From this tab, users can create tables, queries, forms, reports and certain other objects using different methods and wizards.
• The tab therefore plays a central role when building a database from scratch.
• From this tab, users can create tables, queries, forms, reports and certain other objects using different methods and wizards.
• The tab therefore plays a central role when building a database from scratch.
వివరణ:
Question 17
ప్రశ్న 17
Consider the following statements about Microsoft Access objects:
1. Tables are used primarily to store data.
2. Queries can retrieve selected information from database data.
3. Forms can provide interfaces for entering or viewing data.
4. Reports are primarily designed to store the original database data permanently.
Which statements are correct?
1. Tables are used primarily to store data.
2. Queries can retrieve selected information from database data.
3. Forms can provide interfaces for entering or viewing data.
4. Reports are primarily designed to store the original database data permanently.
Which statements are correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Statements 1, 2 and 3 correctly describe the major purposes of tables, queries and forms.
• Statement 4 is false because reports are primarily used to format, summarize and present data rather than serve as the underlying permanent data-storage object.
• Therefore Statements 1, 2 and 3 only are correct.
• Statement 4 is false because reports are primarily used to format, summarize and present data rather than serve as the underlying permanent data-storage object.
• Therefore Statements 1, 2 and 3 only are correct.
వివరణ:
Question 18
ప్రశ్న 18
Which statement about creating an Access database from a template is correct?
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• Access templates can provide complete predefined database structures containing useful objects.
• After a database is created from a template, its design and objects can be customized to suit the user's requirements.
• Templates therefore provide a starting point rather than permanently locking the database into an unchangeable design.
• After a database is created from a template, its design and objects can be customized to suit the user's requirements.
• Templates therefore provide a starting point rather than permanently locking the database into an unchangeable design.
వివరణ:
Question 19
ప్రశ్న 19
Assertion (A): Creating an Access database by using a suitable template can be faster than building the entire database from scratch.
Reason (R): An Access template can already contain predefined tables, queries, forms, reports and other components for a particular purpose.
Choose the correct answer.
Reason (R): An Access template can already contain predefined tables, queries, forms, reports and other components for a particular purpose.
Choose the correct answer.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A suitable template can eliminate the need to create every required database object manually.
• Templates can include predefined tables, queries, forms, reports, macros and other database components.
• Both statements are true, and the Reason directly explains why a template can speed up database creation.
• Templates can include predefined tables, queries, forms, reports, macros and other database components.
• Both statements are true, and the Reason directly explains why a template can speed up database creation.
వివరణ:
Question 20
ప్రశ్న 20
Match List I with List II:
List I
(a) Table
(b) Query
(c) Form
(d) Report
List II
1. Presents database information in an organized format suitable for viewing or printing
2. Stores database data
3. Provides an interface that can be used for data entry and viewing
4. Retrieves or works with selected data according to specified requirements
Choose the correct matching code.
List I
(a) Table
(b) Query
(c) Form
(d) Report
List II
1. Presents database information in an organized format suitable for viewing or printing
2. Stores database data
3. Provides an interface that can be used for data entry and viewing
4. Retrieves or works with selected data according to specified requirements
Choose the correct matching code.
Select an option first. || ముందుగా ఒక సమాధానాన్ని ఎంచుకోండి.
Explanation:
• A Table stores data, giving (a)-2, while a Query retrieves or works with selected data, giving (b)-4.
• A Form provides a data-oriented user interface, giving (c)-3.
• A Report presents information in an organized output-oriented format, giving (d)-1.
• A Form provides a data-oriented user interface, giving (c)-3.
• A Report presents information in an organized output-oriented format, giving (d)-1.
వివరణ:
Answer Key సమాధానాల పట్టిక
-
Question 1 ప్రశ్న 1Answer: C. Database management software సమాధానం: C.
-
Question 2 ప్రశ్న 2Answer: A. Database సమాధానం: A.
-
Question 3 ప్రశ్న 3Answer: D. .accdb సమాధానం: D.
-
Question 4 ప్రశ్న 4Answer: B. Table సమాధానం: B.
-
Question 5 ప్రశ్న 5Answer: B. Query సమాధానం: B.
-
Question 6 ప్రశ్న 6Answer: C. Form సమాధానం: C.
-
Question 7 ప్రశ్న 7Answer: A. Report సమాధానం: A.
-
Question 8 ప్రశ్న 8Answer: D. Macro సమాధానం: D.
-
Question 9 ప్రశ్న 9Answer: A. To display and provide access to database objects such as tables, queries, forms and reports సమాధానం: A.
-
Question 10 ప్రశ్న 10Answer: C. Module సమాధానం: C.
-
Question 11 ప్రశ్న 11Answer: D. File > New > Blank Database సమాధానం: D.
-
Question 12 ప్రశ్న 12Answer: B. An empty table named Table1 in Datasheet view సమాధానం: B.
-
Question 13 ప్రశ్న 13Answer: C. A ready-made database starting point that can contain predefined tables, queries, forms, reports and other objects సమాధానం: C.
-
Question 14 ప్రశ్న 14Answer: D. It provides file-level operations such as creating a new database and opening an existing database. సమాధానం: D.
-
Question 15 ప్రశ్న 15Answer: B. Double-click the required object in the Navigation Pane. సమాధానం: B.
-
Question 16 ప్రశ్న 16Answer: A. Create సమాధానం: A.
-
Question 17 ప్రశ్న 17Answer: C. 1, 2 and 3 only సమాధానం: C.
-
Question 18 ప్రశ్న 18Answer: C. A template can provide predefined database objects and can then be customized for the user's requirements. సమాధానం: C.
-
Question 19 ప్రశ్న 19Answer: A. Both Assertion and Reason are true, and Reason is the correct explanation of Assertion. సమాధానం: A.
-
Question 20 ప్రశ్న 20Answer: B. (a)-2, (b)-4, (c)-3, (d)-1 సమాధానం: B.