Searching
Sorting
Ordering
Shorting
B. Sorting
Table
Field
Record
Character
a doctors sign
thin + sign
outline rectangle
None of above
Forms
Reports
Queries
Tables
Query Wizard
Look up Wizard
Form Wizard
Report Wizard
Make button
Expression button
Build button
None of above
Create table in Design View
Create Table using wizard
Create Table by Entering data
None of above
Database Window
Query Window
Design View Window
Switchboard
Tables
Query
Report
Relationship
Parameter
Select
crosstab
Append
Table
Form
Query
Report
Tables
Queries
Relationships
Reports
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
Rows
Records
Fields
Columns
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
60
64
68
Any number of character
RDBMS
OODBMS
ORDBMS
Network database model
Forms
Reports
Queries
Tables
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
A relationship is created
Edit relationship dialog box appears
Error occurs
Nothing happens
Data
Information
Field
Record
Foreign key
Native key
Composite key
Primary key
File
Bench
Table
Relationship
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
Datasheet View
Design View
Pivot Table & Pivot Chart View
None of above
Not Null
No Duplicates
Both of above
None of above
Create table in Design View
Create Table using wizard
Create Table by Entering data
All of above
Foreign key
Native key
Composite key
Primary key
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
query
form
report
None of the above
Reports can be used to retrieve data from tables and calculate
Queries can be printed in well formatted manner and presented as the information
Queries can include calculated fields that do not exist in table
Reports and forms are similar but forms are use to print but reports to display on screen only