CS-10 Chapter-8 DBMS Part 3: Rabin Ghimire

Form is designed for ...

• Filter data
• Print data

• Modify data
• Sort data

Which of the following is not a data type in MS-Access?

• Text
• Date/Time
• Picture
• Number

What type of data type is used to store picture in a table?

• Memo
• OLE object
• Hyperlink
• Currency

The maximum field size of Number data type in MS-Access is …

• 1, 3, 5, or 9 bytes
• 1, 2, 4, or 8 bytes
• No limit
• 2, 4, 6, or 12 bytes

The maximum field size of Currency data type in MS-Access is …

• 4 bytes
• 2 bytes
• 8 bytes
• 12 bytes

The maximum field size of Lookup Wizard data type in MS-Access is …

• 2 bytes
• 8 bytes
• 6 bytes
• 4 bytes

Which of the following is/are the advantages of DBMS?

• Stores huge amount of data records
• Provides backup and recovery
• Initial cost is low
• Reduce data redundancy

Which of the following is/are the field properties of MS-Access?

• Default value
• Required
• Validation text
• OLE object

Using the query object user can

• add new data record
• view records in sorted form
• retrieve filtering the data records
• print data records

The object of MS-Access that stores the data is known as …

(a)