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