Computer Science - IT MCQs
Topic Notes: Computer Science - IT
<p>MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.</p>
Plato
- Biography: Ancient Greek philosopher (427–347 BCE), student of Socrates and teacher of Aristotle, founder of the Academy in Athens.
- Important Ideas:
- Theory of Forms
- Philosopher-King
- Ideal State
201
The object that is considered the "engine" that retrieves and processes data behind the scenes for forms and reports is the:
Answer:
Query
While you can base a form or report directly on a table, it is best practice to base them on queries. This allows you to pre-filter, sort, and calculate the data before it even reaches the form or report, making them more efficient and powerful.
202
A "Control" in the context of an Access form or report is:
Answer:
An object on the form/report, such as a text box, label, or button, that displays data or performs an action
Controls are the individual elements you place on a form or report to build its interface and functionality.
203
Which data type would be most appropriate for storing a person's date of birth?
Answer:
Date/Time
The Date/Time data type is specifically designed to store dates and times, and it allows you to perform date-based calculations and formatting.
204
The tabs that appear at the top of the main workspace, allowing you to switch between open objects, are called:
Answer:
Object Tabs
When you have multiple tables, forms, or other objects open at the same time, Access displays them as a series of tabs, making it easy to navigate between them.
205
What is the purpose of a Macro object in Access?
Answer:
To automate a sequence of actions or commands without needing to write code
Macros provide a simplified way to add functionality to your database, such as opening a form, running a report, or validating data when a button is clicked.
206
A "calculated field" in a query is a field that:
Answer:
Derives its value from a calculation performed on other fields in the query
You can create new fields directly in a query. For example, you could create a "TotalPrice" field by writing the expression `[Quantity] * [UnitPrice]`. This calculated value exists only when the query is run.
207
Which view for Forms and Reports allows you to see the live data while still being able to make design changes like resizing fields?
Answer:
Layout View
Layout View is a hybrid view that strikes a balance between Design View (no data) and Form/Report View (can't make changes). It's ideal for making visual adjustments because you can see the effect on your actual data immediately.
208
In a report, the "Group & Sort" feature is used to:
Answer:
Organize records into sections based on a field's value (e.g., group all sales by country)
Grouping is a key feature of reports. It allows you to create subtotals and other summary calculations for each group of records.
209
When you open an Access database, the first object that can be set to open automatically is called a:
Answer:
Start-Up Form
In the Access Options, you can specify a "Display Form" that will open automatically every time the database is launched, providing a main menu or starting point for the user.
210
The "Filter by Form" feature allows you to:
Answer:
Filter records by entering criteria into a blank version of the current form or datasheet
This is a user-friendly way to filter data. It provides an empty view where you can type criteria into one or more fields to find matching records.