Which of the following is a collection of information that is related to a particular subject or purpose?
Database
Data structure
Data warehouse
Relational data
How many characters can be stored in the data type ‘memo’ that is used for lengthy text and numbers?
65,534
65,536
65,543
65,538
Which table view can be used to create a chart from the Pivot Table view?
Chart view
Pivot chart view
Table chart view
None of these
Which of the following provides a convenient way to summarize data about groups of records?
Pivot Table view
Design view
Pivot Data view
Pivot Chart view
Which one can control the storage, retrieval, security and integrity of data in a database?
DBMS
Data abstraction
Database design
DML
Which symbol in the datasheet view indicates the status of the record?
Insert selector
Record selector
Format selector
View selector
Which database object would be most convenient to enter or edit the data in the tables?
Reports
Procedures
Forms
Macros
What will be called the value of a column within a record?
Text
Field
Datatype
Constraints
Which of the following is an example of DBMS?
Microsoft excel
Microsoft Outlook
Microsoft Access
Microsoft Groove
Which of the database object will filter the data and retrieve the selected records or fields from the database?
Query
Record
