ECDL Module 5 Tables Quiz

11 Questions | Total Attempts: 9264

SettingsSettingsSettings
ECDL Module 5 Tables Quiz

Take this quiz to check your understanding of tables within databases. A member of each team will be nominated to answer. If they get it right on their own then the team gets 2 points. If the person nominated confers with their team and get it right they get 1 point. If anyone other than the nominated person shouts out the answer they will lose a team point. Good Luck


Questions and Answers
  • 1. 
    What is the file extension for a Microsoft Access 2007 database
    • A. 

      .ppt(x)

    • B. 

      .doc(x)

    • C. 

      .accdb(x)

    • D. 

      .xls(x)

  • 2. 
    A Database is...
    • A. 

      A set of information related to another application

    • B. 

      A table of records with no relevance

    • C. 

      A set of information ( names, addresses) with no structure

    • D. 

      A collection of information about a particular subject

  • 3. 
    Tables have two views. They are Datasheet view and  ................     view.
  • 4. 
    A ........... is a collection of information that stores all of the data about one person or one thing. For instance a ........... in student table would contain all of the data about one student i.e. their name, address, home phone number, d.o.b. medical history. Each student would have a ............
  • 5. 
    Each item within a record is called a ...... In the example of a student table, a......... would be first name or surname or student number.
  • 6. 
    Which one of the following is not part of a database
    • A. 

      A record

    • B. 

      A chart

    • C. 

      A field

    • D. 

      A table

  • 7. 
    Which of the following is not true. In design view you can...
    • A. 

      Add records to a table

    • B. 

      Add a Field Name

    • C. 

      Select a data type

    • D. 

      Increase the field size

  • 8. 
    A primary key allows a user to
    • A. 

      Lock a table

    • B. 

      Password a database

    • C. 

      Assign each record a unique field

    • D. 

      Create a query

  • 9. 
    Validation rules can be applied to fields. They ................. what users can enter in a table field.
  • 10. 
    Changing the number of characters in a field from 50 to 20 will..
    • A. 

      Allow up to 20 characters to be entered in a field

    • B. 

      Allow up to 20 words to be entered in a field

    • C. 

      Decrease the font size from 50 to 20

    • D. 

      Only allow numbers up to 20 to be entered in the field

  • 11. 
    When changing table view Microsoft Access will automatically ask you if you want to save the table if...
    • A. 

      You have assigned a Primary Key

    • B. 

      You switch from data view to design view

    • C. 

      You have not saved the table for 5 minutes

    • D. 

      You switch from design view to dataview

Related Topics
Back to Top Back to top