1.
_ button helps to search quickly for every (A) Pivot Table and Pivot Chart view
occurrence of a specific word or phrase.
(B) Database view
(A) Justify
(C) Design view
(B) Find
(D) All of the above
(C) Bullet
Ans - A
(D) Sort
7.A __ is the collection of data items of all the fields
Ans - B pertaining to one entity.
[Link] is a database object to view, change, and (A) Field
analyze data in different ways
(B) Form
(A) Form
(C) Record
(B) Report
(D) Report
(C) Query
Ans - C
(D) All of the above
[Link] is a
Ans - C
(A) RDBMS (Relational DBMS)
[Link] MS Access “ Hyperlink” Data Type can store
(B) DDBMS (Distributed DBMS)
(A) Web Address
(C) OODBMS (object Oriented DBMS)
(B) Email Address
(D) All of the above
(C) Path of a File
Ans - A
(D) All of Above
[Link] data type allows alphanumeric characters
Ans - D and special symbols.
4.A ____ enables you to view data from a table (A) Auto number
based on a specific criterion.
(B) Memo
(A) Query
(C) Text
(B) Modules
(D) All of the above
(C) Form
Ans - C
(D) Report
[Link] default data type for a field is
Ans - A
(A) Varchar
[Link] of the following creates a drop down list
(B) AutoNumber
of values to choose from?
(C) Number
(A) ID
(D) Text
(B) Hyperlink
Ans - D
(C) Lookup wizard
[Link] is the valid data type in Access?
(D) Clip object
(A) Currency
Ans - C
(B) Text
[Link] is not a view to create a table in Access?
(C) Number (D) Date/Time
(D) All of the above Ans - D
Ans - D [Link] in an Access table is also known as ____
[Link] MS Access, which data type is appropriate to (A) Type
store large text and numbers?
(B) Data
(A) Large Text
(C) Record
(B) OLE
(D) Field
(C) Memo
Ans - C
(D) Text
[Link] is a query that when run displays its own
Ans - C dialog box prompting you for information, such as
[Link] MS Access, AutoNumber Data Type (A) Append
(A) Can be Sequential (B) Parameter
(B) Can be Random (C) Crosstab
(C) Only A & B (D) Select
(D) Can be Edited Ans - B
Ans - C [Link] switch between to Form view from design
view, press ____
[Link] text data type, this can store up to
maximum of 65,535 characters. (A) F5
(A) Date/time (B) F8
(B) Number (C) F9
(C) Memo (D) F11
(D) All of above Ans - A
Ans - C [Link] of the following is not a field type in
access?
[Link] of the following data type stores text or a
combination of text and numbers? (A) Ole object
(A) Ole (B) Hyperlink
(B) Text (C) Memo
(C) Currency (D) Lookup wizard
(D) Number Ans - D
Ans - B [Link] how many views, you can create a table in
Access?
[Link] appropriate Data Type to store Time in MS
Access? (A) 2
(A) Time cannot be stored (B) 4
(B) Time (C) 6
(C) Time Only (D) 8
Ans - B (C) Field
[Link] program do you use to edit code for data (D) Query
access pages?
Ans - A
(A) Microsoft script editor
[Link] MS Access, OLE objects Data type can store
(B) Microsoft data access pages editor
(A) Microsoft Excel Spreadsheets
(C) Microsoft code editor
(B) Microsoft Word documents
(D) All of these
(C) Sounds
Ans - A
(D) All of the above
[Link] of the following is not a selection
Ans - D
technique?
[Link] of the following is not a valid Data Type
(A) To select a row, click the record selector box to
in MS Access?
the left of the row
(A) AutoNumber
(B) To select a column, double click anywhere in
the column (B) Currency
(C) To select a word, double click the word (C) Picture
(D) To select an entire table click the empty box to (D) Memo
the left of the field names
Ans - C
Ans - B
[Link] Access table, column is also known as ____
[Link] create queries in Access
(A) Type
(A) You can drag and drop fields on query builders
(B) Data
(B) You can type the SQL command in SQL view
(C) Record
(C) You can use query wizard or design view
(D) Field
(D) All of the above
Ans - D
Ans - D
[Link] columns in a Microsoft Access table are
[Link] table design view, which key can be used to called as ____
switch between the field names and properties
panels? (A) Fields
(A) F1 (B) Macro
(B) F6 (C) Columns
(C) F10 (D) Records
(D) F12 Ans - A
Ans - B [Link] a database table, the category of information
is called ____
26.A part of database that stores complete
information about an entity such as employee, (A) Tuple
sales, orders etc. (B) Field
(A) Record (C) Record
(B) File (D) All of above
Ans - B 37._ enables the user to automatically insert
numbers in a sequential or random number.
[Link] form displays multiple records, one per
row, in the form window (A) Auto Number
(A) Justified (B) Look up Wizard
(B) Columnar (C) Hyperlink
(C) Tabular (D) Ole object
(D) Datasheet Ans - A
Ans - D [Link] default and maximum size of text field in
access
[Link] of the following is not a Form style
available in the Form Wizard dialog box? (A) 50 and 255 characters
(A) Stone (B) 266 characters and 6400 characters
(B) Standard (C) 288 characters and 6880 characters
(C) Highlights (D) 299 characters and 6499 characters
(D) Blends Ans - A
Ans - C [Link] access levels are specified so as to
define who can access what in a database, it is
34.A search value can be exact value or it can be
identified
(A) Wild card character
through
(B) Comparison operation
(A) User ID
(C) Relationship
(B) Password
(D) Logical operator
(C) Status
Ans - A
(D) All of these
[Link] checking operation performed on input
Ans - A
data is called the
[Link] create a table in MS Access
(A) Control of data
(A) Database should be created before creating a
(B) Validation of data
table
(C) Cross check
(B) You should allow atleast one Primary key in a
(D) Verification of data table
Ans - B (C) Table can be created using Table Templates
36.A file containing relatively permanent data is (D) All of the above
(A) Sequential file Ans - D
(B) Transaction file [Link] the Save As dialog box
(C) Master file (A) F1
(D) Random file (B) F2
Ans - C (C) F10
(D) F12
Ans - D
[Link] tool do you use to create a query object?
(A) Table query wizard
(B) Simple query wizard
(C) Simple filer wizard
(D) Database wizard
Ans - B
[Link] Access, ____ are used to store the data.
(A) Report
(B) Form
(C) Table
(D) Query
Ans - C