[Link]-Access is a type of? to summarize data?
A. Utility software A. Table view
B. Application Software B. Design view
C. System software C. Data sheet view
D. None of these D. Pivot chart view
Ans - B Ans - D
[Link] Access is a _? [Link] key uniquely identifies each record
A. NETWORK DATABASE MODEL A. key record
B. RDBMS B. Composite key
C. ORDBMS C. foreign key
D. OODBMS D. primary key
Ans - B Ans - D
[Link] Access creates files are stored with __ [Link] object stores information about related
extension. data?
A. .docx A. Document
B. .xlsx B. Table
C. .accdb C. Page
D. .pptx D. Screen
Ans - C Ans - B
[Link] Access provides visual environment for [Link] create relationship between two tables
design of _? A. drag any field from parent table and drop on
A. tables child table
B. reports B. drag the foreign key of a table into the primary
C. forms key of another table
D. all of them C. drag the primary key of a table into foreign key
of another table
Ans - D D. None of the above
[Link] default, _ new table is displayed in view. Ans - C
A. Datasheet View
B. Design View 11._ enables the user to automatically insert
C. Report View numbers in a
D. Form View sequential or random number.
A. Auto Number
Ans - A B. Look up Wizard
C. Hyperlink
[Link] a database table, the category of information D. Ole object
is called ____
A. Tuple Ans - A
B. Field
C. Record 12.A __ is a unit of information in a __
D. All of above A. record, field
B. field, record
Ans - B C. data source, field
[Link] view is used to arrange table data in D. record, data source
different graphical layouts
Ans - B
Ans - A
[Link] is not a view to display a table in Access?
A. Datasheet View 19.A(n)___ is a major object that can run
B. Design View independent of a control.
C. Pivot Table & Pivot Chart View A. event
D. None of above B. property
C. procedure
Ans - D D. Macro
[Link] is an association established between Ans - D
common fields of two tables.
A. line [Link] columns in a Microsoft Access table are
B. relationship called as ____
C. primary key A. Fields
D. Records B. Macro
C. Columns
Ans - B D. Records
15.____can be created to help easy data entry in Ans - A
MS Access tables?
A. Form [Link] of the following is not a type of Microsoft
B. Report access database
C. database object?
D. spreadsheet A. Macros
B. Modules
Ans - A C. Worksheets
D. Table
[Link] complete information about an entity in a
database is called? Ans - D
A. Data
B. Information [Link] is the maximum length of the field name
C. Field in Access?
D. Record A. 16 characters
B. 32 characters
Ans - D C. 64 characters
D. 128 character
17.A primary key in any table has the properties?
A. Not Null Ans - C
B. No Duplicates
C. Both of above [Link] of related records in a database is
D. None of above known as?
A. File
Ans - C B. Bench
C. Table
18.A part of database that stores complete D. Relationship
information about an entity
such as employee, sales, orders etc. Ans - A
A. Record
B. File [Link] is the maximum number of characters
C. Field allowed in text field is
D. Query access?
A. 255 [Link] is a form that we can create in MS Access
B. 256 ?
C. 64000 A. It is used to take printout of a form from Access
D. 65000 Tables.
B. It is an input screen for viewing and entering
Ans - A data.
C. It is used for storing special data other than text.
25.___ is a component of database such as a table, D. It is optional. We can use Report instead of Form
query, form
and macro? Ans - B
A. Record
B. Object [Link] MS Access "Lookup Wizard" is used to?
C. Table A. to select from previous values
D. None of these B. to select values from Excel Sheet
C. to select value from another table
Ans - B D. Not a valid Data Type
[Link] task of arranging data in order is called? Ans - C
A. Searching
B. Sorting [Link] in an Access table is also known as ____?
C. Ordering A. Type
D. Shorting B. Data
C. Record
Ans - B D. Field
[Link] of the following is not a valid Data Type Ans - C
in MS Access?
A. AutoNumber [Link] data type allows alphanumeric characters
B. Currency and special symbols.
C. Picture A. Auto number
D. Memo B. Memo
C. Short Text
Ans - C D. All of the above
[Link] default data type for a field is? Ans - C
A. Varchar
B. AutoNumber [Link] create relationship between two tables
C. Number A. drag any field from parent table and drop on
D. Text child table
B. drag the foreign key of a table into the primary
Ans - D key of another table
C. drag the primary key of a table into foreign key
[Link] create a table in MS Access? of another table
A. Database should be created before creating a D. None of the above
table
B. You should allow at least one Primary key in a Ans - C
table
C. Table can be created using Table Templates [Link] field type will you select when creating a
D. All of the above new table if you
require to enter long text in that field ?
Ans - D A. Text
B. Currency
C. Memo C. Pivot table view
D. All of the above D. Pivot share view
Ans - C Ans - A
36.A ____ name must be unique within a database [Link] MS Access "Hyperlink" Data Type can store?
A. Table A. Web Address
B. Record B. email Address
C. Field C. Path of a File
D. All of the above D. All of Above
Ans - A Ans - D
[Link] field type can store photos ? [Link] of the following is use to get data from
A. Hyperlink user?
B. OLE A. Query
C. Memo B. Pages
D. Text C. Form
D. Report
Ans - B
Ans - C
[Link] data type is better to use for storing the
price of an item ? [Link] of the following expresses correct order?
A. Number A. Characters, Fields, Records, Tables, Files,
B. Text Databases
C. Currency B. Characters, Fields, Records, Tables, Database,
D. Hyperlink Files
C. Databases, Tables, Files, Records, Field,
Ans - C Character
D. Files, Databases, Tables, Records, Fields,
[Link] organized collection of logically related data Characters
is known as
A. Database Ans - A
B. Meta data
C. Information [Link] of the following is not a type of
D. None of the above relationship that can be
applied in Access database
Ans - A A. One to One
B. One to Many
[Link] do you call a primary key field included in C. Many to Many
another table ? D. All of the above
A. Child key
B. Composite key Ans - D
C. Parent key
D. Foreign key [Link] one-to-many relationship the table in ‘one’
side is called ___ and
Ans - D on ‘many’ side is called ___
A. Parent , Child
[Link] view allows to modify table’s structure in B. Child , Parent
Access? C. Row , Column
A. Design view D. None of the above
B. Datasheet view
Ans - A
47.A composite key is
A. Required when a table does not have any unique
fields in it
B. The primary key with AutoNumber as the field
type
C. Made up of two or more fields to uniquely
identify records
D. Is a foreign key that uniquely identifies records
Ans - C
48.____ button helps to search quickly for every
occurrence of a specific
word or phrase.
A. Justify
B. Find
C. Bullet
D. Sort
Ans - B
[Link] the Save As dialog box?
A. F1
B. F2
C. F10
D. F12
Ans - D
[Link] _ to quit MS Access?
A. Tab +F4
B. Esc+ W
C. Ctrl +F4
D. Alt+F4
Ans - D