Home Tab
Create Tab
External Data Tab
Database Tab
D. Database Tab
2
4
8
16
Form
Query
Macro
Report
Clicking
Right clicking
Double clicking
None of the above
It is a printed page where users will write their data to fill it up
It is an input screen designed to make the viewing and entering data easier
This is an important part of database used by analysts to draw conclusions
All of above
Organized collection of data
Useful presentation of data
Graphical representation of data
All of above
From Edit menu choose Delete Relationship
Select the relationship line and press Delete
Choose Delete option from Relationship menu
All of above
Rows
Records
Fields
Columns
Forms
Reports
Queries
Tables
Or
If or
Range
And
Table
Form
Query
Report
line
relationship
primary key
records
OLE Object
Hyperlink
Memo
Lookup Wizard
Right click the relationship line and choose Edit Relationship
Double click the relationship line
Both of above
None of above
Open statement opens access database files and Open Exclusively opens database files of other program like Oracle
Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed
Both Open and Open Exclusively are same
Open Exclusive command does not exist in MS Access
The facility to easy editing, spelling check, auto pagination, lay out and printing reports
The ability to store large amount of data to facilitate easy update, sort and retrieval
The ability to calculate efficiently with the help of built-in functions and analyze
All of above
Type PRIMARY in field type box when creating required field
Mark the Primary check box in field name of required field
Click the Primary Key button in Design ribbon when the cursor is in required field
None of the above
view, change and analyze data in different ways
a source of records for forms and reports
Only a
Both a and b
Not Null
No Duplicates
Both of above
None of above
Change the structure of tables
insert, update or delete records and data values
authorizing access and other control over database
None of above
Query Wizard
Look up Wizard
Form Wizard
Report Wizard
Logical Operator
Relationship
Wild card character
Comparison operation
columnar
justified
date sheet
pivot table
It indicates whether the field is to be used or not
It indicates whether the field is to be displayed in query result or not
It indicates whether the field names to be displayed in query result or not
None of above
File
Bench
Table
Relationship
DCL
DML
DDL
None of above
Address book of all the suppliers of a company
Salary sheet of all the employees of a company
Records of daily sales transactions of a company
All of above
data definition
data refinement
establishing relationship
none of the above
Transparent
Invisible
Do not display
No border
Memo
Hyperlink
OLE Object
Lookup Wizard
Input mask
Validation Rule
Indexed
IME Mode