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
- 16. How we save database file in MS Access 2007 for Ms Access 2000?
A.)
Save As MS Access 2000 Database
B.)
Save Only
C.)
Save Object As
D.)
None of these
Answer: Option 'A'
Save As MS Access 2000 Database
- 17. _______ is a component of database such as a table, query, form and macro?
A.)
Record
B.)
Object
C.)
Table
D.)
None of these
Answer: Option 'B'
Object
- 18. In MS-Access, what Are The Different Views To Display a table?
A.)
Datasheet View
B.)
Design View
C.)
Pivot Table & Pivot Chart View
D.)
All of the above
Answer: Option 'D'
All of the above
- 19. MS-Access is a?
A.)
Programming Tool
B.)
Database Tool
C.)
Web Page Creation Tool
D.)
None of the Above
Answer: Option 'B'
Database Tool
- 20. Which of the following is latest version of MS-Access?
A.)
MS-Access 2002
B.)
MS-Access 2000
C.)
MS-Access ME
D.)
MS-Access XP
Answer: Option 'D'
MS-Access XP
- 21. ________ provides the tools for creating fields in a table?
A.)
Drawing View
B.)
Table View
C.)
Drawing View
D.)
Both b and c
Answer: Option 'A'
Drawing View
- 22. _______ defines a data type for a set of values in a table?
A.)
Field
B.)
File
C.)
Record
D.)
None of these
Answer: Option 'A'
Field
- 23. MS-Access database files have a default extension?
A.)
MDE
B.)
DBM
C.)
PRG
D.)
BBE
Answer: Option 'A'
MDE
- 24. Which of the following is not a data type in MS-Access?
A.)
Table
B.)
Number
C.)
Text
D.)
OLE object
Answer: Option 'A'
Table
- 25. _______ is a field property that determines what kind of data a field can store?
A.)
File type
B.)
Data type
C.)
Data select
D.)
None of these
Answer: Option 'C'
Data select
MS Access MCQs Download Pdf
- Basic Computer Knowledge Test 500 + Questions and Answers
- Computer Fundamentals Section | Basic Computer Knowledge
- Keyboard Shortcuts - Basic Computer Knowledge
- Networking and Internet | Basic Computer Knowledge
- Ms Office Tools | Basic Computer Knowledge
- MS Excel Questions & Answers | Basic Computer Knowledge
- MS Powerpoint Questions With Answers | Basic Computer Knowledge
- Introduction to Computer | Classification of Computer | Featutes of Computer : MCQs with Answers Download PDF
- Basic Computer Knowledge Abbreviations | Basic Computer Knowledge
- Computer Networks Multiple Choice Questions | MCQs | Quiz | Download PDF | Basic Computer Knowledge
- RRB NTPC and RRB Group D Free Model Papers in Tamil Telugu Hindi and English
- Current Affairs in Telugu - RRB NTPC and RRB Group D Model Papers in Telugu
- Arithmetic and Maths in Telugu MCQs - RRB NTPC and RRB Group D Model Papers in Telugu
- Biology MCQs - RRB NTPC and RRB Group D Model Papers in Telugu
- Reasoning Practice Tests in Telugu - RRB NTPC and RRB Group D Model Papers in Telugu
- Science and Technology MCQs - RRB NTPC and RRB Group D Model Papers in Telugu
- Chemistry MCQs in Telugu - RRB NTPC and RRB Group D Model Papers in Telugu
- Physics MCQs in Telugu - RRB NTPC and RRB Group D Model Papers in Telugu
- Indian Polity - Constitution & Administration in Telugu - RRB NTPC and RRB Group D Model Papers in Telugu
- Indian Geography in Telugu MCQs - RRB NTPC and RRB Group D Model Papers in Telugu
- Andhra Pradesh - Geography in Telugu - RRB NTPC and RRB Group D Model Papers in Telugu
- General Knowledge MCQs - RRB NTPC and RRB Group D Model Papers in Telugu
- General Studies in Telugu - APPSC TSPSC UPSC - MCQs
- Andhra Pradesh Economics Question and Answers - MCQs
- Arithmetic and Maths in Hindi MCQs - RRB NTPC and RRB Group D Model Papers in Hindi
- Railway RRB NTPC and RRB Group D Study Material PDF in Hindi - हिंदी MCQs
- Reasoning MCQs in Hindi - हिंदी for RRB NTPC and RRB Group D Exams
RRB NTPC and RRB Group D Model Papers in Telugu
RRB NTPC and RRB Group D Model Papers in Hindi हिंदी
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
- RRB NTPC Model papers in Telugu 2019
Computer Knowledge MCQs
Computer Knowledge Test- Networking and Internet
- Ms Office Tools
- MS Excel Questions & Answers
- Computer Abbreviations
- MS Access Questions & Answers | Basic Computer Knowledge 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
- Computer Knowledge Quiz Set 21
- Computer Knowledge Quiz Set 20
- Computer Knowledge Quiz Set 19
- Computer Knowledge Quiz Set 18
- Computer Knowledge Quiz Set 17
- Computer Knowledge Quiz Set 16
- Computer Knowledge Quiz Set 15
- Computer Knowledge Quiz Set 14
- Computer Knowledge Quiz Set 13
- Computer Knowledge Quiz Set 12
- Computer Knowledge Quiz Set 11
- Computer Knowledge Quiz Set 10
- Computer Knowledge Quiz Set 9
- Computer Knowledge Quiz Set 8
- Computer Knowledge Quiz Set 7
- Computer Knowledge Quiz Set 6
- Computer Knowledge Quiz Set 5
- Computer Knowledge Quiz Set 4
- Computer Knowledge Quiz Set 3
- Computer Knowledge Quiz Set 2
- Computer Knowledge Quiz Set 1
- కరెంటు అఫైర్స్ Quiz Sets
- Logical Reasoning MCQs
- RRB NTPC Mock Test in Tamil
- RRB Group D Test in Hindi
Static General Knowledge MCQs