A basic knowledge of Microsoft Office applications such as MS Word, MS Excel and MS PowerPoint is often required for most jobs. Practise and prepare for your aptitude test with these frequently asked MS Office questions and answers.
How can you quickly reinstate a deleted footer placeholder in PowerPoint master view?
Create a new slide master
Re-apply the footer placeholder
Re-apply the slide layout
All of the above
Correct answer is B
No explanation has been provided for this answer.
Cascade update option in Access
means do not change the value in the primary key field if that record has related records in another table
means change all the related records in child tables if the record in parent table is changed
Both of above
None of above
Correct answer is C
The Cascade update option in the context of database relationships refers to the behavior that occurs when you modify a record in the parent (or primary) table. Both of the provided options are accurate descriptions of the cascade update option:
Option A: When you enable the cascade update option, it means that if you change the value in the primary key field of a record in the parent table, the related records in the child tables will also be updated to reflect the changes in the parent table. This ensures that the relationships between records remain consistent even when the primary key values change.
Option B: Similarly, enabling the cascade update option will change all the related records in child tables when the record in the parent table is changed. This ensures that any changes made to the parent table's primary key values are propagated to the related child records.
Option C: Both of the above options are true. Enabling cascade update means that changes to primary key values are propagated to related records in child tables, and this applies to both the parent and child records.
Option D: Neither option A nor option B is false. Therefore, the correct answer is Option C: Both of above.
In summary, the cascade update option maintains data integrity by ensuring that changes to primary key values in the parent table are reflected in the related records of the child tables.
The slide that is used to introduce a topic and set the tone for the presentation is called the
table slide
graph slide
bullet slide
title slide
Correct answer is D
No explanation has been provided for this answer.
How can you display the relationships in an Access database?
Select View > Relationship from the menu
Click the Relationship button on the toolbar
Select Edit >Relationship from the menu
All the above are true
Correct answer is D
You can display relationships in a database in Microsoft Access using multiple methods, all of which are mentioned in the options:
Option A: To display relationships, you can select View > Relationships from the menu. This will open the Relationships window where you can view and manage the relationships between tables.
Option B: Clicking the Relationships button on the toolbar also allows you to display relationships. This button typically resembles a set of linked tables and provides a convenient way to access the Relationships window.
Option C: While not the most common method, you can also select Edit > Relationships from the menu to open the Relationships window and view the database's relationships.
Option D: All of the above options are indeed true. Each of these methods serves the purpose of displaying the relationships in a database, allowing you to visualize and manage how tables are connected to each other.
Therefore, the correct option is Option D: All the above are true.
Which option allows you to select line, curve, freeform or scribble tools in PowerPoint?
Create effect
Insert motion path
Draw custom path
All of the above
Correct answer is C
No explanation has been provided for this answer.