Computer Science MCQs – MS Access (Job Test Preparation in Pakistan)
What is MS Access?
MS Access is a database management system used for storing and managing data.
Which file format is used by default for MS Access databases?
The default file format for MS Access databases is .accdb.
What is a table in MS Access?
A table in MS Access is a collection of records used to store data.
Which object in MS Access is used to enter, edit, and view records?
A form in MS Access is used to enter, edit, and view records.
Which object is used to ask a question of the data in MS Access?
A query in MS Access is used to ask a question of the data.
What is the purpose of a report in MS Access?
A report in MS Access is used to print and summarize data.
What is a query used for in MS Access?
A query in MS Access is used to retrieve and filter data.
What is a form used for in MS Access?
A form in MS Access is used to input and display data.
What does the Datasheet View display?
Datasheet View in MS Access displays data in rows and columns.
How do you establish a relationship between tables?
Relationships between tables in MS Access are established using primary keys and foreign keys.
What is the function of the 'Form Wizard'?
The 'Form Wizard' in MS Access helps design forms easily.
Which of the following is NOT a data type in MS Access?
Graph is not a data type in MS Access.
What is a module in MS Access?
A module in MS Access is a collection of VBA code.
How can you import data into an MS Access database?
You can import data into an MS Access database by using the Import Wizard.
Which data type is used for storing large amounts of text in MS Access?
Long Text is the data type used for storing large amounts of text in MS Access.
What is the maximum number of characters allowed in a Short Text field in MS Access?
The maximum number of characters allowed in a Short Text field in MS Access is 255.
Which object type in MS Access can be used to automate tasks?
A macro in MS Access can be used to automate tasks.