MS Access Questions & Answers | Basic Computer Knowledge
- 1. In MS-Access press CTRL+O to
A.)
Open a new database
B.)
Open an existing database
C.)
Exit MS-Access
D.)
None of these
Answer: Option 'B'
Open an existing database
- 2. In MS-Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or
A.)
F4 or ALT+DOWN ARROW
B.)
DOWN ARROW
C.)
F9
D.)
PAGE DOWN
Answer: Option 'C'
F9
- 3. In MS-Access to open new database press
A.)
CTRL+N
B.)
CTRL+O
C.)
ALT+F4
D.)
None of these
Answer: Option 'A'
CTRL+N
- 4. In MS-Access to open an existing database press
A.)
CTRL+N
B.)
CTRL+O
C.)
ALT+F4
D.)
None of these
Answer: Option 'B'
CTRL+O
- 5. In MS-Access to Open a combo box
A.)
F9
B.)
PAGE DOWN
C.)
DOWN ARROW
D.)
F4 or ALT+DOWN ARROW
Answer: Option 'D'
F4 or ALT+DOWN ARROW
- 6. There are three types of data found in a spreadsheet:
A.)
Equations, data, numbers
B.)
Numbers, formulas, labels
C.)
Data, words, numbers
D.)
Words, numbers, labels
Answer: Option 'B'
Numbers, formulas, labels
- 7. Which symbol must all formula begin with:
A.)
@
B.)
=
C.)
+
D.)
%
Answer: Option 'B'
=
- 8. To merge the cells which tab do you use from the format, cells menu?
A.)
Alignment tab
B.)
Number tab
C.)
Font tab
D.)
Merge tab
Answer: Option 'A'
Alignment tab
- 9. In an excel sheet the active cell is indicated by:
A.)
A blinking border
B.)
A dotted border
C.)
A dark wide boarder
D.)
None of These
Answer: Option 'C'
A dark wide boarder
- 10. How do you rearrange the date in ascending or descending order?
A.)
Data, table
B.)
Data, sort
C.)
Data, form
D.)
Data, subtotals
Answer: Option 'B'
Data, sort
- 11. To add two cells (A1 and A2) together you use the following formula:
A.)
A1 plus A2
B.)
=A1 + A2
C.)
=Add(A1+A2)
D.)
=together(A1:A2)
Answer: Option 'B'
=A1 + A2
- 12. Which of the following is not a data base application?
A.)
Access
B.)
dBase
C.)
edit
D.)
FoxPro
Answer: Option 'C'
edit
- 13. You can create hyperlinks from the Excel workbook to
A.)
A webpage on company internet
B.)
A web page on the internet
C.)
Other office 97 application documents
D.)
All of the above
Answer: Option 'D'
All of the above
- 14. How many save as option in MS Access 2007?
A.)
1
B.)
2
C.)
3
D.)
4
Answer: Option 'C'
3
- 15. The advantage of using a spreadsheet is
A.)
Calculations can be done automatically
B.)
Changing data automatically updates calculations
C.)
More flexibility
D.)
All of the above
Answer: Option 'D'
All of the above
MS Access MCQs Download Pdf
- Input and Output Devices Question and Answers | Basic Computer Knowledge
- Computer Quiz For LIC AAO Exam 2019
- MS Access Questions & Answers | Basic Computer Knowledge
- MS Excel Questions & Answers | Basic Computer Knowledge
- Computer Questions for NICL AO Mains for 2019
- Computer Questions for IBPS RRB PO and Clerk Mains
- Basic Computer Interview Questions and Answers pdf | MCQs | 07 - 02 - 2019
- Computer Questions for Indian Bank Probationary Officers 2018
- Computer Questions for RBI ASSISTANT MAINS
- Computer Awareness Quiz for Insurance Exams MCQs Free Download | Basic Computer Knowledge
Free Mock Test
- RRB NTPC Free Online Mock Test
- RRB Group D Free Online Mock Test
- Panchayat Secretary Free Online Mock Test
- General Studies in Telugu
- కరెంటు అఫైర్స్ Quiz Sets
- Logical Reasoning MCQs
Computer Knowledge MCQs
Computer Knowledge Test- Networking and Internet
- Ms Office Tools
- MS Excel Questions & Answers
- Computer Abbreviations
- Computer Fundamentals Section
- Computer Awareness Quiz for Insurance (40)
- IT Officer Questions
- Computer Aptitude MCQs
- Data Communication
- MS Access MCQs
- Computer Hardware MCQs
- Computer Memory MCQs
- DBMS Multiple Choice Questions
- 3000 Operating System MCQs
- Computer Quiz LIC AAO MCQ
- Linux Questions MCQs
- Computer Network MCQs
- Computer MCQs for YES Bank
- MS Word MCQs
- MS Excel MCQs
- MS Powerpoint MCQs
- Input and Output Devices MCQs
- MS Access MCQs
- Computer Graphics MCQs
- Banking Pathway 2019 MCQs
- Interview Questions and Answers Computer Science MCQs
- 3000 Operating System | MCQs
- DBMS Multiple Choice Questions
- Array and Array Operations
Static General Knowledge MCQs