NEW
Font size
WorksheetsG3 Final 2 MS Access Review 20/21
Total questions: 15
Worksheet time: 9mins
A row in a database.
Record
Field
Data
Table
A column in a database.
Field
Record
Table
Data
Text, Number, Boolean and Date/Time are all examples of...
Data Types
Field
Record
Table
A data type used for storing numbers with a fractional part e.g. 3.142
Date/Time
Boolean
Number
Text
A data type that can only hold 2 values e.g. Yes/No or True/False.
Boolean
Number
Text
Date/Time
What is a database?
A collection of data in tables
Something that has a list
A spreadsheet
An image
Which software program do we use to create a database
Microsoft Excel
Microsoft Word
Microsoft Access
Microsoft Publisher
Who might use a database?
School
Police
Company
All of them
In school, which data might be stored in a database?
Favourite colour
Your parents contact details
Favourite food
Your mobile phone number
What is an advantage of a database?
You can input information
Its different to Excel
It saves files
Can search through and find information quickly
Text, date, currency and number are all examples of what?
Data types
Table
Fields
Records
Which data type is used to store:
100
Number
Text
Boolean
Date/Time
Which data type is used to store:
Yes/No
Boolean
Currency
Text
Number
Which data type is used to store:
"D"
Text
Date/Time
Number
Boolean
This data type is used to store a mixture of letters and numbers and symbols.
Text
Number
Boolean
Date/Time
