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.
Question 1 / 30
Which field type will you select if you need to enter long text in that field?
Text
Memo
Currency
Hyperlink
Question 2 / 30
The expression builder is an access tool that controls an expression___ for entering an expression
Table
Box
Cell
Palette
Question 3 / 30
Which of the following is not a type of MS Access database object?
Table
Form
Worksheets
Modules
Question 4 / 30
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
Question 5 / 30
The size of yes/no field is always ________
1 Bit
1 Byte
1 Character
1 KB
Question 6 / 30
The size of a field with number data type can not be _____
2
4
8
16
Question 7 / 30
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
Question 8 / 30
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
Question 9 / 30
Which of the following option creates a Drop Down List of values ?
Ole Object
Hyperlink
Memo
Lookup Wizard
Question 10 / 30
what can be the maximum length of a text field ?
120
255
265
75
Question 11 / 30
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
Question 12 / 30
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
Question 13 / 30
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
Question 14 / 30
Which operator is used to filter and display rows when all (two or more) conditions are satiesfied ?
RANGE
IN
ALL
AND
Question 15 / 30
The_____________ button on the tool box display data from a related table
Sub form sub report
Relationships
Select objects
More controls
Question 16 / 30
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
Question 17 / 30
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
Question 18 / 30
The columns in a microsoft access table are also called _______
Rows
Records
Fields
Columns
Question 19 / 30
how can you define a field so that when entering data ##### is displayed?
Input Mask
Validation Rule
Indexed
Ime Mode
Question 20 / 30
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
Question 21 / 30
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
Question 22 / 30
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
Question 23 / 30
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
Question 24 / 30
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
Question 25 / 30
How can we create a query in Microsoft Access ?
Drag and drop fields
Type the SQL
Use query wizard
All of above
Question 26 / 30
Which option allows us to build a new table by entering data directly into a tabular grid ?
Datasheet View
Design View
LinkedTable
Grid View
Question 27 / 30
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
Question 28 / 30
Which field type can store photos?
Hyperlink
OLE Object
Both can be used
It is not possible
Question 29 / 30
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
Question 30 / 30
Which of the following database object hold data?
Forms
Reports
Queries
Tables
What's Your Reaction?
Like
0
Dislike
0
Love
0
Funny
0
Wow
0
Sad
0
Angry
0
Comments (0)