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
121
The "Append a copy of the records to the table" option in the import wizard is used when you want to:
Answer:
Add the imported data as new records to an existing table
This option is used when you have a table already set up and you want to add more records to it from an external file, assuming the columns match.
122
When you link to a data source, can you change the table's structure (e.g., add or delete fields) from within Access?
Answer:
No, the structure of a linked table can only be changed in the original source application
Since a linked table is just a pointer, its fundamental design (field names, data types) is controlled by the source file (e.g., the Excel spreadsheet or the source Access database).
123
What is a "delimited" text file?
Answer:
A text file where the columns are separated by a specific character, such as a comma or a tab
Delimited files are a common way to structure data. The "delimiter" is the character that signals the end of one field and the beginning of the next.
124
The "Get & Transform Data" features (also known as Power Query) in modern Access and Excel are used for:
Answer:
Advanced data cleaning, shaping, and transformation before the final import
Power Query is a powerful tool that allows you to perform complex data manipulation steps, such as splitting columns, unpivoting data, or merging files, as part of the import process.
125
To start the process of bringing data from an Excel spreadsheet into a new Access table, you would go to:
Answer:
External Data > New Data Source > From File > Excel
All import operations are initiated from the "New Data Source" group on the External Data tab of the Ribbon.
126
Which of the following is NOT a common source for importing data into Access?
Answer:
A Photoshop (.psd) File
Access is designed to work with structured, tabular data. While it can store image files in attachments, it cannot import data directly from a proprietary image editing format like PSD.
127
When linking to a table in another Access database, what does Access create in your current database?
Answer:
A shortcut, or pointer, to the original table
Linking creates a table object in your Navigation Pane that looks and acts like a normal table, but the data itself remains stored in the original source database. This is fundamental to splitting a database.
128
What is the purpose of saving import or export steps?
Answer:
To allow you to quickly re-run the same import or export operation in the future without going through the wizard again
If you have a task you perform regularly, like importing a new sales report every week, saving the steps allows you to turn it into a one-click operation.
129
If you want to send a formatted, non-editable version of an Access report to a colleague who does not have Access, which is the best export format?
Answer:
PDF (.pdf)
Exporting a report to PDF creates a document that preserves all the formatting, layout, and graphics of the report. It can be opened by anyone with a free PDF reader and cannot be easily edited.
130
When importing data from an Excel file, the Import Wizard allows you to:
Answer:
All of the above
The Import Wizard guides you step-by-step through the process, giving you options to ensure the data is brought into Access correctly, including interpreting column headers and setting a primary key.