Which field type can store photos?
Hyperlink
OLE
Both of these can be used
Access tables cant store photos
Correct Answer :
B. OLE
Related Questions
To duplicate a controls formatting you can use___
Manager
Wizard
Painter
Control
Which of the following creates a drop down list of values to choose from a list?
OLE Object
Hyperlink
Memo
Lookup Wizard
This key uniquely identifies each record
primary key
key record
unique key
field name
In a database table, the category of information is called ____________
tuple
field
record
All of 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
When entering field name, how many characters you can type in maximum?
60
64
68
Any number of character
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 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 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
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
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
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
You can set a controls border type to make the border invisible.
Transparent
Invisible
Do not display
No border
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
Which of the field has width 8 bytes?
Memo
Number
Date/Time
Hyperlink
The___ operator will cause a record to be selected only if two or more conditions are satisfied
Or
If or
Range
And
The size of a field with Number data type can not be
2
4
8
16
A database can be best described as
Organized collection of data
Useful presentation of data
Graphical representation of data
All of above
Which is not a view to display a table in Access?
Datasheet View
Design View
Pivot Table & Pivot Chart View
None of above
It is an association established between common fields of two tables.
line
relationship
primary key
records
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
It is a database object to view, change, and analyze data in different ways
query
form
report
None of the 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
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
Parameter
Select
crosstab
Append
Which of the following database object hold data?
Forms
Reports
Queries
Tables
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
Which of the following is NOT a type of Microsoft Access database object?
Table
Form
Worksheets
Modules
What do you mean by one to many relationship between Student and Class table?
One student can have many classes
One class may have many student
Many classes may have many students
Many students may have many classes
It is a query that when run displays its own dialog box prompting you for information, such as
Select
crosstab
Parameter
Append
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