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
Correct Answer :
C. A presentation created in PowerPoint
Related Questions
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
A database language concerned with the definition of the whole database structure and schema is ________
DCL
DML
DDL
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
A part of database that stores only one type of data is
Report
Field
Query
Record
Which of the following term is least related to database?
Attributes
Tuples
Relationship
Columns
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
Which of the following store command to retrieve data from database?
Forms
Reports
Queries
Tables
The size of Yes No field is always
1 bit
1 byte
1 character
1 GB
Collection of related records in a database is known as
File
Bench
Table
Relationship
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
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 field type will you select when creating a new table if you require to enter long text in that field?
Text
Memo
Currency
Hyperlink
A search value can be an exact value or it can be
Logical Operator
Relationship
Wild card character
Comparison operation
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 field type can store photos?
Hyperlink
OLE
Both of these can be used
Access tables cant store photos
To duplicate a controls formatting you can use___
Manager
Wizard
Painter
Control
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 an association established between common fields of two tables.
line
relationship
primary key
records
The two form layout types will display multiple records at one time are tabular and___
columnar
justified
date sheet
pivot table
Microsoft Access is a
RDBMS
OODBMS
ORDBMS
Network database model
In table design view what are the first column of buttons used for
Indicate Primary Key
Indicate Current Row
Both of above
None of 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
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
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 database can be best described as
Organized collection of data
Useful presentation of data
Graphical representation of data
All of 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
When entering field name, how many characters you can type in maximum?
60
64
68
Any number of character
Which of the following is not a database object in MS Access?
Tables
Query
Report
Relationship
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
Parameter
Select
crosstab
Append
The database language that allows you to access or maintain data in a database
DCL
DML
DDL
None of above