primary key
key record
unique key
field name
A. primary key
Indicate Primary Key
Indicate Current Row
Both of above
None of above
Parameter
Select
crosstab
Append
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
Text
Memo
Currency
Hyperlink
Tables
Queries
Relationships
Reports
OLE Object
Hyperlink
Memo
Lookup Wizard
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
Rows
Records
Fields
Columns
line
relationship
primary key
records
DCL
DML
DDL
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
Home Tab
Create Tab
External Data Tab
Database Tab
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
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
Hyperlink
OLE
Both of these can be used
Access tables cant store photos
Select
crosstab
Parameter
Append
Logical Operator
Relationship
Wild card character
Comparison operation
Data presented in table in MS Word document
Data entered in Excel spreadsheet
A presentation created in PowerPoint
A telephone diary
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
Create table in Design View
Create Table using wizard
Create Table by Entering data
None of above
Tables
Query
Report
Relationship
Characters, Fields, Records, Tables, Files, Databases
Characters, Fields, Records, Tables, Database, Files
Databases, Tables, Files, Records, Field, Character
Files, Databases, Tables, Records, Fields, Characters
Sub form sub report
Relationships
Select objects
More controls
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
Foreign key
Native key
Composite key
Primary key
DCL
DML
DDL
None of above
Forms
Reports
Queries
Tables
Table
Box
Cell
Palette
From Edit menu choose Delete Relationship
Select the relationship line and press Delete
Choose Delete option from Relationship menu
All of above
Organized collection of data
Useful presentation of data
Graphical representation of data
All of above