One to One
One to Many
Many to Many
All of above can be applied
D. All of above can be applied
Once in the beginning of the report
At the top of every page
Every after record break
On the 1st and last pages of the report
Manager
Wizard
Painter
Control
It is a printed page where users will write their data to fill it up
It is an input screen designed to make the viewing and entering data easier
This is an important part of database used by analysts to draw conclusions
All 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
Name of fields, field type and size
Tables with fields and relationships between tables
Criteria
Sorting check boxes
Indicate Primary Key
Indicate Current Row
Both of above
None of above
Foreign key
Native key
Composite key
Primary key
line
relationship
primary key
records
text
memo
auto number
None of the above
50 and 255 Characters
8 and 1 GB
266 characters & 64000 characters
None of above
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
Hyperlink
OLE
Both of these can be used
Access tables cant store photos
Rows
Records
Fields
Columns
primary key
key word
filed name
All of above
Memo
Number
Date/Time
Hyperlink
columnar
justified
date sheet
pivot table
Not Null
No Duplicates
Both of above
None of above
Forms
Reports
Queries
Tables
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
Or
If or
Range
And
Query Wizard
Look up Wizard
Form Wizard
Report Wizard
Parameter
Select
crosstab
Append
F3
F4
F5
F6
Searching
Sorting
Ordering
Shorting
120
255
265
75
OR conditions
AND conditions
NOT condition
None of above
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
Attributes
Tuples
Relationship
Columns
OLE Object
Hyperlink
Memo
Lookup Wizard
RDBMS
OODBMS
ORDBMS
Network database model