Database Concepts 1

10 Questions | Total Attempts: 4788

SettingsSettingsSettings
Please wait...
Database Concepts 1

Tests concepts of database and knowledge of MS Access


Related Topics
Questions and Answers
  • 1. 
    A single set of related data values is referred to as
    • A. 

      Data value

    • B. 

      Record

    • C. 

      Field

    • D. 

      Table

  • 2. 
    What is used to uniquely identify each record in a table?
    • A. 

      Foreign key

    • B. 

      Field

    • C. 

      Datatype

    • D. 

      Primary key

  • 3. 
    ___________ data type stores date and time values between the years 100 through 9999.
    • A. 

      Date

    • B. 

      Time

    • C. 

      Date/Time

    • D. 

      Memo

  • 4. 
    The ______________ of a table is used to modify the design of a table, like modifying the name of a field or changing the data type of a field.
    • A. 

      Datasheet View

    • B. 

      Design View

    • C. 

      Table View

    • D. 

      Wizard View

  • 5. 
    You can select multiple fields of a table in design view by using the ________ key.
    • A. 

      Alt

    • B. 

      Spacebar

    • C. 

      Shift

    • D. 

      Tab

    • E. 

      Ctrl

  • 6. 
    What does x represent in the figure?
    • A. 

      Row Selector

    • B. 

      Row Holder

    • C. 

      Row Field

    • D. 

      Row Data

  • 7. 
    What validation rule should be entered for a StudentID which should start with the letter "S"?
    • A. 

      Like 'S*'

    • B. 

      Like S*

    • C. 

      Like "S"

    • D. 

      Like "S*"

  • 8. 
    In the datasheet view of the Student table, the StudentAddress field needs to be displayed as Address. Which field property can be used to achieve this?
    • A. 

      Caption

    • B. 

      Validation Text

    • C. 

      Required

    • D. 

      Validation Rule

    • E. 

      Default

  • 9. 
    • A. 

      True

    • B. 

      False

  • 10. 
    What is the purpose of forms?
    • A. 

      It is used to store data

    • B. 

      It provides a user-friendly interface for entering data into tables

    • C. 

      It is used to retrieve data from tables

    • D. 

      It is used to print or preview data in different formats