WorksheetsData Types + Access
Total questions: 60
Worksheet time: 37mins
What is a field?
The whole table of information
A row with information of one person
A column with a piece of information
Which icon is Microsoft Access?
How many fields are there?
7
8
9
13
How many records are there in this database table?
6
12
7
5
What is a RECORD?*
The place for information
A report of a database
A collection of files
A set of data about one person or one thing
MS Access is the software to create ...?
Document
Spreadsheet
Presentation
Database table
To create database tables, we use
MS Word
MS Excel
MS PowerPoint
MS Access
This is Microsoft (a) ?
How many fields does this table have?
9
3
4
8
How many records does this table have?
9
3
4
8
Which view is this??
Design view
Datasheet view
Print view
Normal view
What is a database?
To store data
To create presentations
To edit documents
To create spreadsheets
Which is a data type in MS Access?
Text
Image
Video
Audio
Which is a database app?
MS Outlook
MS Word
MS Access
MS Paint
What do we call each row in a database table?
What is Jack’s favorite color?
(a)
How many fields?
(a)
How many records?
(a)
Which data type is used to store this data:
"100"
(a)
Which data type is used to store:
"Database"
(a)
This data type stores letters, numbers, and symbols.
(a)
What data type for "Height"?
(a)
What data type for "Email address"?
(a)
Which data type to store "Age"?
(a)
Which data type to store "Password"?
(a)
What data type for "First Name"?
text
date/time
currency
number
What data type to store if someone has a pet or not?
Currency
Boolean
Text
Number
What type of data to store the country?
(a)
Which data type shows True/False or Yes/No?
(a)
What is this datatype?
Currency
AutoNumber
Yes/No
Text
What is this datatype?
Number
Currency
Boolean
Text
What is this data type?
Date/Time
Boolean
Number
Text
Which data type is it?
Text
Boolean
Number
Currency
Which data type is it?
Text
Number
Boolean
Currency
Which data type is it?
Text
Number
Boolean
Currency
What data type is used to store True or False values?
Number
Text
Date/Time
Boolean
Which data type is "Student ID"?
Text
AutoNumber
Number
Which of these is an example of the Currency data type?
5th March 2012
10
Which data type for "Date of birth"?
(a)
What is a database?
What is a data?
Information or fact
A document
A spreadsheet
A presentation
What is a field?
a column in a database table
a row in a database table
There are (a) fields in this table.
How many fields are there in this table?
(a)
What is this?
Field
Record
What is the name of this field?
(a)
In a Database, each column is called a _____________
Field
Record
This table has ___________ fields.
2
4
5
6
What is a database?
something that store data
something that sends data
In a database table, a column is known as a...
Record
Field
Row
Why do you use a database?
To store and organize data
To send emails
To create documents
To browse the internet
All shopping websites need to have a database.
Why is a database important?
Because it’s fun to say “database”
It helps to organize and store data
To keep track of unicorns
To play hide-and-seek
What is the main purpose of a database?
To store data
To perform mathematical calculations.
To create designs for websites.
In a student database, which of the following is a field?
(2 correct answers)
A bookshelf
Student ID
Student Name
The school playground
Which field would you find in a Library Database?
Book Title
Car Color
Shoe Size
Favorite Food
A hospital database stores about patient details. Which field should NOT be in?
Contact Number
Favorite Movie
A school database should include students' favorite cartoon characters.
Yes
No
The "Age" field should have in a student database.
Yes
No
Which is a field in a Supermarket Item Database?
Product Name
