JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.
Microsoft Access Database Intro
Sign in to Google
to save your progress.
Learn more
* Indicates required question
Enter your name.
*
Your answer
Exercise 1: Look at the
Design View
of the
Fruits Table
.
Identify the
two
numeric fields
.
*
2 points
ID
Name
ImageName
PointValue
Required
Why should the fields you identified be numeric?
*
2 points
A numeric type is easier to remember.
A numeric type does not take up too much storage space.
A numeric type is simple to validate.
A numeric type enables us to sort data or make calculations quickly.
Required
Identify
one
textual field
.
*
1 point
ID
DateAdded
Name
PointValue
The field you identified is be stored as text because...
*
1 point
the data consists of alphanumeric values meaning letters and numbers.
the data represents a monetary value which needs a "$" sign in front.
we are not sure what the data is meant to look like, so better be safe.
it is a default data type and we will only change if we need to.
Identify the
primary key
of the Fruits Table.
*
1 point
Your answer
Why does a table need a primary key?
*
1 point
To mark the most important field in the table.
It acts like a password to keep the record secure.
To make a record unique in a table.
It is a rule that must be obeyed.
Exercise 2:
Open
the
Users Table
.
Identify the
data type
of the field
ID
.
*
1 point
AutoNumber
Number
Short Text
Yes/No
Identify the
data type
of the field
OptionMusic
.
*
1 point
AutoNumber
Number
Short Text
Yes/No
Identify the
data type
of the field
Username
.
*
1 point
AutoNumber
Number
Short Text
Yes/No
Which
two
fields could act as a
primary key
?
*
2 points
ID
FullName
Username
OptionMusic
OptionDarkMode
Required
Exercise 3:
Open
the
ScoreBoardWeeks25Mar2024 Query
.
What is a
database query
?
*
1 point
A type of error.
A "question" about the data that we are storing.
A programming language.
A data type for a field.
On which
table
are we running the query?
*
1 point
Fruits
PlaySessions
Users
All of the above
What is the purpose of this query?
*
2 points
It "asks" which fruit rewards the most points when clicked on.
To answer, it extracts the FruitName from the Fruits Table and sorts them by PointsValue in descending order.
We extract the UserID
It "asks" how the users' score rank within a particular week.
To answer, it extracts the UserID and Score from the PlaySessions Table and sorts them by Score in descending order.
Required
Which of the following
keywords
is
not
in the
SQL View
?
*
1 point
SELECT
FROM
WHERE
SORT BY
Switch to
Design View
and identify what we have to change to
extract
records
that are
between
the
1st of April 2024
and
7th April 2024
.
*
1 point
We need to retrieve the results from another table.
We need to change the criteria of the PlayedOn field.
We need to change the criteria of the Score field.
We need to untick the show checkbox for the UserID field.
Which query can we execute on our current data?
*
1 point
We can query whether a particular user has unlocked a particular achievement.
We can query whether user is part of a particular team.
We can query whether a user has reached a score of 650 or greater.
We can query what special boosts are linked to a particular fruit.
Submit
Page 1 of 1
Clear form
Never submit passwords through Google Forms.
This content is neither created nor endorsed by Google. -
Terms of Service
-
Privacy Policy
Does this form look suspicious?
Report
Forms