1. Question: Which of the given text field properties you should set in order to force a user to enter a date value specifically in MM-DD-YYYY format?

    A
    Indexed

    B
    Limit to List

    C
    Input Mask

    D
    Allow Value List Edits

    Note: not sure
    1. Report
  2. Question: Which datatype would be the most suitable to store a Hyperlink in a field of an Access 2003 table?

    A
    char

    B
    varchar

    C
    hyperlink datatype

    D
    nchar

    E
    nvarchar

    Note: not sure
    1. Report
  3. Question: Password protected databases offer:

    A
    Only one password with full rights

    B
    Different user rights for different logins/passwords

    C
    Options for data editing rights versus the right to change designs

    D
    Integrated security with Active Directory

    Note: not sure
    1. Report
  4. Question: An .mde file is a special version of an Access .mdb file and contains information related to a database. Which of the following is true about an .mde file?

    A
    It contains compiled VBA code to prevent users from viewing code.

    B
    It allows users to view, but not modify VBA code

    C
    It can be saved as an .mdb file in order to make design changes.

    D
    It allows users to import forms and reports from other databases

    Note: not sure
    1. Report
  5. Question: Which of the following statements about Report Snapshots is untrue?

    A
    The Snapshot Viewer allows you to share Access reports with people who do not have Access installed.

    B
    Report Snapshots can only be viewed from within Access or the Access Runtime.

    C
    A Report Snapshot preserves the two-dimensional layout, graphics, and other embedded objects of the report.

    D
    Report Snapshots allow you to share reports electronically.

    Note: not sure
    1. Report
  6. Question: How do you import a portion of an Excel spreadsheet into Access?

    A
    TransformXML Method

    B
    ImportXML Method

    C
    TransferSpreadsheet Method

    Note: not sure
    1. Report
  7. Question: Which of the following statements is correct regarding Crosstab queries?

    A
    Multiple Value fields can be specified

    B
    Multiple Column Headings can be specified

    C
    Multiple Row headings can be specified

    Note: not sure
    1. Report
  8. Question: Which property of the Group Header, group footer, or detail section should be changed if we want each group or record in a report to start on a new page?

    A
    NewRowOrCol property

    B
    ForceNewPage property

    C
    SetNewPage property

    D
    ForceNewRow property

    Note: not sure
    1. Report
  9. Question: If a table named students has a column called Studentname storing the names of the students, what will be the correct query to display the names of the students in reverse alphabetical order?

    A
    Select Studentname from students reverse

    B
    Select Studentname from students reverse name

    C
    Select Studentname from students order by name descending

    D
    Select Studentname from students order by name Reverse

    E
    Select Studentname from students order by Studentname desc

    F
    Select desc Studentname from Students

    G
    Select Reverse Studentname from Students

    Note: not sure
    1. Report
  10. Question: What type of query do you use to modify existing records

    A
    Insert query

    B
    Delete query

    C
    Update query

    D
    Select query

    Note: not sure
    1. Report
Copyright © 2025. Powered by Intellect Software Ltd