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