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
111
To ensure that an exported report maintains its exact visual layout, fonts, and colors, the best format is:
Answer:
PDF or XPS
PDF and XPS are "page layout" formats designed specifically to preserve the look and feel of a document, making them ideal for distributing finished reports.
112
The "Saved Exports" button on the External Data tab allows you to:
Answer:
Manage and re-run export operations that you have saved
Similar to saved imports, this feature provides a one-click method for repeating a routine export task.
113
When would linking to a data source be a better choice than importing?
Answer:
When the data source is constantly being updated by other people and you need to see the most current data
Linking is the best option for live or shared data. Importing is better for data that does not change, or when you need to perform significant restructuring that you don't want to affect the original source.
114
Can you export the results of a query to a new table in another Access database?
Answer:
Yes, using the "Export > Access" option and specifying the destination database
Access provides tools to export objects, including tables created from queries, directly into another .accdb file.
115
What is a potential problem with importing data from an Excel file where a column contains mixed data types (e.g., numbers and text)?
Answer:
Access might guess the wrong data type for the field, causing some data to be imported incorrectly or not at all
Access scans the first several rows to determine a field's data type. If it sees only numbers, it may set the data type to "Number," and any text values further down in that column could be lost or cause errors during the import.
116
To import data from a SharePoint list, you would find the option under:
Answer:
External Data > New Data Source > From Online Services
SharePoint is considered an online service, and Access has a dedicated connector for importing or linking to SharePoint lists.
117
A "fixed-width" text file is one where:
Answer:
Each field occupies a specific, fixed number of character spaces in each row
In a fixed-width file, there are no delimiters. The import wizard determines where one field ends and the next begins based on character position (e.g., characters 1-10 are the first name, 11-25 are the last name).
118
You can export an Access object directly to an email message as:
Answer:
A file attachment in various formats (e.g., PDF, Excel)
The "Email" command in the Export group allows you to quickly export an object and attach the resulting file to a new Outlook email message in one step.
119
What is a key consideration when importing data into an existing table?
Answer:
The data types of the source fields must be compatible with the data types of the destination fields
The append operation will fail if you try to put text data into a number field, or a non-date value into a date field. The columns must align in a compatible way.
120
Which export option would you use to create a document for a mail merge in Microsoft Word?
Answer:
Rich Text Format (.rtf) or Word (.docx)
Access has a specific "Word Merge" feature that guides you through exporting query data and launching Microsoft Word to perform a mail merge for letters or labels.