MS-Access Quiz

1. Computer based record keeping system is known as

            a. CRKS

            b. DBMS

            c. DMS

            d. All of these

2. Duplication of data is known as

            a. Data Redundancy

            b. Data Repentance

            c. Data inconsistency

            d. All of these

3. Multiple copies of same data that mismatch, are known as

            a. Data Redundancy

            b. Data Repentance

            c. Data inconsistency

            d. All of these

4. A storage container storing data pertaining to simple object, subject or purpose is known as:

            a. Table

            b. Query

            c. Report

            d. Form

5. A field that uniquely identifies records in the table is known as:

            a. Primary key

            b. candidate key

            c. unique key

            d. special key

6. A statement that gives you filtered data according to your conditions and specifications, is called:

            a. Table

            b. Query

            c. Report

            d. Form

7. Access data types will be

            a. Text

            b. Memo

            c. Number

            d. All of these

8. Text fields can contain upto ……….. characters.

            a. 250

            b. 255

            c. 225

            d. None of these

9. A memo field in an access 2000 table can store upto ………. Characters.

            a. 64000

            b. 32000

            c. 16000

            d. None of these

10. OLE object is data type, its size will be

            a. Up to 1 Giga byte

            b. Up to 64,000

            c. Both

            d. None of these