Table
Form
Query
Report
C. Query
data definition
data refinement
establishing relationship
none of the above
DCL
DML
DDL
All of above
Home Tab
Create Tab
External Data Tab
Database Tab
Database Window
Query Window
Design View Window
Switchboard
50 and 255 Characters
8 and 1 GB
266 characters & 64000 characters
None of above
memo
data/time
number
All of above
Name of fields, field type and size
Tables with fields and relationships between tables
Criteria
Sorting check boxes
120
255
265
75
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
relationship
Join
Query
None of these
Create table in Design View
Create Table using wizard
Create Table by Entering data
All of above
1 bit
1 byte
1 character
1 GB
Logical Operator
Relationship
Wild card character
Comparison operation
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
Table
Form
Query
Report
Searching
Sorting
Ordering
Shorting
Data
Information
Field
Record
Clicking
Right clicking
Double clicking
None of the above
Change the structure of tables
insert, update or delete records and data values
authorizing access and other control over database
None of above
Foreign key
Native key
Composite key
Primary key
Or
If or
Range
And
Make button
Expression button
Build button
None 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
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
Foreign key
Native key
Composite key
Primary key
Manager
Wizard
Painter
Control
Create table in Design View
Create Table using wizard
Create Table by Entering data
None of above
Query Wizard
Look up Wizard
Form Wizard
Report Wizard
query
form
report
None of the above
Memo
Number
Date/Time
Hyperlink