Which of the following store command to retrieve data from database?
Forms
Reports
Queries
Tables
Correct Answer :
C. Queries
Related Questions
The default and maximum size of text field in Access
50 and 255 Characters
8 and 1 GB
266 characters & 64000 characters
None 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
To achieve AND effect when you are entering criteria in a query design window
write criteria values vertically one in a row
write criteria values horizontally
Write criteria values in same field separated with AND
Write criteria values in same field separated with &
Which of the following store command to retrieve data from database?
Forms
Reports
Queries
Tables
It is a query that when run displays its own dialog box prompting you for information, such as
Select
crosstab
Parameter
Append
To sort records in a table
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
Which of the following statement is true
Reports can be used to retrieve data from tables and calculate
Queries can be printed in well formatted manner and presented as the information
Queries can include calculated fields that do not exist in table
Reports and forms are similar but forms are use to print but reports to display on screen only
Which field type will you select when creating a new table if you require to enter long text in that field?
Text
Memo
Currency
Hyperlink
You can set a controls border type to make the border invisible.
Transparent
Invisible
Do not display
No border
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
This key uniquely identifies each record
primary key
key record
unique key
field name
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
Which of the following is not a field type in Access
Memo
Hyperlink
OLE Object
Lookup Wizard
What are the columns in a Microsoft Access table called?
Rows
Records
Fields
Columns
Which of the following is not a type of relationship that can be applied in Access database
One to One
One to Many
Many to Many
All of above can be applied
A database can be best described as
Organized collection of data
Useful presentation of data
Graphical representation of data
All of above
It is a sign or symbol that specifies, operator, and values that produce a result
operator
query
expression
None of the above
Database Management Systems are featured with:
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
Referential integrity means
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
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
Home Tab
Create Tab
External Data Tab
Database Tab
In a database table, the category of information is called ____________
tuple
field
record
All of above
The size of Yes No field is always
1 bit
1 byte
1 character
1 GB
Unlike text data type, this can store up to maximum of 65, 535 characters.
memo
data/time
number
All 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
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
This option allows you to build a new table by entering data directly into the datasheet.
datasheet view
design view
link table
None of the above
If I create Student field in Fees table to store student_id of Students table, then this Student field in Fees table is called:
Foreign key
Native key
Composite key
Primary key
A search value can be an exact value or it can be
Logical Operator
Relationship
Wild card character
Comparison operation
It is a database object to view, change, and analyze data in different ways
query
form
report
None of the above
The command center of access file that appears when you create or open the MS Access database file.
Database Window
Query Window
Design View Window
Switchboard