Access Clasa A X A

10 Óntrebri

Settings
Please wait...
SQL Quizzes & Trivia

 This test is formulated to assess your knowledge on the concepts of how to use Microsoft Access  software effectively.


Questions and Answers
  • 1. 
    A database is ?
    • A. 

      A collection of file.

    • B. 

      A collection of records .

    • C. 

      A collection of data.

    • D. 

      A collection of tables.

  • 2. 
    Most database systems make it very easy to create a database via ?
    • A. 

      A visual interface

    • B. 

      A user interface

    • C. 

      Tabs

    • D. 

      Speech recognition

  • 3. 
    In database terms, a table ?
    • A. 

      Is responsible for storing data in the database

    • B. 

      Is responsible for storing data in a folder

    • C. 

      Is responsible for storing data in a report

    • D. 

      Is responsible for storing data in a query

  • 4. 
    Database tables consist of ?
    • A. 

      Rows and columns

    • B. 

      Forms and reports

    • C. 

      Lines and arrows

    • D. 

      Formulas and calculations

  • 5. 
     What enables you to create the names of each column, specify the type of data that can go into each column, as well as specifying any other restrictions you'd like to enforce?
    • A. 

      Creative view

    • B. 

      Visual view

    • C. 

      Design view

    • D. 

      Creative View

  • 6. 
    A unique identifier is a value that is  ______to each record.
    • A. 

      Ordinary

    • B. 

      Common

    • C. 

      Unique

    • D. 

      Deleted

  • 7. 
    The column that contains the unique identifier is referred to as the ?
    • A. 

      Secondary key

    • B. 

      Product Key

    • C. 

      Primary Key

    • D. 

      Delete Key

  • 8. 
      The followings are data types in Access Except  one
    • A. 

      Sort

    • B. 

      Date/time

    • C. 

      Yes/No

    • D. 

      OLE object

  • 9. 
    __________ is a field, or combination of fields, that uniquely identifies each record in a table
    • A. 

      Data type

    • B. 

      Form

    • C. 

      Relationship

    • D. 

      Primary key

  • 10. 
    Which type of field is incremented automatically?
    • A. 

      Auto Elevate

    • B. 

      AutoNumber

    • C. 

      Auto Increment

    • D. 

      Auto Value