No. of questions - 40
Time - 20 min
1.
Which object in Microsoft Access is used to display data in a printable format?
2.
Which of the following is a valid data type in Microsoft Access?
3.
Which feature in Microsoft Access allows you to import data from external sources such as Excel or CSV files?
4.
Which feature in Microsoft Access allows you to create cascading combo boxes, where the choices in one combo box depend on the selection made in another combo box?
5.
Which component of Microsoft Access is used to create a user-friendly interface for entering and viewing data?
6.
Which programming language is used in Microsoft Access for writing custom code?
7.
Which object in Microsoft Access is used to store pre-defined sets of actions that can be executed with a single command ?
8.
What is the purpose of a query in Microsoft Access?
9.
Which of the following statements is true about importing data in Microsoft Access?
10.
Which data type in Microsoft Access is used to store currency values?
11.
Which option in Microsoft Access allows you to create a data entry form based on a table or query?
12.
Which option in Microsoft Access allows you to define relationships between tables?
13.
Which property in Microsoft Access allows you to specify how the values in a field should be displayed?
14.
Which data type in Microsoft Access is used to store a date and time value?
15.
Which feature in Microsoft Access allows you to search for specific data within a table?
16.
Which Microsoft Office applications can be integrated with Microsoft Access?
17.
Which property in Microsoft Access determines the type of data that can be entered into a field?
18.
Which feature in Microsoft Access allows you to create a relationship between two tables based on a common field?
19.
Which option in Microsoft Access allows you to create a backup copy of your database?
20.
Which property in Microsoft Access allows you to set a default value for a field?
21.
In Microsoft Access, what is the purpose of the primary key in a table?
22.
Which feature in Microsoft Access allows you to protect your database with a password?
23.
Which option in Microsoft Access allows you to optimize the performance of your database by removing unnecessary objects and reducing file size?
24.
Which of the following best describes Microsoft Access?
25.
Which option in Microsoft Access allows you to define a specific sort order for records in a table or query?
26.
Which feature in Microsoft Access allows you to create custom formulas and perform complex calculations?
27.
What is the maximum number of characters allowed in a Text data type field in Microsoft Access?
28.
Which feature in Microsoft Access allows you to group and summarize data based on specific criteria?
29.
Which feature in Microsoft Access allows you to create custom functions and automate tasks using Visual Basic for Applications (VBA)?
30.
Which object in Microsoft Access is used to define the overall structure and organization of a database?
31.
What does the term "SQL" stand for in the context of Microsoft Access?
32.
Which feature in Microsoft Access allows you to create relationships between tables visually?
33.
Which object in Microsoft Access is used to store and organize data?
34.
Which option in Microsoft Access allows you to create a report that is grouped and sorted by multiple fields?
35.
Which feature in Microsoft Access allows you to automate tasks and add functionality to your database?
36.
Which feature in Microsoft Access allows you to split a database into front-end and back-end components?
37.
Which of the following is true about Access limitations?
38.
Which property in Microsoft Access allows you to enforce data validation rules for a field?
39.
Which object in Microsoft Access is used to specify a set of conditions for extracting specific records from a table?
40.
Which option in Microsoft Access is used to create calculations and perform operations on data?
