1.
Which field type will you select if you need to enter long text in that field?
A.Text
B.Memo
C.Currency
D.Hyperlink
Answer: Memo [Option: B]
2.
An expression builder is an access tool that controls an expression___ for
entering an expression
A.Table
B.Box
C.Cell
D.Palette
Answer : Box [Option : B]
3.
Which of the following is not a type of MS Access database object?
A.Table
B.Form
C.Worksheets
D.Modules
Answer : Worksheets [Option : C]
4.
In which method we don't need to specify the field type and size while creating
a new Table?
A.Design View
B.While using Wizard
C.CreateTable By Entering Data
D.All of Above
Answer : Create Table By Entering Data [Option : C]
5.
The size of yes/no field is always ________
A.1 Bit
B.1 Byte
C.1 Character
D.1 KB
Answer : 1 Bit [Option : A]
6.The
size of a field with number data type can not be _____
A.2
B.4
C.8
D.16
Answer
: 16 [Option : D]
7.what
can be the maximum length of a text field ?
A.120
B.255
C.265
D.75
Answer
: 255 [Option : B]
8.Which
kind of query that displays its own dialog box prompting you for entering
information before executing?
A.Select Query
B.Crosstab Query
C.Parameter Query
D.Dialog Query
Answer
: Parameter Query [Option : C]
9.What
is a form that we can create in MS Access?
A.It is used to take a printout of a form from Access Tables.
B.It is an input screen for viewing and entering data.
C.It is used for storing special data other than text (e.g
photo)
D.It is optional. We can use Report instead of Form
Answer
: It is an input screen for viewing and entering data. [Option : B]
10.
What Cascade Delete option is used for?
A.It is used to delete all the records of all tables in a
database
B.It repeats the recent delete operation to all the records of
current table
C.It ensures that all the related records will be deleted
automatically when the record from parent table is deleted.
D.It is used to delete all the records of related tables in a database
Answer
: It ensures that all the related records will be deleted automatically
when the record from parent table is deleted. [Option : C]
11.
Which operator is used to filter and display rows when all (two or more)
conditions are satisfied ?
A.RANGE
B.IN
C.ALL
D.AND
Answer
: ALL [Option : C]
12.
The columns in a Microsoft access table are also called _______
A.Rows
B.Records
C.Fields
D.Columns
Answer
: Fields [Option : C]
13.
how can you define a field so that when entering data ##### is displayed?
A.Input Mask
B.Validation Rule
C.Indexed
D.Ime Mode
Answer
: Input Mask [Option : A]
14.
In the context of Microsoft Access, which of the following statement is true?
A.Reports are used to retrieve and calculate data from tables
B.Queries can be printed 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 used to print but reports to display on screen only
Answer
: Queries can include calculated fields that do not exist in the table [Option
: C]
15. Which of the
following is not a field type in Microsoft Access?
A.Memo
B.Hyperlink
C.Ole Object
D.Lookup Wizard
Answer: Lookup
Wizard [Option : D]
16. The upper
part of the query design window in MS Access has two parts shows ____________
A.Fields name
with field size
B.Fields name
with relationships
C.Fields and
Criteria
D.Sorting Options
Answer : Fields name with
relationships [Option : B]
17.
Ho, can you edit a relationship already established between two tables?
A.Right click the relationship line and choose Edit
Relationship
B.Double click the relationship line
C.Both of above
D.None of above
Answer
: Both of the above [Option : C]
18.
What does the show check box in the 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 the query
result or not
C.It indicates whether the field names to be displayed in the query result or not.
D.It indicates whether the field is to be used for grouping results or not.
Answer
: It indicates whether the field is to be displayed in query result or
not [Option : B]
19.
Which of the following option creates a Drop Down List of values?
A.Ole Object
B.Hyperlink
C.Memo
D.Lookup Wizard
Answer
: Lookup Wizard [Option : D]
20.
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
Answer
: Subform sub-report [Option : A]
21. The command center of the Access File that appears when we create or open the MS Access
database File.
A. Database Window
B.Query Window
C.Design View Window
D.Switchboard
Answer
: Database Window [Option : A]
22.
While creating a relationship using mouse, how the the mousepointer looks like?
A.A thick plus sign
B.A thin plus sign
C.An outlined rectangle
D.Arrow with Plus sign
Answer
: An outlined rectangle [Option : C]
23. To define
AND condition while entering criteria in a query design window we write _______
A.Criteria
values vertically one in a row
B.Criteria
values horizontally
C.Write
criteria values separated by AND
D.Write criteria values using & ( anchor and ) sign
Answer : Criteria values
horizontally [Option : B]
24. Which feature is used to duplicate a control's formatting ?
A.Manager
B.Wizard
C.Painter
D.Control
Answer : Painter [Option : C]
25. 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
Answer : All of
above [Option : D]
26.
While creating a relationship, what happens when you releasemousepointer 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.A connector symbol is created
D.A connecting Line is visible
Answer : Edit relationship dialog box appears [Option : B]
27.
What is the role of the Cascade Update option ?
A.It says do not change the value in the primary key field if
that record has related records in another table
B.It means change all the related records in child tables if
the record in parent table is changed
C.Both A and B
D.None of these
Answer : Both A and B [Option : C]
28.
Which of the following is a method to create new table inMS Access?
A.Using Design View
B.CreateTable Wizard
C.Directly Entering Data
D.All of Above
Answer : All of Above [Option : D]
29.
If you write criteria values one in a row in the query design window, that means
you are specifying _____
A.OR conditions
B.AND conditions
C.NOT condition
D.ALL conditions
Answer : OR conditions [Option : A]
30.
How can we create a query in Microsoft Access?
A.Drag and drop fields
B.Type the SQL
C.Use query wizard
D.All of above
Answer : All of above [Option : D]
31.
Which option allows us to build a new table by entering data directly into a
tabular grid?
A.Datasheet View
B.Design View
C.LinkedTable
D.Grid View
Answer : Datasheet View [Option : A]
32.
What is the shortcut key to switch between the field names and properties
panels in table design view?
A.F3 Key
B.F4 Key
C.F5 Key
D.F6 Key
Answer : F6 Key [Option : D]
33.
Which field type can store photos?
A.Hyperlink
B.OLE Object
C.Both can be used
D.It is not possible
Answer : OLE Object [Option : B]
34.
Which data type should we use if we are planning to store a couple of paragraphs
or detailed description in a field?
A.Text
B.Para
C.Memo
D.Desc
Answer : Memo [Option : C]
35.
Which of the following database object hold data?
A.Forms
B.Reports
C.Queries
D.Tables
Answer : Tables [Option : D]
36.
When creating a new table which method can be used to choose fields from
standard databases and tables
A.CreateTable In Design View
B.CreateTable Using Wizard
C.CreateTable by entering data
D.None of Above
Answer
: CreateTable Using Wizard [Option : B]
37.
Which one of these is the most common type of query that retrieves records from
one or more tables and then displays the result in tabular form?
A.Tabular Query
B.Crosstab Query
C.Select Query
D.Pivot Query
Answer
: Select Query [Option : C]
38.
Microsoft Access is a ______ kind of application?
A.RDBMS
B.OODBMS
C.ORDBMS
D.Network Database Model
Answer
: RDBMS [Option : A]
39.
Queries in MS Access can be used ____________
A.To view data
B.As source for Forms
C.As source for Reports
D.All of These
Answer
: All of These [Option : D]
40.
How many characters you can type in maximum while writing the field name?
A.60
B.64
C.68
D.Any Number Of Character
Answer
: 64 [Option : B]
41.
The small button with three dots displayed at the right of the field properties box
is called :
A.Make Button
B.Expression Button
C.Build Button
D.None Of Above
Answer
: Build Button [Option : C]
42.
Which of the following shows the final result in a presentable way?
A.Forms
B.Reports
C.Queries
D.Tables
Answer
: Reports [Option : B]
43.
In MS Access, how can we create a relationship between two tables in the GUI?
A.Drag the foreign key of a table into the primary key of
another table
B.Drag any field from the parent table and drop it on the child table
C.Drag the primary key of a table into the foreign key of another
table
D.Any of these can be done to create a relationship
Answer
: Drag the primary key of a table into the foreign key of another table [Option
: C]
44.
Which of the following store command to gather data from the database?
A.Forms
B.Reports
C.Queries
D.Tables
Answer
: Queries [Option: C]
45.
A search value in SQL query can be a specific value or it can be ________
A.Logical Operator
B.Relationship
C.Wild card character
D.Comparison operation
Answer
: Wild card character [Option : C]
