GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

ICT Definitions

Alex Cheshire 7 questions

Take the quiz

This quiz has a time limit, so it opens in the usual player.

Questions in this quiz (7)

  1. 1A [blank_start]Database[blank_end] is a [blank_start]Structured[blank_end] collection of information. A Database is a [blank_start]collection of related data[blank_end] or information which is [blank_start]held together[blank_end] in an [blank_start]organised or logical[blank_end] way. Either [blank_start]computerized or paper-based[blank_end]. This makes it [blank_start]easy to retrieve and maintain the data[blank_end].
    1. ADatabase
    2. BComputer
    3. CStructured
    4. DUnstructered
    5. Ecollection of related data
    6. FCollection of data
    7. Gheld together
    8. Htogether
    9. Iorganised or logical
    10. Jrandom
    11. Kcomputerized or paper-based
    12. Lcardboard or on paper
    13. Measy to retrieve and maintain the data
    14. Nharder to obtain and handle the data
  2. 2A record is one piece of data about a person or thing.
    1. ATrue
    2. BFalse
  3. 3What are each of these describing?
    [blank_start]Auto Number[blank_end]- Automatically assigns the next available number
    [blank_start]Text[blank_end]- Allows letters, special characters and numbers
    [blank_start]Currency[blank_end]- Allows only numbers but formats them to 2 d.p. and adds a symbol.
    [blank_start]Date/Time[blank_end]- Allows [blank_start]on[blank_end] number but formats them to dd/mm/yyyy
    [blank_start]Boolean[blank_end]- Only two possible values Yes/No
    [blank_start]Primary Key[blank_end]- Uniquely identifies a record
    1. AAuto Number
    2. BText
    3. CCurrency
    4. DDate/Time
    5. EBoolean
    6. FPrimary Key
    7. Gonly
  4. 4Which of these best describe a relationship?
    1. ALinks that are made between two tables
    2. BLinks that are made in the same table
    3. CLinks that are made between two pieces of data
  5. 5Complete the names of the three types of relationship.

    [blank_start]One[blank_end]-to-One
    One-to-[blank_start]Many[blank_end]
    [blank_start]Many[blank_end]-to-Many
    1. AOne
    2. BMany
    3. CMany
    4. DTwo
    5. EMany
    6. FTwo
  6. 6Complete the following text about importing a table into Access.

    Click on [blank_start]External Data[blank_end]
    Click on [blank_start]Excel[blank_end]
    Click on browse and find the [blank_start]Excel[blank_end] File
    Highlight the file and press [blank_start]Open[blank_end]
    Select [blank_start]OK[blank_end]
    [blank_start]Tick[blank_end] 'First row contains Column Headings'
    Press [blank_start]next[blank_end]
    Press [blank_start]next[blank_end] again
    Select 'Choose my own [blank_start]Primary Key[blank_end]'
    [blank_start]Press[blank_end] Next
    [blank_start]Name[blank_end] your table appropriately
    Press [blank_start]Finish[blank_end]
    Press [blank_start]Close[blank_end]

    1. AExternal Data
    2. BExcel
    3. CExcel
    4. DOpen
    5. EOK
    6. FTick
    7. Gnext
    8. Hnext
    9. IPrimary Key
    10. JPress
    11. KName
    12. LFinish
    13. MClose
  7. 7How do you change the date format in Access?
    1. AOpen Database
      Go to design view
      Click on field name with date data type
      Go down to field properties and click format
      Click on the drop down arrow and select Medium Date
      Repeat
      Save table data
    2. BOpen Database
      Go to grid view
      Click on the date you want to change.
      Right-click and press Change format
      Choose Medium Date
      Repeat
      Save Table data

Information

Description
Quiz on ICT Definitions, created by Alex Cheshire on 13/09/2015.
Language
English
Views
0
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?