Fields
Data Types
Relations
Tables
A. Fields
F3
F4
F5
F6
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
120
255
265
75
Searching
Sorting
Ordering
Shorting
Form
Query
Macro
Report
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
Hyperlink
OLE
Both of these can be used
Access tables cant store photos
A relationship is created
Edit relationship dialog box appears
Error occurs
Nothing happens
DCL
DML
DDL
All of above
Logical Operator
Relationship
Wild card character
Comparison operation
From Edit menu choose Delete Relationship
Select the relationship line and press Delete
Choose Delete option from Relationship menu
All of above
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
memo
data/time
number
All of above
Forms
Reports
Queries
Tables
Table
Form
Worksheets
Modules
DCL
DML
DDL
None of above
Type PRIMARY in field type box when creating required field
Mark the Primary check box in field name of required field
Click the Primary Key button in Design ribbon when the cursor is in required field
None of the above
From Edit menu choose Delete Relationship
Select the relationship line and press Delete
Choose Delete option from Relationship menu
All of above
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
datasheet view
design view
link table
None of the 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
data definition
data refinement
establishing relationship
none of the above
Indicate Primary Key
Indicate Current Row
Both of above
None of above
OR conditions
AND conditions
NOT condition
None of above
Table
Field
Record
Character
Parameter
Select
crosstab
All of above
Input mask
Validation Rule
Indexed
IME Mode
Transparent
Invisible
Do not display
No border
60
64
68
Any number of character
Create table in Design View
Create Table using wizard
Create Table by Entering data
None of above