Quiz
ICT Definitions
Dieses Quiz hat ein Zeitlimit und öffnet sich deshalb im gewohnten Player.
Fragen in diesem Quiz (7)
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].
- ADatabase
- BComputer
- CStructured
- DUnstructered
- Ecollection of related data
- FCollection of data
- Gheld together
- Htogether
- Iorganised or logical
- Jrandom
- Kcomputerized or paper-based
- Lcardboard or on paper
- Measy to retrieve and maintain the data
- Nharder to obtain and handle the data
2A record is one piece of data about a person or thing.
- ARichtig
- BFalsch
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- AAuto Number
- BText
- CCurrency
- DDate/Time
- EBoolean
- FPrimary Key
- Gonly
4Which of these best describe a relationship?
- ALinks that are made between two tables
- BLinks that are made in the same table
- CLinks that are made between two pieces of data
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- AOne
- BMany
- CMany
- DTwo
- EMany
- FTwo
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]- AExternal Data
- BExcel
- CExcel
- DOpen
- EOK
- FTick
- Gnext
- Hnext
- IPrimary Key
- JPress
- KName
- LFinish
- MClose
7How do you change the date format in Access?
- 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 - 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
- AOpen Database
Informationen
- Beschreibung
- Quiz am ICT Definitions, erstellt von Alex Cheshire am 13/09/2015.
- Autor
- Alex Cheshire
- Sprache
- English
- Aufrufe
- 0
- Schlagwörter
- Bewertung
- Noch keine Bewertungen Bewerte dieses Quiz