datasheet view
design view
link table
None of the above
A. datasheet view
memo
data/time
number
All of above
Foreign key fields dont allow duplicate values
In primary key field you can enter duplicate value
In an indexed field you may or may not enter duplicate value depending upon setting
All statements are true
Table
Form
Worksheets
Modules
Create table in Design View
Create Table using wizard
Create Table by Entering data
All of above
Create table in Design View
Create Table using wizard
Create Table by Entering data
None of above
line
relationship
primary key
records
datasheet view
design view
link table
None of the above
Table
Field
Record
Character
Memo
Hyperlink
OLE Object
Lookup Wizard
Data
Information
Field
Record
Manager
Wizard
Painter
Control
Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table
Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table
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
Characters, Fields, Records, Tables, Files, Databases
Characters, Fields, Records, Tables, Database, Files
Databases, Tables, Files, Records, Field, Character
Files, Databases, Tables, Records, Fields, Characters
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
Input mask
Validation Rule
Indexed
IME Mode
Make button
Expression button
Build button
None of above
OR
IN
AND
LIKE
text
memo
auto number
None of the above
Query Wizard
Look up Wizard
Form Wizard
Report Wizard
A relationship is created
Edit relationship dialog box appears
Error occurs
Nothing happens
One to One
One to Many
Many to Many
All of above can be applied
columnar
justified
date sheet
pivot table
Table
Box
Cell
Palette
120
255
265
75
Organized collection of data
Useful presentation of data
Graphical representation of data
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 &
primary key
key word
filed name
All of above
means do not change the value in the primary key field if that record has related records in another table
means change all the related records in child tables if the record in parent table is changed
Both of above
None of above
RDBMS
OODBMS
ORDBMS
Network database model