Forms
Reports
Queries
Tables
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
relationship
Join
Query
None of these
Report
Field
Query
Record
One to One
One to Many
Many to Many
All of above can be applied
Hyperlink
OLE
Both of these can be used
Access tables cant store photos
operator
query
expression
None of the above
Select
crosstab
Parameter
Append
Not Null
No Duplicates
Both of above
None of above
Required when a table does not have any unique fields in it
The primary key with AutoNumber as the field type
Made up of two or more fields to uniquely identify records
Is a foreign key that uniquely identifies records
Sub form sub report
Relationships
Select objects
More controls
Transparent
Invisible
Do not display
No border
50 and 255 Characters
8 and 1 GB
266 characters & 64000 characters
None of above
a doctors sign
thin + sign
outline rectangle
None of above
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
DCL
DML
DDL
None of above
query
form
report
None of the above
Foreign key
Native key
Composite key
Primary key
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
OR
IN
AND
LIKE
primary key
key record
unique key
field name
Forms
Reports
Queries
Tables
1 bit
1 byte
1 character
1 GB
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
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
Organized collection of data
Useful presentation of data
Graphical representation of data
All of above
60
64
68
Any number of character
datasheet view
design view
link table
None of the above
Data
Information
Field
Record
From Edit menu choose Delete Relationship
Select the relationship line and press Delete
Choose Delete option from Relationship menu
All of above