Ms Access-4
MS-Access lets users link to data in its current location and use the information for viewing, querying, updating, and reporting. It's simple to install and easy to understand. It lets users create tables, forms, queries, and reports and connect with the aid of Macros.
1. In which of the
following view, you can’t change the table data?
(A) Pivot table view
(B) Datasheet view
(C) Design view
(D) Both (a) and (b)
2. declarations stored as one unit.
(A) Tables
(B) Reports
(C) Macros
(D) Modules
3.
Which of the following
database object hold data?
(A) Forms
(B) Reports
(C) Tables
(D) Queries
4.
This is the stage in
database design where one gathers and lists all the necessary fields for the
database project.
(A) Data Definition
(B) Data Refinement
(C) Establishing
Relationship
(D) All of these
5.
Which action will
optimize your database performance?
(A) Set the record set
type of Snapshot
(B) Use the compact
and repair database tool
(C) Create a replica
of the database
(D) All of the above
6.
To toggle the
Navigation Pane, press
(A) F1
(B) F2
(C) F6
(D) F11
7.
In Access, this
operation copies a backup file from the storage medium back onto the computer
(A) Restore
(B) Recreate
(C) Copy
(D) Structure
8.
Which of the following
Data Type is used to store picture in MS Access?
(A) Picture cannot be
stored
(B) Memo
(C) OLE object
(D) Picture
9.
A _____ name must be
unique within a database.
(A) Character
(B) Table
(C) Record
(D) Field
10. Which
control does access use to link data access page components to access data?
(A) Microsoft Default
Connection Control
(B) Microsoft Data
Connection Control
(C) Microsoft Dynamic
Data Control
(D) Microsoft Office
Data Source Control
11.
Which of the following
database object is created first before any other created?
(A) Query
(B) Table
(C) Report
(D) Form
12.
Press _____ to cyle
between open windows.
(A) Ctrl + F4
(B) Ctrl + F6
(C) Ctrl + F7
(D) Ctrl + F12
13.
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) Click the field
heading to sort it ascending or descending
(C) Open table, click
sort button on database toolbar, choose field based on which to sort, click ok
(D) All of the above
14.
In MS Access, Lookup Wizard is used to
(A) to select value
from another table
(B) to select values
from Excel Sheet
(C) to select from
previous values
(D) not a valid data
type
15.The command center of access file that appears
when you create or open the ms access database file.
(A) Switchboard
(B) Design view Window
(C) Database Window
(D) Query Window
16.
In MS Access, Text
data type may contain maximum character of
(A) 255 character
(B) 256 character
(C) 1064 character
(D) No limit
17.
To rename a selected
object, press
(A) F2
(B) F3
(C) F4
(D) F5
18. ___ key is
uniquely identifies each record.
(A) Field Name
(B) Unique key
(C) Primary key
(D) Key record
19. Which of the
following is a method to create a new table in MS access?
(A) Create table by
entering data
(B) Create table using
wizard
(C) Create table in
design view
(D) All of above
20. The expression
builder is an access tool that controls an expression _____ for entering an
expression.
(A) Palette
(B) Box
(C) Cell
(D) Table
21. Which of the
following is a method to create a new table in MS-Access?
(A) Create table using
wizard
(B) Create table in
design view
(C) Create table in
data sheet view
(D) All of the above
22. 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) Double clicking
(B) Right clicking
(C) Clicking
(D) All the above
23. What is a
database?
(A) It is a collection
of data arranged in rows
(B) It is a collection
of data arranged in columns
(C) It is a collection
of data arranged in rows and columns
(D) All of the above
24. To open an
existing database, press
(A) Ctrl + O
(B) Ctrl + P
(C) Ctrl + E
(D) Ctrl + X
25. The 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) All of the above