NEW
Font size
WorksheetsG5 Final 2 MS Access Review 20/21
Total questions: 20
Worksheet time: 10mins
Which is correct for a record?
All the information about one person or item
Used to print information from the database
A method of searching the database for specific information
A place where all records are stored
Which software do you use to make database?
Microsoft Word
Microsoft Excel
Microsoft Publisher
Microsoft Access
A column in a database.
Field
Record
Table
Validation
What is a database?
A software used to store information
Something that has a list
A spreadsheet
An image
Who might use a database?
School
Police
Employer
All of the above
In school, what kind of 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
Short text, date, long text and number are all examples of what?
Data types
Headings
Fields
Records
True or false - it is important to check our literacy (spelling, capital letters, etc) when inputting data into a database
True
False
The data type you should use for a country's name:
Text
Number
Date/Time
Currency
To store the quantity of items in a shop the data type would be
Text
Date/Time
Number
Currency
You want to store the price of the food at your International Day sale, you will use
Number
Price
Currency
Expenses
To store the date of sports events at Jumeirah College, the secretary will use a field of type
Text
Number
Date/Time
Currency
You need to store whether a superhero is reliable or not, you use a field of type
Boolean
Text
Number
Date/Time
A new table contains: first name, surname, date of birth, address, paid or not. List the data types to be used
Number, Text, Date/Time, Text, Yes/No
Text, Currency, Date/Time, Text, Yes/No
Text, Text, Date/Time, Number, Yes/No
Text, Text, Date/Time, Text, Yes/No
The advantage of a paper-based database is that
It's easy to change data
It's easy to travel
It requires great skill to set up and use
It's very organized
In a database, data is stored in...
tables
forms
reports
queries
