drag the primary key of a table into foreign key of another table
drag the foreign key of a table into the primary key of another table
drag any field from parent table and drop on child table
Any of above can be done to create relationship
A. drag the primary key of a table into foreign key of another table
50 and 255 Characters
8 and 1 GB
266 characters & 64000 characters
None of above
Data
Information
Field
Record
Foreign key
Native key
Composite key
Primary key
datasheet view
design view
link table
None of the above
Rows
Records
Fields
Columns
Not Null
No Duplicates
Both of above
None of above
Data presented in table in MS Word document
Data entered in Excel spreadsheet
A presentation created in PowerPoint
A telephone diary
Home Tab
Create Tab
External Data Tab
Database Tab
Characters, Fields, Records, Tables, Files, Databases
Characters, Fields, Records, Tables, Database, Files
Databases, Tables, Files, Records, Field, Character
Files, Databases, Tables, Records, Fields, Characters
RDBMS
OODBMS
ORDBMS
Network database model
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
F3
F4
F5
F6
Report
Field
Query
Record
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
Table
Form
Query
Report
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
Form
Query
Macro
Report
Forms
Reports
Queries
Tables
Forms
Reports
Queries
Tables
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
a doctors sign
thin + sign
outline rectangle
None of above
Child , Parent
Parent , Child
Brother , Sister
Father , Son
relationship
Join
Query
None of these
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
DCL
DML
DDL
All of above
network database model
relational database model
Object Oriented database model
None
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 &
From Edit menu choose Delete Relationship
Select the relationship line and press Delete
Choose Delete option from Relationship menu
All of above
Fields
Data Types
Relations
Tables
Parameter
Select
crosstab
All of above