It is a sign or symbol that specifies, operator, and values that produce a result
operator
query
expression
None of the above
Correct Answer :
A. operator
Related Questions
We can remove a relationship defined between two tables by
From Edit menu choose Delete Relationship
Select the relationship line and press Delete
Choose Delete option from Relationship menu
All of above
A __ name must be unique within a database
Table
Field
Record
Character
Which of the following may not be a database?
Data presented in table in MS Word document
Data entered in Excel spreadsheet
A presentation created in PowerPoint
A telephone diary
A __________ enables you to view data from a table based on a specific criterion
Form
Query
Macro
Report
The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
relationship
Join
Query
None of these
Which of the following is not a database object in MS Access?
Tables
Query
Report
Relationship
A database can be best described as
Organized collection of data
Useful presentation of data
Graphical representation of data
All of above
The expression builder is an access tool that controls an expression___ for entering an expression
Table
Box
Cell
Palette
Which of the following expresses correct order?
Characters, Fields, Records, Tables, Files, Databases
Characters, Fields, Records, Tables, Database, Files
Databases, Tables, Files, Records, Field, Character
Files, Databases, Tables, Records, Fields, Characters
The key uniquely identifies each record in a table.
primary key
key word
filed name
All of above
In one-to-many relationship the table in one side is called _______ and on many side is called _______
Child , Parent
Parent , Child
Brother , Sister
Father , Son
Queries in Access can be used as
view, change and analyze data in different ways
a source of records for forms and reports
Only a
Both a and b
What does the show check box in query design window indicate
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
What is the difference between Open and Open Exclusively?
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
Which of the following term is least related to database?
Attributes
Tuples
Relationship
Columns
What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
A relationship is created
Edit relationship dialog box appears
Error occurs
Nothing happens
If you need to edit a relationship
Right click the relationship line and choose Edit Relationship
Double click the relationship line
Both of above
None of above
It is a sign or symbol that specifies, operator, and values that produce a result
operator
query
expression
None of the above
To create relationship between two tables
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
Which of the following is not a field type in Access
Memo
Hyperlink
OLE Object
Lookup Wizard
A database object in MS Access that stores a question about the data in database?
Table
Form
Query
Report
The task of arranging data in order is called
Searching
Sorting
Ordering
Shorting
The___ operator will cause a record to be selected only if two or more conditions are satisfied
Or
If or
Range
And
A primary key in any table has the properties
Not Null
No Duplicates
Both of above
None of above
When creating a new table which method can be used to choose fields from standard databases and tables
Create table in Design View
Create Table using wizard
Create Table by Entering data
None of above
Which of the following store command to retrieve data from database?
Forms
Reports
Queries
Tables
While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
a doctors sign
thin + sign
outline rectangle
None of above
Which of the following is NOT a type of Microsoft Access database object?
Table
Form
Worksheets
Modules
When a picture or other graphic image is placed in the report header section it will appear____
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
You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view
Clicking
Right clicking
Double clicking
None of the above