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