Which of the following database object produces the final result to present?
Forms
Reports
Queries
Tables
Correct Answer :
B. Reports
Related Questions
Both conditions display on the same row in the design grid when ___operator is in use
OR
IN
AND
LIKE
Collection of related records in a database is known as
File
Bench
Table
Relationship
The database language that allows you to access or maintain data in a database
DCL
DML
DDL
None of above
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
To duplicate a controls formatting you can use___
Manager
Wizard
Painter
Control
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
An Access database object that is used to enter, view or edit records
Table
Form
Query
Report
The expression builder is an access tool that controls an expression___ for entering an expression
Table
Box
Cell
Palette
In table design view, which key can be used to switch between the field names and properties panels?
F3
F4
F5
F6
If you write criteria values vertically (one in a row) it will mean
OR conditions
AND conditions
NOT condition
None of above
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
How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:
Query Wizard
Look up Wizard
Form Wizard
Report Wizard
It is an association established between common fields of two tables.
line
relationship
primary key
records
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
When entering field name, how many characters you can type in maximum?
60
64
68
Any number of character
Which field type can store photos?
Hyperlink
OLE
Both of these can be used
Access tables cant store photos
Following is not a database model
network database model
relational database model
Object Oriented database model
None
It is most common type of query. It retrieves records from one or more tables and then displays the
Parameter
Select
crosstab
All of above
Each record is constituted by a number of individual data items which are called
Fields
Data Types
Relations
Tables
It is a database object to view, change, and analyze data in different ways
query
form
report
None of the above
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
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
The size of a field with Number data type can not be
2
4
8
16
Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
Foreign key
Native key
Composite key
Primary key
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 &
The key uniquely identifies each record in a table.
primary key
key word
filed name
All of above
Which of the following is not a database object?
Tables
Queries
Relationships
Reports
The__ button on the tool box display data from a related table
Sub form sub report
Relationships
Select objects
More controls
The___ operator will cause a record to be selected only if two or more conditions are satisfied
Or
If or
Range
And