MCQ (Module – 5) : 

1. Which one of the following stores the whole value entered but only displays the number up to two decimal places?
A. General Number                        B. Fixed
C. Standard                                     D. Currency

2. An index is automatically created on
A. Primary key field        B. Foreign key field
C. Id Number                     D. All of them

3. What do you mean by * symbol?

A. It represents the column currently selected.

B. It represents the row previously selected.
C. It represents the row currently selected
D. None of the above

4. Which one of the following statements is not correct related to Primary key?
 A. A primary key is used as unique identifier for each column
B. A primary key field can never be left empty
C. When working with related tables, the primary key field in one table can be used as foreign key field in another table.
D. Both B & C

5. Null value is allowed in
A. Unique key field         B. Primary key field
C. Foreign key field         D. Both A& C

6. Which of the following is/are database objects?
A. Table                                B. Query
C. Form                                D. All

7. To locate a particular record which of the following options of the navigation bar can we use ?
A. First                                                 B. Specific
C. Next                                                 D. Last

8. Which one of the following statements is not correct related to Index?
A. An index stores the location of records.
B. Index may speed up searches, it can also slow the process of updating data within table.
C. You can set index on a field which is seldom used
D. You can set index on any fields except OLE objects or attachment fields .

9. What do you mean by Like ”A????”
A. Entry must be four characters and begin with the
letter A
B. Entry must be five characters and begin with the letter A
C. Entry must be five characters and begin with any letter.
D. None

10. Which one of the following is the extension of MS-Access 2007 database?
A. .mdb                                                B. .accdb
C. .xlsx                                                  D. None

MCQ (Module – 5) :  b

1. In which row of query design grid do we set conditions ?
A. Field                                 B. Sort
C. Criteria                            D. Show

2. Which of the following presents data in a way similar to an Excel spread sheet?
A. Data sheet view          B. Design view
C. Print preview                D. Layout preview

3. Filters remain in place until—
A. They are removed     B. The object is closed
C. Both A & B               D. Only A

 4. From the following options, which is/are valid report layout(s)?
A. Stepped                         B. Block
C. Portrait                            D. Both A & B

5. Which one is correct regarding relationships?
A. You can not edit or delete relationship.
B. Many to Many relationships between tables are considered as an ideal relationship.
C. You can not editable after establishing relationship
D. None

6. Why do we use Filter?
A. To find more specific record
B. Sorting field in different direction
C. Filtering out records that we don’t want
D. All of the above

7. Which of the following views does not allow the form to be modified?
A. Layout view                  B. Form View
C. Design view                   D. All

8. How can you export a table or query output as an excel spreadsheet?
A. Open an access database, open file queries, click external data tab, clicks Export to XML icon.
B. Open an access database, open file queries, Click external data tab, click Export to Excel Spread sheet icon.
C. Open an access database, open file queries, Click external data tab, Saved import icon.
D. None

9. In the memo data type you can insert data up to ____characters.
A. 350                                    B. Unlimited
C. 10000                               D. 65535

10. In the table when you are inserting the data, the power suddenly goes off. What will happen?
A. All data is lost                               B. A few data is lost
C. All data is save                             D. A few data is save