Sub form sub report
Relationships
Select objects
More controls
A. Sub form sub report
Manager
Wizard
Painter
Control
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
Pivot Table & Pivot Chart View
None of above
Memo
Hyperlink
OLE Object
Lookup Wizard
view, change and analyze data in different ways
a source of records for forms and reports
Only a
Both a and b
datasheet view
design view
link table
None of the above
Memo
Number
Date/Time
Hyperlink
Table
Field
Record
Character
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
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
Foreign key
Native key
Composite key
Primary key
Child , Parent
Parent , Child
Brother , Sister
Father , Son
Table
Form
Query
Report
Foreign key
Native key
Composite key
Primary key
One to One
One to Many
Many to Many
All of above can be applied
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
Hyperlink
OLE
Both of these can be used
Access tables cant store photos
File
Bench
Table
Relationship
OLE Object
Hyperlink
Memo
Lookup Wizard
Make button
Expression button
Build button
None of above
network database model
relational database model
Object Oriented database model
None
50 and 255 Characters
8 and 1 GB
266 characters & 64000 characters
None of above
Fields
Data Types
Relations
Tables
data definition
data refinement
establishing relationship
none of the above
OR conditions
AND conditions
NOT condition
None of above
A relationship is created
Edit relationship dialog box appears
Error occurs
Nothing happens
Text
Memo
Currency
Hyperlink
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