You can drag and drop fields on query builders
you can type the SQL command in SQL view
You can use query wizard or design view
All of above
D. All of above
Table
Field
Record
Character
RDBMS
OODBMS
ORDBMS
Network database model
Create table in Design View
Create Table using wizard
Create Table by Entering data
All of 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
Home Tab
Create Tab
External Data Tab
Database Tab
Foreign key
Native key
Composite key
Primary key
Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar
Open table, click Sort button on database toolbar, choose field based on which to sort, click OK
Click the field heading to sort it ascending or descending
All of above
You can drag and drop fields on query builders
you can type the SQL command in SQL view
You can use query wizard or design view
All of above
Attributes
Tuples
Relationship
Columns
Tables
Queries
Relationships
Reports
Parameter
Select
crosstab
Append
data definition
data refinement
establishing relationship
none of the above
Data
Information
Field
Record
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
Create table in Design View
Create Table using wizard
Create Table by Entering data
None of above
Forms
Reports
Queries
Tables
Clicking
Right clicking
Double clicking
None of the above
Form
Query
Macro
Report
Rows
Records
Fields
Columns
Foreign key
Native key
Composite key
Primary key
Datasheet View
Design View
Pivot Table & Pivot Chart View
None of above
Report
Field
Query
Record
You need to delete the whole tablThere is no method to remove a particular field only.
Delete all the fields from third downwards and reenter the required fields again.
Select the third column in datasheet view then Delete
Select the third row in table design view then Delete
Logical Operator
Relationship
Wild card character
Comparison operation
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
Table
Form
Worksheets
Modules
text
memo
auto number
None of the above
DCL
DML
DDL
None of above
OR conditions
AND conditions
NOT condition
None of above
Table
Form
Query
Report