MS Access MCQ Questions and Answers
1. Microsoft Access is a ____________ ?
a) Word processing software
b) Workbook management system
c) Database management system
d) File management system
2. What is a database?
a) Itis a collection of data arranged in rows
b) Itis a collection of data arranged in columns
c) tis a collection of data arranged in rows and columns
d) All of the above
3. Which of the following is database management system software____ ?
a) Firefox
b) MS Word
c) MS Access
d) MS PowerPoint
4. Which of the following is not a type of Microsoft access database object?
a) Table
b) Macros
c) Modules
d) Worksheets
5. To quit MS Access, Press ?
a) Alt +F4
b) Tab + F4
c) Ctrl + F4
d) Esc +W
6. To open a new database, press ?
a) Ctrl +M
b) Ctrl +N
c) Ctrl +O
d) Ctrl +S
7. To open an existing database, press ?
a) Ctrl +E
b) Ctrl +O
c) Ctrl +P
d) Ctrl +X
8. What is the maximum length a text field can be ?
a) 265
b) 255
c) 120
d) 75
9. The default and maximum size of text field in access ?
a) 50 and 255 characters
b) 266 characters and 6400 characters
c) 288 characters and 6880 characters
d) 299 characters and 6499 characters
10. In Access are used to store the data?
a) Report
b) Query
c) Form
d) Table
11. Which tool do you use to create a query object?
a) Database wizard
b) Table query wizard
c) Simple query wizard
d) Simple filer wizard
12. Open the Save As dialog box ?
a) F1
b) F2
c) F10
d) F12
13. To create a table in MS Access ?
a) Database should be created before creating a table
b) You should allow atleast one Primary key in a table
c) Table can be created using Table Templates
d) All of the above
14. A search value can be exact value or it can be ?
a) Relationship
b) Logical operator
c) Wild card character
d) Comparison operation
15. Which program do you use to edit code for data MS Access pages?
a) Microsoft script editor
b) Microsoft code editor
c) Microsoft data access pages editor
d) All of these
16. In how many views, you can create a table in Access?
a) 8
b) 6
c) 4
d) 2
17. To switch between to Form view from design view, press ?
a) F4
b) F5
c) F8
d) F11
18. Which of the following is not a field type in access____?
a) Lookup wizard
b) Ole object
c) Hyperlink
d) Memo
19. In Access table Row is also known as___?
a) Type
b) Data
c) Field
d) Record
20. Which of the following data type stores text or a combination of text and numbers ?
a) Ole
b) Text
c) Number
d) Currency
21. In MS Access, AutoNumber Data Type__?
a) Can be Sequential
b) Can be Random
c) Only A & B
d) Can be Edited
22. In MS Access, which data type is appropriate to store large text and numbers ?
a) Large Text
b) Memo
c) Text
d) OLE
23. Unlike text data type, this can store up to maximum of 65,535 characters?
a) Date/time
b) Number
c) Memo
d) All of above
24. The default data type for a field is ?
a) AutoNumber
b) Number
c) Varchar
d) Text
25. Which is the valid data type in Access?
a) Text
b) Number
c) Currency
d) All of the above
26. Which data type allows alphanumeric characters and special symbols?
a) Text
b) Memo
c) Auto number
d) All of the above
27. A is an area reserved for a specific piece of data.
a) Key
b) Report
c) Record
d) Field
28. Which is not a view to create a table in MS Access ?
a) Design view
b) Database view
c) Pivot Table and Pivot Chart view
d) All of the above
29. In MS Access Hyperlink data type can store ?
a) Path of a File
b) Web Address
c) Email Address
d) All of Above
30. It is a database object to view, change, and analyze data in different ways___ ?
a) Form
b) Query
c) Report
d) All of the above
31. The executive responsible for the data processing function in an organization is_?
a) DPE
b) PMC
c) DBMS
d) DPMT
32. button helps to search quickly for every occurrence of a specific word or phrase?
a) Sort
b) Find
c) Bullet
d) Justify
33. In access, which displays the results of a calculation in a query?
a) Child field
b) Source field
c) Lookup field
d) Calculated field
34. In which of the following view, you can’t change the table data____ ?
a) Pivot table view
b) Datasheet view
c) Design view
d) Both a and b
35. Which of the following database object hold data _________ ?
a) Forms
b) Tables
c) Reports
d) Queries
36. To toggle the Navigation Pane, press ?
a) F1
b) F2
c) F6
d) F11
37. In Access, which operation copies a backup file from the storage medium back onto the computer ?
a) Copy
b) Restore
c) Recreate
d) Structure
38. Which of the following Data Type is used to store picture in MS Access ?
a) Memo
b) Picture
c) OLE object
d) Picture cannot be stored
39. Which of the following database object is created first before any other created?
a) Query
b) Table
c) Report
d) Form
40. A name must be unique within a database?
a) Character
b) Record
c) Table
d) Field
41. Press ___to cycle between open windows?
a) Ctrl +F4
b) Ctrl +F6
c) Ctrl +F7
d) Ctrl +F9
42. key is uniquely identifies each record?
a) Key record
b) Field Name
c) Unique key
d) Primary key
43. Which of the following is a method to create a new table in MS Access ?
a) Create table by entering data
b) Create table using wizard
c) Create table in design view
d) All of above
44. Which of the following database objects asks a question of information in a database and then displays the result?
a) Forms
b) Tables
c) Queries
d) Reports
45. ____________ is not a valid data type in MS Access?
a) Picture
b) Auto number
c) Memo
d) Currency
46. The option allows you to build a new table by entering data directly into the datasheet ?
a) Datasheet view
b) Design view
c) Link table
d) All of the above
47. Queries in MS Access can be used as ?
a) View, change and analyze data in different ways
b) A source of records for forms and reports
c) Both a and b
d) None of these
48. Which field type will you select if you need to enter long text in that field ?
a) Hyperlink
b) Currency
c) Memo
d) Text
49. The size of yes/no field is always ?
a) 1KB
b) 1Bit
c) 1Byte
d) 1 Character
50. The report footer section is most useful for displaying ?
a) Column headings
b) Page Numbers
c) Grand Totals
d) Sub Totals
51. Microsoft Access is a ?
a) RDBMS
b) ORDBMS
c) OODBMS
d) Network Database Model
52. What type of software is MS Access?
a) System Software
b) Application Software
c) Utility Software
d) None of these
53. MS Access is a component of ?
A. Windows
B. Windows XP
C. Microsoft Office
D. None of the above
54. Which of the following is the latest version of MS- Access ?
A. MS-Access 2000
B. MS-Access 2002
C. MS-Access 2007
D. MS-Access 2019
55. What is the default file extension of MS Access ?
A. .docx
B. xlsx
C. .pptx
D. .accdb
56. When a new database is created in MS Access, what will be the default name of the table?
A. Row 1
B. Column 1
C. Database 1
D. Table 1
57. A database can be best described as ?
A. Useful presentation of data
B. Organized collection of data
C. Graphical representation of data
D. All of the above
58. MS Access is used to develop ?
A. XLS file
B. TXT file
C. Database design
D. None of the above
59. How can we create a query in Microsoft Access ?
A. Type the SQL
B. Drag and drop fields
C. Use query wizard
D. All of these
60. What is the full form of SQL?
A. Structured Query Language
B. Simple Query Language
C. Structured Query List
D. None of the above
61. Which command quickly locates data in Access tables?
A. Find
B. Search
C. Locate
D. Edit
62. Which of the following is not a data type in MS- Access ?
A. Text
B. Table
C. Number
D. OLE object
63. Which technique prevents invalid data being saved in Access table ?
A. Input mark
B. Index
C. Filter
D. Validation rule
64. In Access to Move down one line ?
A. Down Arrow
B. Alt + Down Arrow
C. Page Down
D. F9
65. In Access to Move down one page ?
A. Down Arrow
B. Alt + Down Arrow
C. Page Down
D. F9
66. MDE file is a ?
A. Microsoft Access Database
B. Memory Database Encode
C. Memory Database Encrypt
D. Microsoft Database Encrypt
67. MDE file does not contain ?
A. Tables
B. Macros
C. Queries
D. Source code
68. Which field type can store photos ?
A. OLE
B. Hyperlink
C. Both of these can be used
D. Access tables can’t store photos
69. What is the full form of OLE in Access ?
A. Object linking
B. Object linking and editing
C. Object linking and encrypting
D. Object linking and embedding
70. ___________ can be created to help easy data entry in MS Access tables ?
A. Form
B. Report
C. Database
D. Spreadsheet
71. We can remove a relationship defined between two tables by ?
A. From Edit menu choose Delete Relationship.
B. Choose Delete option from Relationship menu
C. Select the relationship line and press Delete
D. All of the above
72. The size of a field with Number data type can not be?
A 2
B. 4
C. 8
D. 16
73. In MS Access “Lookup Wizard” is used to ?
A. to select from previous values
B. to select values from Excel Sheet
C. to select value from another table
D. Not a valid Type
74. In Access table Row is also known as ?
A. Data
B. Type
C. Record
D. Field
75. In Access table Column is also known as ?
A. Data
B. Type
C. Record
D. Field
76. A primary key in any table has the properties ?
A. Not Null
B. No Duplicates
C. Both of the above
D. None of the above
77. To open a new database in MS-Access, press ?
A. Alt +F4
B. Ctrl +N
C. Ctrl +O
D. None of these
78. In MS-Access press CTRL+O to ?
A. Exit MS-Access
B. Open a new database
C. Open an existing database
D. None of the above
79. Command center of the access file that appears when you create or open the MS Access database file.
A. Design View Window
B. Query Window
C. Switchboard
D. Database Window
80. The appropriate Data Type to store Time in MS Access ?
A. Time
B. Date/Time
C. Time Only
D. Time cannot be stored
81. Which of the following field has a width of 8 bytes ?
A. Memo
B. Number
C. Hyperlink
D. Date/Time
82. Which of the following database object hold data ?
A. Forms
B. Tables
C. Queries
D. Reports
83. Which of the following data types is used to store logical values in MS Access ?
A. Yes/No
B. On/Off
C. True/False
D. All of the above
84. Which of the following is use to get data from user ?
A. Form
B. Report
C. Pages
D. Query
85. Which of the following is invalid field name ?
A. Student\’Address
B. Student Address
C. Student Address
D. Student.Address
86. Which of the following is not a logical database structure?
A. Tree
B. Network
C. Relational
D. Chain
87. Which key stoke is used to move the active cell to the right, in an access table ?
A. Tab
B. Alt+ Tab
C. Ctrl + Tab
D. Shift + Tab
88. Which key stoke is used to move the active cell towards left, in an access table ?
A. Tab
B. Alt + Tab
C. Ctrl + Tab
D. Shift + Tab
89. In MS Access, Field Value may contain ?
A. Text
B. Picture
C. Date & Time
D. All of the above
90. A(n) __________ is the default control for a Yes/No field ?
A. list box
B. check box
C. toggle button
D. option button
91. In MS Access, text data type may contain maximum character of ?
A. 255 characters
B. 256 characters
C. 1064 characters
D. No Limit
92. Which key combination can zoom the contents of the active cell jn an Access table ?
A. Ctrl +F2
B. Shift +F2
C. Ctrl +F3
D. Shift + F5
93. What query do you use to answer the question “what is the average salary of employees” ?
A. Select query
B. Search query
C. Update query
D. Cross tab query
94. Which of the following is a valid time format in MS Access ?
A. hh.mm.ss AM/PM
B. hh:mm:ss AM/PM
C. hh-mm-ss AM/PM
D. hh/mm/ss AM/PM
95. Which feature is used to duplicate a controls formatting ?
A. Wizard
B. Control
C. Painter
D. Manager
96. In Datasheet View, what appears at the top of each column?
A. Data type
B. Field name
C. Primary key
D. Description
97. Which of the following shortcut key is used to check spelling when required?
A. Alt+F4
B. Ctrl+F2
C. F5
D. F7
98. Which of the following provides the AutoCalc command on the Toolbar in MS-Access ?
A. Sum
B. Count
C. Min
D. All of the above
99. In Access, which operation copies a backup file from the storage medium back to the computer ?
A. Copy
B. Restore
C. Recreate
D. Structure
100. Which of the following used in MS-Access to close the active window ? i
A. Alt + F6
B. Ctrl + W
C. Ctrl + F5
D. None of these