Pariksha Corner

Learn and practice Aptitude questions and answers with explanation for interview, competitive exam (Pariksha Corner )

MS Access



Tuesday, February 4, 2020

You have asked the Human Resources Executive to share with you the database of personal information of your team members. When you open the database file in MS­Access, you find that a few of the database columns are showing #### symbols in them. What should you perform to view the contents of these columns?

 | 

, , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-2 7-MAY­-2017 click here to view all questions
    You have asked the Human Resources Executive to share with you the database of personal information of your team members. When you open the database file in MS­Access, you find that a few of the database columns are showing #### symbols in them. What should you perform to view the contents of these columns?
    AIgnore the columns, it is corrupt data and cannot be viewed
    BContact the Human Resources Executive and get the problem resolved
    CBroaden the column to view the contents
    DChange the formatting of the cells
    View Answer

    Sunday, January 26, 2020

    You have stored your employee details in an Access 2010 database. You want to share employee pay details with your auditor. However, you do not want your auditor to actually work with your database. Which of the following would you need to create that allows you to organize and present the required data in a visually appealing format with your auditor?

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-1 7-MAY­-2017 click here to view all questions
    You have stored your employee details in an Access 2010 database. You want to share employee pay details with your auditor. However, you do not want your auditor to actually work with your database. Which of the following would you need to create that allows you to organize and present the required data in a visually appealing format with your auditor?
    AMacro
    BReports
    CForms
    DForms
    View Answer

    Saturday, January 25, 2020

    You want to create a drop-down list of product names as a field in a table in an MS-Access database. Each product name must be bound to the respective product ID in another table. Which of the following should you use to create a drop-down list?

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-3 2017 click here to view all questions
    You want to create a drop­down list of product names as a field in a table in an MS-Access database. Each product name must be bound to the respective product ID in another table. Which of the following should you use to create a drop-down list?
    AMemo
    BOLE Object
    CHyperlink
    DLookup Wizard
    View Answer

    Sunday, January 19, 2020

    You want to enter information for one record at a time in an MS­Access table. Which of the following object should you create?

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT-2 2017 click here to view all questions
    You want to enter information for one record at a time in an MS­Access table. Which of the following object should you create?
    AForms
    BTables
    CViews
    DQuery
    View Answer

    Saturday, January 4, 2020

    Assume a product table in an Access database with the following fields

     | 

    , , ,

  • Report
    • KPTCL Assistant Exam (Mescom) SLOT1 2017 click here to view all questions
    Assume a product table in an Access database with the following fields:
    1.ProductID
    2.Price
    3.Quantity
    Which of the following features in Access 2010 should you use to insert a Sales field in the Product table? The Sales field should hold the sales amount that can be calculated using the expression Price * Quantity.
    ACalculated fields
    BPivot tables
    CDefault values
    DExpressions
    View Answer

    Categories