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.
In MS Access, “Lookup Wizard” is used to?
find the meaning of a word
select values from Excel Sheet
select value from another table
None of the above
Correct answer is C
No explanation has been provided for this answer.
How can you remove a relationship defined between two tables in MS Access?
From Edit menu choose Delete Relationship
Choose Delete option from Relationship menu
Select the relationship line and press Delete
All of the above
Correct answer is C
No explanation has been provided for this answer.
___________ can be created to help easy data entry in MS Access tables ?
Form
Report
Database
Spreadsheet
Correct answer is A
No explanation has been provided for this answer.
What is the full form of OLE in MS Access ?
Object linking
Object linking and editing
Object linking and encrypting
Object linking and embedding
Correct answer is D
No explanation has been provided for this answer.
Which technique prevents invalid data being saved in Access table ?
Input mark
Index
Filter
Validation rule
Correct answer is D
No explanation has been provided for this answer.