Microsoft Access Basic MCQs (Long Quiz)
This is the quiz about basics of Microsoft Office Access . Students and new learner's can test their knowledge.
1. Which field type will you select if you need to enter long text in that field?
Text
Memo
Currency
Hyperlink
Correct Answer
Wrong Answer
2. The expression builder is an access tool that controls an expression___ for entering an expression
Table
Box
Cell
Palette
Correct Answer
Wrong Answer
3. Which of the following is not a type of MS Access database object?
Table
Form
Worksheets
Modules
Correct Answer
Wrong Answer
4. In which method we don't need to specify the field type and size while creating a new Table?
Design View
While using Wizard
Create Table By Entering Data
All of Above
Correct Answer
Wrong Answer
5. The size of yes/no field is always ________
1 Bit
1 Byte
1 Character
1 KB
Correct Answer
Wrong Answer
6. The size of a field with number data type can not be _____
2
4
8
16
Correct Answer
Wrong Answer
7. How can you edit a relationship already established between two tables?
Right click the relationship line and choose Edit Relationship
Double click the relationship line
Both of above
None of above
Correct Answer
Wrong Answer
8. What does the show check box in query design window indicate ?
It indicates whether the field is to be used or not
It indicates whether the field is to be displayed in query result or not
It indicates whether the field names to be displayed in query result or not
It indicates whether the field is to be used for grouping result or not
Correct Answer
Wrong Answer
9. Which of the following option creates a Drop Down List of values ?
Ole Object
Hyperlink
Memo
Lookup Wizard
Correct Answer
Wrong Answer
10. what can be the maximum length of a text field ?
120
255
265
75
Correct Answer
Wrong Answer
11. Which kind of query that displays its own dialog box prompting you for entering information before executing ?
Select Query
Crosstab Query
Parameter Query
Dialog Query
Correct Answer
Wrong Answer
12. What is a form that we can create in MS Access ?
It is used to take printout of a form from Access Tables
It is an input screen for viewing and entering data
It is used for storing special data other than text (e.g photo)
It is optional. We can use Report instead of Form
Correct Answer
Wrong Answer
13. What Cascade Delete option is used for ?
It is used to delete all the records of all tables in a database
It repeats the recent delete operation to all the records of current table
It ensures that all the related records will be deleted automatically when the record from parent table is deleted
It is used to delete all the records of related tables in a database
Correct Answer
Wrong Answer
14. Which operator is used to filter and display rows when all (two or more) conditions are satiesfied ?
RANGE
IN
ALL
AND
Correct Answer
Wrong Answer
15. The_____________ button on the tool box display data from a related table
Sub form sub report
Relationships
Select objects
More controls
Correct Answer
Wrong Answer
16. The command center of Access File that appears when we create or open the MSAccess database File.
Database Window
Query Window
Design View Window
Switchboard
Correct Answer
Wrong Answer
17. While creating relationship using mouse, how the the mousepointer looks like?
A thick plus sign
A thin plus sign
An outlined rectangle
Arrow with Plus sign
Correct Answer
Wrong Answer
18. The columns in a microsoft access table are also called _______
Rows
Records
Fields
Columns
Correct Answer
Wrong Answer
19. how can you define a field so that when entering data ##### is displayed?
Input Mask
Validation Rule
Indexed
Ime Mode
Correct Answer
Wrong Answer
20. In the context of Microsoft Access, which of the following statement is true?
Reports are used to retrieve and calculate data from tables
Queries can be printed and presented as the information
Queries can include calculated fields that do not exist in table
Reports and forms are similar but forms are use to print but reports to display on screen only
Correct Answer
Wrong Answer
21. While creating relationship, what happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
A relationship is created
Edit relationship dialog box appears
A connector symbol is created
A connecting Line is visible
Correct Answer
Wrong Answer
22. What is the role of Cascade Update option ?
It says do not change the value in the primary key field if that record has related records in another table
It means change all the related records in child tables if the record in parent table is changed
Both
None of these
Correct Answer
Wrong Answer
23. Which of the following is a method to create a new table in MS Access?
Using Design View
Create Table Wizard
Directly Entering Data
All of Above
Correct Answer
Wrong Answer
24. f you write criteria values one in a row in query design window, that means you are specifying _____
OR conditions
AND conditions
NOT condition
ALL conditions
Correct Answer
Wrong Answer
25. How can we create a query in Microsoft Access ?
Drag and drop fields
Type the SQL
Use query wizard
All of above
Correct Answer
Wrong Answer
26. Which option allows us to build a new table by entering data directly into a tabular grid ?
Datasheet View
Design View
LinkedTable
Grid View
Correct Answer
Wrong Answer
27. What is the shortcut key to switch between the field names and properties panels in table design view?
F3 Key
F4 Key
F5 Key
F6 Key
Correct Answer
Wrong Answer
28. Which field type can store photos?
Hyperlink
OLE Object
Both can be used
It is not possible
Correct Answer
Wrong Answer
29. Which data type should we use if we are planning to store a couple of paragraph or detailed description in a field?
Text
Para
Memo
Desc
Correct Answer
Wrong Answer
30. Which of the following database object hold data?
Forms
Reports
Queries
Tables
Correct Answer
Wrong Answer
