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.
Which key uniquely identifies each record in a table?
A primary key uniquely identifies each record in a table and prevents duplicate entries.
A field that links two tables together is called?
A foreign key creates a relationship between two tables by referring to the primary key of another table.
Which view is used to change the structure of a table?
Design View allows modification of table structure, including fields and data types.
A collection of related fields is known as?
A record is a complete set of related fields representing one entry in a table.
Which data type is used to store Yes or No values?
The Yes/No data type stores Boolean values such as True or False.
A database that contains only one table is called?
A flat database consists of a single table without relationships.
Which object displays data in a printable format?
Reports are used to format, summarize, and print data.
The process of removing duplicate data is known as?
Normalization organizes data to reduce redundancy and improve integrity.
Which query selects records based on criteria?
A Select query retrieves records that meet specific criteria.
A field that contains calculated values is called?
Calculated fields derive their values from expressions or formulas.
Which feature speeds up searching in a table?
Indexes improve search speed by allowing faster data retrieval.
The first row of a table usually contains?
Field names define the type of data stored in each column.
Which object controls data entry rules?
Validation rules restrict the type of data that can be entered.
A query that updates records is called?
An Update query modifies existing data in a table.
Which data type stores monetary values?
Currency data type is used for financial values with fixed precision.
A field that automatically generates numbers is called?
AutoNumber automatically generates unique numeric values.
Which view shows data exactly as users see it?
Form View displays data in a user-friendly interface.
A query that adds records to a table is called?
Append queries add new records to an existing table.
Which object can include buttons and controls?
Forms allow interactive controls such as buttons and text boxes.
A relationship based on one record linked to many is called?
One-to-many relationships link one record in a table to multiple records in another.
Which tool helps prevent incorrect data entry?
Validation rules enforce limits on data entry.
The language used in Access queries is called?
SQL (Structured Query Language) is used to manage and query databases.
Which object stores predefined actions?
Macros automate tasks by storing predefined actions.
A field that shows values from another table is called?
Lookup fields display values from related tables.
Which query summarizes data?
Crosstab queries summarize data in rows and columns.
The property that restricts field values is known as?
Validation properties limit acceptable field values.
Which Access object runs VBA code?
Modules store and execute VBA code.
A database made of related tables is called?
Relational databases use multiple related tables.
Which view shows SQL code of a query?
SQL View displays the SQL statement of a query.
The property that sets maximum field length is called?
Field Size determines the maximum allowed characters or size.
Which object can be exported to PDF?
Reports are commonly exported or printed as PDFs.
A condition used in a query is called?
Criteria specify conditions for selecting records.
Which feature protects a database with a password?
Encryption secures the database by protecting it with a password.