Or
If or
Range
And
operator
query
expression
None of the above
OR conditions
AND conditions
NOT condition
None of above
DCL
DML
DDL
None of above
Searching
Sorting
Ordering
Shorting
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
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
File
Bench
Table
Relationship
Home Tab
Create Tab
External Data Tab
Database Tab
2
4
8
16
Not Null
No Duplicates
Both of above
None of above
Create table in Design View
Create Table using wizard
Create Table by Entering data
None of above
columnar
justified
date sheet
pivot table
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
write criteria values vertically one in a row
write criteria values horizontally
Write criteria values in same field separated with AND
Write criteria values in same field separated with &
Characters, Fields, Records, Tables, Files, Databases
Characters, Fields, Records, Tables, Database, Files
Databases, Tables, Files, Records, Field, Character
Files, Databases, Tables, Records, Fields, Characters
Indicate Primary Key
Indicate Current Row
Both of above
None of above
Tables
Query
Report
Relationship
From Edit menu choose Delete Relationship
Select the relationship line and press Delete
Choose Delete option from Relationship menu
All of above
Datasheet View
Design View
Pivot Table & Pivot Chart View
None of above
Forms
Reports
Queries
Tables
primary key
key word
filed name
All of above
line
relationship
primary key
records
Right click the relationship line and choose Edit Relationship
Double click the relationship line
Both of above
None of above
Clicking
Right clicking
Double clicking
None of the above
One to One
One to Many
Many to Many
All of above can be applied
Name of fields, field type and size
Tables with fields and relationships between tables
Criteria
Sorting check boxes
Change the structure of tables
insert, update or delete records and data values
authorizing access and other control over database
None of above
data definition
data refinement
establishing relationship
none of the above
Table
Form
Query
Report