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

2. The expression builder is an access tool that controls an expression___ for entering an expression

Table
Box
Cell
Palette

3. Which of the following is not a type of MS Access database object?

Table
Form
Worksheets
Modules

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

5. The size of yes/no field is always ________

1 Bit
1 Byte
1 Character
1 KB

6. The size of a field with number data type can not be _____

2
4
8
16

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

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

9. Which of the following option creates a Drop Down List of values ?

Ole Object
Hyperlink
Memo
Lookup Wizard

10. what can be the maximum length of a text field ?

120
255
265
75

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

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

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

14. Which operator is used to filter and display rows when all (two or more) conditions are satiesfied ?

RANGE
IN
ALL
AND

15. The_____________ button on the tool box display data from a related table

Sub form sub report
Relationships
Select objects
More controls

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

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

18. The columns in a microsoft access table are also called _______

Rows
Records
Fields
Columns

19. how can you define a field so that when entering data ##### is displayed?

Input Mask
Validation Rule
Indexed
Ime Mode

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

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

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

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

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

25. How can we create a query in Microsoft Access ?

Drag and drop fields
Type the SQL
Use query wizard
All of above

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

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

28. Which field type can store photos?

Hyperlink
OLE Object
Both can be used
It is not possible

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

30. Which of the following database object hold data?

Forms
Reports
Queries
Tables