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
C. Made up of two or more fields to uniquely identify records
a doctors sign
thin + sign
outline rectangle
None of above
Or
If or
Range
And
Manager
Wizard
Painter
Control
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
One to One
One to Many
Many to Many
All of above can be applied
text
memo
auto number
None of the above
line
relationship
primary key
records
Table
Field
Record
Character
DCL
DML
DDL
None of above
Memo
Hyperlink
OLE Object
Lookup Wizard
2
4
8
16
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
Fields
Data Types
Relations
Tables
Parameter
Select
crosstab
All of above
columnar
justified
date sheet
pivot table
Change the structure of tables
insert, update or delete records and data values
authorizing access and other control over database
None of above
relationship
Join
Query
None of these
memo
data/time
number
All of above
Characters, Fields, Records, Tables, Files, Databases
Characters, Fields, Records, Tables, Database, Files
Databases, Tables, Files, Records, Field, Character
Files, Databases, Tables, Records, Fields, Characters
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
File
Bench
Table
Relationship
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
Data presented in table in MS Word document
Data entered in Excel spreadsheet
A presentation created in PowerPoint
A telephone diary
Report
Field
Query
Record
Child , Parent
Parent , Child
Brother , Sister
Father , Son
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
From Edit menu choose Delete Relationship
Select the relationship line and press Delete
Choose Delete option from Relationship menu
All of above
Right click the relationship line and choose Edit Relationship
Double click the relationship line
Both of above
None 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
Datasheet View
Design View
Pivot Table & Pivot Chart View
None of above