Microsoft Access
 

  1. Question: Each field in a table should contain only _________.

    A
    One element of data.

    B
    three element of data

    C
    two element of data

    Note: Not available
    1. Report

  2. Question: How many data type are used in MS Access Database?

    A
    13

    B
    11

    C
    7

    D
    9

    Note: Not available
    1. Report

  3. Question: _____ is able to store and manipulate data across multiple tables.

    A
    Relational Table

    B
    Relational Form

    C
    Relational Database

    D
    Relational Report

    Note: Not available
    1. Report

  4. Question: 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

    Note: NA
    1. Report

  5. Question: 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
    None of these

    Note: not available
    1. Report

  6. Question: Which of the following is database object?

    A
    Table

    B
    Query

    C
    Form

    D
    All

    Note: Not available
    1. Report

  7. Question: 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.

    Note: Not available
    1. Report

  8. Question: Which one of the following is the extension of MS-Access 2007 database?

    A
    .mdb

    B
    .accdb

    C
    .xlsx

    D
    None

    Note: Not available
    1. Report

  9. Question: The wildcard "[ ]" refers to ______.

    A
    Matches any single alphabetic character within a string.

    B
    Matches any single character within the brackets

    C
    Matches any character not defined within the brackets

    D
    Matches any one of a range of characters defined within the brackets

    Note: Not available
    1. Report

  10. Question: To configure the properties of an object in MS-Access 2007, which of the following can we use?

    A
    Datasheet view

    B
    Design view

    C
    Table view

    D
    Print preview

    Note: Not available
    1. Report
First910111213Last
/15
Copyright © 2025. Powered by Intellect Software Ltd