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