Which of the following is a database management system software that can be used to store data , add , modify or delete data , find data , solve queries about the data and produce reports?
Database
SQL
MS Access
None of these
Full form of DBMS is
Data Base Microsoft System
Data Base Microsoft Server
Data Base Management System
Data Base Management Server
Which of the following is not a valid data type in MS Access?
Memo
Picture
Currency
Auto Number
_________ are used to summarize , and present data in the tables.
Queries
Forms
Reports
Pages
Duplication of data is called :
Data storage
Data redundancy
Data base
What do you call a primary key field included in another table ?
Parent key
Foreign key
Child key
Index
In MS Access , which data type is appropriate to store large text and numbers?
Text
OLE
Large Text
Which is a collection of declarations , statements and procedures written in the Visual Basic for Applications programming language ?
Files
Programs
Modules
Projects
The appropriate data type to store time in MS Access is :
Date / Time
Time only
Time
Time cannot be stored
