MS Access Basics

  1. Question: Which is not related to relationship?

    A
    Avoid duplicate data

    B
    Data can be entered into or viewed from one or more tables

    C
    Create inconsistency of data

    D
    None

    Note: Not available
    1. Report

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

    Note: Not available
    1. Report

  3. Question: Access 2007 supports which type of database system?

    A
    DBMS

    B
    RDBMS

    C
    Flat file system

    D
    ORDBMS

    Note: Not available
    1. Report

  4. Question: Which one is correct regarding relationships?

    A
    You cannot edit or delete relationship.

    B
    Many to Many relationship between tables is considered as an ideal relationship.

    C
    You can not edit table after establishing relationship

    D
    None

    Note: Not available
    1. Report

  5. Question: To create a relationship what should you do?

    A
    Click Insert menu and then click Relationship

    B
    Click Database Tools tab and click Relationship button

    C
    Click Edit menu and then click Relationship

    D
    Press Ctrl + Shift + P

    Note: Not available
    1. Report

  6. Question: Of the following options, which is/are valid report layout(s)?

    A
    Stepped

    B
    Block

    C
    portrait

    D
    All

    Note: Not available
    1. Report

  7. Question: How can you get "Simple query wizard" tool?

    A
    Database tool > Query Wizard > Simple Query Wizard

    B
    Create tab > Query Wizard > Simple Query Wizard

    C
    Create tab > Query design > Simple Query Wizard

    D
    None

    Note: Not available
    1. Report

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

    Note: Not available
    1. Report

  9. Question: Updating all tables that are dependent upon a main or master table is called

    A
    Cascade delete

    B
    Cascade update

    C
    Referential integrity

    D
    None

    Note: Not available
    1. Report

  10. Question: In which row of query design grid do we set conditions?

    A
    Field

    B
    sort

    C
    criteria

    D
    show

    Note: Not available
    1. Report
First11121314Last
/14
Copyright © 2024. Powered by Intellect Software Ltd