80 Top Microsoft Access Interview Questions and Answers With PDF Download Set-1 - Microsoft Access
1. What Are the Different
Views to Display a Table
A)
Datasheet
View
B)
Design
View
C)
Pivot
Table & Pivot Chart View
D)
All Of
Above
2. Which Of The Following
Creates A Drop Down List Of Values To Choose From?
A)
Ole
Object
B)
Hyperlink
C)
Memo
D)
Lookup
Wizard
3. The Command Center Of
Access File That Appears When You Create Or Open The Ms Access Database File.
A)
Database
Window
B)
Query
Window
C)
Design
View Window
D)
Switchboard
4. The Third Stage In
Designing A Database Is When We Analyze Our Tables More Closely And Create A
___________ Between Tables
A)
Relationship
B)
Join
C)
Query
D)
None Of
These
5. In A Database Table,
The Category Of Information Is Called __________
A)
Tuple
B)
Field
C)
Record
D)
All Of
Above
6. This Key Uniquely
Identifies Each Record
A)
Primary
Key
B)
Key
Record
C)
Unique
Key
D)
Field
Name
7. It Is An Association
Established Between Common
A)
Line
B)
Relationship
C)
Primary
Key
D)
Records
8. This Is The Stage In
Database Design Where One Gathers And List All The Necessary Fields For The
Database Project.
A)
Data
Definition
B)
Data
Refinement
C)
Establishing
Relationship
D)
None Of
The Above
9. A Database Language
Concerned With The Definition Of The Whole Database Structure And Schema Is
________
A)
DCL
B)
DML
C)
DDL
D)
All Of
Above
10. Which Of The Field
Has Width 8 Bytes?
A)
Memo
B)
Number
C)
Date/time
D)
Hyperlink
11. Which Of The
Following Statement Is True?
A)
Foreign
Key Fields Don\'t Allow Duplicate Values
B)
In
Primary Key Field You Can Enter Duplicate Value
C)
In An
Indexed Field You May Or May Not Enter Duplicate Value Depending Upon Setting D) All Statements Are True
12. Following Is Not A
Database Model
A)
Network
Database Model
B)
Relational
Database Model
C)
Object
Oriented Database Model
D)
None
13. Microsoft Access Is A
A)
RDBMS
B)
OODBMS
C)
ORDBMS
D)
Network
Database Model
14. DCL Provides Commands
To Perform Actions Like
A)
Change
The Structure Of Tables
B)
Insert,
Update Or Delete Records And Data Values
C)
Authorizing
Access And Other Control Over Database
D)
None Of
Above
15. The Database Language
That Allows You To Access Or Maintain Data In A Database
A)
DCL
B)
DML
C)
DDL
D)
None Of
Above
16. What Is The Maximum
Length A Text Field Can Be?
A)
120
B)
255
C)
265
D)
75
17. Which Of The Following Is Not A Database
Object?
A)
Tables
B)
Queries
C)
Relationships
D)
Reports
18. A __________ Enables
You To View Data From A Table Based On A Specific Criterion
A)
Form
B)
Query
C)
Macro
D)
Report
19. What Are The Columns
In A Microsoft Access Table Called?
A)
Rows
B)
Records
C)
Fields
D)
Columns
20. Which Of The
Following Is Not A Type Of Microsoft Access Database Object?
A)
Table
B)
Form
C)
Worksheets
D)
Modules
21. Which Of The Following
Database Object Hold Data?
A)
Forms
B)
Reports
C)
Queries
D)
Tables
22. Which Of The
Following Store Command To Retrieve Data From Database?
A)
Forms
B)
Reports
C)
Queries
D)
Tables
23. Which Of The
Following Database Object Produces The Final Result To Present?
A)
Forms
B)
Reports
C)
Queries
D)
Tables
24. What Is The
Difference Between ‘open’ And ‘open Exclusively ?
A)
Open
Statement Opens Access Database Files And Open Exclusively Opens Database Files
Of Other Program Like
Oracle
B)
Open
Exclusive Locks Whole Database So That No One Can Access It Whereas Open Locks
Only The Record That Is
Being Accessed
C)
Both
Open And Open Exclusively Are Same
D)
Open
Exclusive Command Does Not Exist In Ms Access
25. Which Of The
Following Is A Method To Create A New Table In Ms Access?
A)
Create
Table In Design View
B)
Create
Table Using Wizard
C)
Create
Table By Entering Data
D)
All Of
Above
26. To Create A New
Table, In Which Method You Don’t Need To Specify The Field Type And Size?
A)
Create
Table In Design View
B)
Create
Table Using Wizard
C)
Create
Table By Entering Data
D)
All Of
Above
27. When Creating A New
Table Which Method Can Be Used To Choose Fields From Standard Databases And
Tables
A)
Create
Table In Design View
B)
Create
Table Using Wizard
C)
Create
Table By Entering Data
D)
None Of
Above
28. In Table Design View,
Which Key Can Be Used To Switch Between The Field Names And Properties Panels?
A)
F3
B)
F4
C)
F5
D)
F6
29. In Table Design View
What Are The First Column Of Buttons Used For
A)
Indicate
Primary Key
B)
Indicate
Current Row
C)
Both Of
Above
D)
None Of
Above
30. The Default And
Maximum Size Of Text Field In Access
A)
50 And
255 Characters
B)
8 And 1
Gb
C)
266
Characters & 64000 Characters
D)
None Of
Above
31. The Size Of Yes No
Field Is Always
A)
1 Bit
B)
1 Byte
C)
1
Character
D)
1 Gb
32. Which Of the
Following Is Not A Field Type In Access
A)
Memo
B)
Hyperlink
C)
Ole
Object
D)
Lookup
Wizard
33. The Size Of A Field
With Number Data Type Can Not Be
A)
2
B)
4
C)
8
D)
16
34. Which Field Type Will
You Select When Creating A New Table If You Require To Enter Long Text In That
Field?
A)
Text
B)
Memo
C)
Currency
D)
Hyperlink
35. Which Field Type Can
Store Photos?
A)
Hyperlink
B)
Ole
C)
Both Of
These Can Be Used
D)
Access
Tables Can’t Store Photos
36. When Entering Field
Name, How Many Characters You Can Type In Maximum?
A)
60
B)
64
C)
68
D)
Any
Number Of Character
37. After Entering All
Fields Required For A Table, If You Realize That The Third Field Is Not Needed,
How Will You Remove?
A)
You Need
To Delete The Whole Table. There Is No Method To Remove A Particular Field
Only.
B)
Delete
All The Fields From Third Downwards And Reenter The Required Fields Again.
C)
Select
The Third Column In Datasheet View Then Delete
D)
Select
The Third Row In Table Design View Then Delete
38. How Can You Define A
Field So That When Entering Data For That Field It Will Display ______Instead
Of Actual Typed Text
A)
Input
Mask
B)
Validation
Rule
C)
Indexed
D)
Ime Mode
39. A Small Button With
Three Dots Usually Displayed At The Right Of Field Properties Box
A)
Make
Button
B)
Expression
Button
C)
Build
Button
D)
None Of
Above
40. To Sort Records In A
Table
A)
Open
Table, Click On The Field On Which The Sorting Is To Be Done, Then Click Sort
Button On Database Toolbar
B)
Open
Table, Click Sort Button On Database Toolbar, Choose Field Based On Which To
Sort, Click Ok
C)
Click
The Field Heading To Sort It Ascending Or Descending
D)
All Of
Above
41. Queries in Access can
be used as
A)
view,
change and analyze data in different ways
B)
a source
of records for forms and reports
C)
Only
a
D)
Both a
and b
42. To create queries in
Access
A)
You can
drag and drop fields on query builders
B)
you can
type the SQL command in SQL view
C)
You can
use query wizard or design view
D)
All of
above
43. Query design window
has two parts. The upper part shows
A)
Name of
fields, field type and size
B)
Tables
with fields and relationships between tables
C)
Criteria
D)
Sorting
check boxes
44. What does the show
check box in query design window indicate
A)
It indicates
whether the field is to be used or not
B)
It
indicates whether the field is to be displayed in query result or not
C)
It
indicates whether the field names to be displayed in query result or not D) None of above
45. What is a form in MS
Access
A)
It is a
printed page where users will write their data to fill it up
B)
It is an
input screen designed to make the viewing and entering data easier
C)
This is
an important part of database used by analysts to draw conclusions D) All of above
46. Which of the
following statement is true
A)
Reports
can be used to retrieve data from tables and calculate
B)
Queries
can be printed in well formatted manner and presented as the information
C)
Queries
can include calculated fields that do not exist in table
D)
Reports
and forms are similar but forms are use to print but reports to display on
screen only
47. Two tables can be
linked with relationship so that the data integrity can be enforced. Where can
you find Relationship command
A)
File
menu
B)
View
Menu
C)
Database
Menu
D)
Tools
Menu
48. Which of the
following is not a type of relationship that can be applied in Access database
A)
One to
One
B)
One to
Many
C)
Many to
Many
D)
All of
above can be applied
49. To create
relationship between two tables
A)
drag the
primary key of a table into foreign key of another table
B)
drag the
foreign key of a table into the primary key of another table
C)
drag any
field from parent table and drop on child table
D)
Any of
above can be done to create relationship
50. While creating
relationship, when you drag a field of a field to drop into another table the
mouse pointer changes into
A)
a
doctor’s sign
B)
thin +
sign
C)
outline
rectangle
D)
None of
above
51. What happens when you
release mouse pointer after you drop the primary key of a table into foreign
key of another table?
A)
A
relationship is created
B)
Edit
relationship dialog box appears
C)
Error
occurs
D)
Nothing
happens
52. What do you mean by
one to many relationship between Student and Class table?
A)
One
student can have many classes
B)
One
class may have many student
C)
Many
classes may have many students
D)
Many
students may have manu classes
53. In one-to-many
relationship the table in ‘one’ side is called _______ and on ‘many’ side is
called _______
A)
Child ,
Parent
B)
Parent ,
Child
C)
Brother
, Sister
D)
Father ,
Son
54. Referential integrity
means
A)
Do not
enter a value in the foreign key field of a child table if that value does not
exist in the primary key of the parent table
B)
Do not
enter a value in the primary key field of chield table if that value does not
exist in the primary key of the parent table
C)
Do not
enter a value in the foreign key field of a parent table if that value does not
exist in the primary key of the child table
D)
All of
above
55. Cascade delete option
A)
is used
to delete all the records of all tables in a database
B)
will
repeat the recent delete operation to all the records of current table
C)
is
available in Edit relationship dialog box which makes sure that all the related
records will be deleted automatically whn the record from parent table is
deleted
D)
None of
above
56. cascade update option
A)
means do
not change the value in the primary key field if that record has related
records in another table
B)
means
change all the related records in child tables if the record in parent table is
changed
C)
Both of
above
D)
None of
above
57. We can remove a
relationship defined between two tables by
A)
From
Edit menu choose Delete Relationship
B)
Select
the relationship line and press Delete
C)
Choose
Delete option from Relationship menu
D)
All of
above
58. If you need to edit a
relationship
A)
Right
click the relationship line and choose Edit Relationship
B)
Double
click the relationship line
C)
Both of
above
D)
None of
above
59. If you write criteria
values vertically (one in a row) it will mean
A)
OR
conditions
B)
AND
conditions
C)
NOT
condition
D)
None of
above
60. To achieve AND effect
when you are entering criteria in a query design window
A)
write
criteria values vertically one in a row
B)
write
criteria values horizontally
C)
Write
criteria values in same field separated with AND
D)
Write
criteria values in same field separated with &
61. A search value can be
an exact value or it can be
A)
Logical
Operator
B)
Relationship
C)
Wild
card character
D)
Comparison
operation
62. Both conditions display on the same row in
the design grid when ___operator is in use
A)
OR
B)
IN
C)
AND
D)
LIKE
63. The two form layout
types will display multiple records at one time are tabular and___
A)
columnar
B)
justified
C)
date
sheet
D)
pivot
table
64. You can automatically include all of the
field in a table in a query by___ a strike that appear list box in query design
view
A)
Clicking
B)
Right
clicking
C)
Double
clicking
D)
None of
the above
65. The___ operator will cause a record to be
selected only if two or more conditions are satisfied
A)
Or
B)
If or
C)
Range
D)
And
66. When a picture or other graphic image is
placed in the report header section it will appear____
A)
Once in
the bugging of the report
B)
At the
top of every page
C)
Every
after record break
D)
On the
1st and last pages of the report
67. To duplicate a controls formatting you can
use___
A)
Manager
B)
Wizard
C)
Painter
D)
Control
68. The__ button on the
tool box display data from a related table
A)
Sub form
sub report
B)
Relationships
C)
Select
objects
D)
More
controls
69. You can set a controls border type to make
the border invisible.
A)
Transparent
B)
Invisible
C)
Do not
display
D)
No
border
70. A __ name must be unique within a database
A)
Table
B)
Field
C)
Record
D)
Character
71. The expression
builder is an access tool that controls an expression___ for entering an
expression
A)
Table
B)
Box
C)
Cell
D)
Palette
72. This 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)
None of
the above
73. The key uniquely identifies each record in
a table.
A)
primary
key
B)
key word
C)
filed
name
D)
All of
above
74. This data type allows alphanumeric
characters and special symbols.
A)
text
B)
memo
C)
auto
number
D)
None of
the above
75. Unlike text data
type, this can store up to maximum of 65, 535 characters.
A)
memo
B)
data/time
C)
number
D)
All of
above
76. It is a database object
to view, change, and analyze data in different ways
A)
query
B)
form
C)
report
D)
None of
the above
77. It is most common type of query. It
retrieves records from one or more tables and then displays the
A)
Parameter
B)
Select
C)
crosstab
D)
All of
above
78. It is a query that when run displays its
own dialog box prompting you for information, such as
A)
Select
B)
crosstab
C)
Parameter
D)
Append
79. It is used to calculate and restructure
data for easier analysis of your data. It calculates the sum
A)
Parameter
B)
Select
C)
crosstab
D)
Append
80. It is a sign or symbol that specifies,
operator, and values that produce a result
A)
operator
B)
query
C)
expression
D)
None of
the above
ANSWER SHEET
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
17
|
18
|
19
|
20
|
|
D
|
D
|
A
|
A
|
B
|
A
|
B
|
A
|
C
|
C
|
C
|
D
|
A
|
C
|
A
|
B
|
C
|
B
|
C
|
C
|
|
21
|
22
|
23
|
24
|
25
|
26
|
27
|
28
|
29
|
30
|
31
|
32
|
33
|
34
|
35
|
36
|
37
|
38
|
39
|
40
|
|
D
|
C
|
B
|
B
|
D
|
C
|
B
|
D
|
C
|
A
|
A
|
D
|
D
|
B
|
B
|
B
|
D
|
A
|
C
|
A
|
|
41
|
42
|
43
|
44
|
45
|
46
|
47
|
48
|
49
|
50
|
51
|
52
|
53
|
54
|
55
|
56
|
57
|
58
|
59
|
60
|
|
D
|
D
|
B
|
B
|
B
|
C
|
D
|
D
|
A
|
C
|
B
|
A
|
B
|
A
|
C
|
C
|
B
|
C
|
A
|
B
|
|
61
|
62
|
63
|
64
|
65
|
66
|
67
|
68
|
69
|
70
|
71
|
72
|
73
|
74
|
75
|
76
|
77
|
78
|
79
|
80
|
|
C
|
C
|
B
|
C
|
D
|
A
|
C
|
A
|
C
|
A
|
B
|
A
|
A
|
A
|
A
|
A
|
B
|
C
|
C
|
A
|
