Download PDF
Free download in PDF Microsoft Access Short Questions and Answers for competitive exams. These short objective type questions with answers are very important for Board exams as well as competitive exams. These short solved questions or quizzes are provided by Gkseries.
41
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
42
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
Answer: Select the relationship line and press Delete
43
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
44
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
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
Answer: It is an input screen designed to make the viewing and entering data easier
46
What are the columns in a Microsoft Access table called?
[A]
Rows
[B]
Records
[C]
Fields
[D]
Columns
47
A search value can be an exact value or it can be
[A]
Logical Operator
[B]
Relationship
[C]
Wild card character
[D]
Comparison operation
Answer: Wild card character
48
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 &
Answer: write criteria values horizontally
49
Which of the following creates a drop down list of values to choose from a list?
[A]
OLE Object
[B]
Hyperlink
[C]
Memo
[D]
Lookup Wizard
50
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
51
When entering field name, how many characters you can type in maximum?
[A]
60
[B]
64
[C]
68
[D]
Any number of character
52
Which of the following is not a field type in Access
[A]
Memo
[B]
Hyperlink
[C]
OLE Object
[D]
Lookup Wizard
53
It is an association established between common fields of two tables.
[A]
line
[B]
relationship
[C]
primary key
[D]
records
54
A __ name must be unique within a database
[A]
Table
[B]
Field
[C]
Record
[D]
Character
55
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 child 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
Answer: 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
56
The database language that allows you to access or maintain data in a database
[A]
DCL
[B]
DML
[C]
DDL
[D]
None of above
57
You can set a controls border type to make the border invisible.
[A]
Transparent
[B]
Invisible
[C]
Do not display
[D]
No border
58
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
59
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
Answer: 50 and 255 Characters
60
Which of the following database object produces the final result to present?
[A]
Forms
[B]
Reports
[C]
Queries
[D]
Tables
Please share this page