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
C. Both of above
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
Parameter
Select
crosstab
All of above
Address book of all the suppliers of a company
Salary sheet of all the employees of a company
Records of daily sales transactions of a company
All of above
Hyperlink
OLE
Both of these can be used
Access tables cant store photos
Fields
Data Types
Relations
Tables
Name of fields, field type and size
Tables with fields and relationships between tables
Criteria
Sorting check boxes
One student can have many classes
One class may have many student
Many classes may have many students
Many students may have many classes
view, change and analyze data in different ways
a source of records for forms and reports
Only a
Both a and b
a doctors sign
thin + sign
outline rectangle
None of above
Right click the relationship line and choose Edit Relationship
Double click the relationship line
Both of above
None of above
line
relationship
primary key
records
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
It indicates whether the field is to be used or not
It indicates whether the field is to be displayed in query result or not
It indicates whether the field names to be displayed in query result or not
None of above
Database Window
Query Window
Design View Window
Switchboard
2
4
8
16
text
memo
auto number
None of the 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
Organized collection of data
Useful presentation of data
Graphical representation of data
All of above
data definition
data refinement
establishing relationship
none of the above
OLE Object
Hyperlink
Memo
Lookup Wizard
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
Text
Memo
Currency
Hyperlink
Change the structure of tables
insert, update or delete records and data values
authorizing access and other control over database
None of above
Data presented in table in MS Word document
Data entered in Excel spreadsheet
A presentation created in PowerPoint
A telephone diary
datasheet view
design view
link table
None of the above
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
Select
crosstab
Parameter
Append
Sub form sub report
Relationships
Select objects
More controls
primary key
key word
filed name
All of above