ITE 152 MODULES 9-12 QUIZ QUESTIONS
WITH ALL CORRECT & VERIFIED ANSWERS
Queries in access can be used Correct answer-to view, change and analyze data in different ways
and as a source of records for forms and reports
What does a filter do? Correct answer-Hide records from view
Databases are useful only if they are Correct answer-accurate
Dana is creating a table that will show books for sale on a bookstores website. Which field in the
table would best serve as its primary key? Correct answer-ProductID
What is a query? Correct answer-A question you ask a database
true Correct answer-A field's data type determines what kind of information can be stored there.
Which field could serve as the primary key for a list of students in your school? Correct answer-
student ID number
In a record, each separate piece of data, such as a last name, a first name, or an address, is called a
_____________. Correct answer-field
Which of the following is NOT a part of a database? Correct answer-worksheets
Xavier is designing a Students table that will continue to track students even after they have
completed their programs. Which of the following fields would work best with the Yes/No data type?
Correct answer-graduated
true Correct answer-A database is an organized collection of information.
Which of the following is the easiest way add data to a table. Correct answer-form
In a database, a _____________ is a unit of information about one individual or item. Correct
answer-field
Which data type would be best suited to a field that lists a product's clearance price? Correct
answer-currency
What is the purpose of Expression Builder in Access? Correct answer-to create formulas
Which of the following is LEAST likely to be a field in a Customers table? Correct answer-
employmentdate
true Correct answer-A computerized database can store millions of telephone numbers.
In a database, each _________________ contains a collection of related data. Correct answer-
table
What does SQL stand for? Correct answer-structured query language
, Kian needs to sort a list of patients by birthdate to show the oldest patients first. What sort order on
the birthdate field will give him this result? Correct answer-smallest to largest
Sawyer is looking at a table of students in his class, but it seems like the list is way too short. What is
the most likely problem? Correct answer-the table is filtered
Ibraheem works for a music store. Which of the following tables will give him the company contact
information he needs to place a custom order for a guitar? Correct answer-vendors
This key uniquely identifies each record. Correct answer-primary key
What are the columns in a Microsoft Access table called? Correct answer-fields
Contact information for all the people taking a class at a school are stored in a ________ called
Students. Correct answer-table
Malisa is designing a database for a doctor's office where receptionists, office managers, and other
office staff will need to manage patient data. Which database object should Malisa create to make it
easy for these non-technical users to add patient records? Correct answer-forms
Which of the following is a way to sort data? Correct answer-numerically, alphabetically, and
chronologically
true Correct answer-Databases typically store their data in one big table.
All the pet names in a veterinarian's database are stored in a _______ called PetName. Correct
answer-field
What are the different views to display a table? Correct answer-design view and datasheet view
Siobhan has recently opened a Facebook account and as a new user, is posting frequently and
accepting many friend requests. You see a post about an upcoming trip and notice that her profile is
open to the public. What can you tell Siobhan to help her use social networking safely? Correct
answer-be cautious about what info she posts
How can an attacker execute malware through a script? Correct answer-A script can run a series of
instructions to download and run malware.
false Correct answer-Social-networking sites have a history of providing tight security and giving
users a clear understanding of how security features work.
Which of the following statements about browser security settings is false? Correct answer-You
must keep your accumulated web history as long as you use the browser.
What is a digital certificate? Correct answer-Technology used to verify a user's identity
false Correct answer-A Trojan is a malicious program that uses a computer network to replicate.
false Correct answer-Your Facebook profile is private so there is no need to worry about your boss
ever seeing your posts such as your Spring Break pictures.
WITH ALL CORRECT & VERIFIED ANSWERS
Queries in access can be used Correct answer-to view, change and analyze data in different ways
and as a source of records for forms and reports
What does a filter do? Correct answer-Hide records from view
Databases are useful only if they are Correct answer-accurate
Dana is creating a table that will show books for sale on a bookstores website. Which field in the
table would best serve as its primary key? Correct answer-ProductID
What is a query? Correct answer-A question you ask a database
true Correct answer-A field's data type determines what kind of information can be stored there.
Which field could serve as the primary key for a list of students in your school? Correct answer-
student ID number
In a record, each separate piece of data, such as a last name, a first name, or an address, is called a
_____________. Correct answer-field
Which of the following is NOT a part of a database? Correct answer-worksheets
Xavier is designing a Students table that will continue to track students even after they have
completed their programs. Which of the following fields would work best with the Yes/No data type?
Correct answer-graduated
true Correct answer-A database is an organized collection of information.
Which of the following is the easiest way add data to a table. Correct answer-form
In a database, a _____________ is a unit of information about one individual or item. Correct
answer-field
Which data type would be best suited to a field that lists a product's clearance price? Correct
answer-currency
What is the purpose of Expression Builder in Access? Correct answer-to create formulas
Which of the following is LEAST likely to be a field in a Customers table? Correct answer-
employmentdate
true Correct answer-A computerized database can store millions of telephone numbers.
In a database, each _________________ contains a collection of related data. Correct answer-
table
What does SQL stand for? Correct answer-structured query language
, Kian needs to sort a list of patients by birthdate to show the oldest patients first. What sort order on
the birthdate field will give him this result? Correct answer-smallest to largest
Sawyer is looking at a table of students in his class, but it seems like the list is way too short. What is
the most likely problem? Correct answer-the table is filtered
Ibraheem works for a music store. Which of the following tables will give him the company contact
information he needs to place a custom order for a guitar? Correct answer-vendors
This key uniquely identifies each record. Correct answer-primary key
What are the columns in a Microsoft Access table called? Correct answer-fields
Contact information for all the people taking a class at a school are stored in a ________ called
Students. Correct answer-table
Malisa is designing a database for a doctor's office where receptionists, office managers, and other
office staff will need to manage patient data. Which database object should Malisa create to make it
easy for these non-technical users to add patient records? Correct answer-forms
Which of the following is a way to sort data? Correct answer-numerically, alphabetically, and
chronologically
true Correct answer-Databases typically store their data in one big table.
All the pet names in a veterinarian's database are stored in a _______ called PetName. Correct
answer-field
What are the different views to display a table? Correct answer-design view and datasheet view
Siobhan has recently opened a Facebook account and as a new user, is posting frequently and
accepting many friend requests. You see a post about an upcoming trip and notice that her profile is
open to the public. What can you tell Siobhan to help her use social networking safely? Correct
answer-be cautious about what info she posts
How can an attacker execute malware through a script? Correct answer-A script can run a series of
instructions to download and run malware.
false Correct answer-Social-networking sites have a history of providing tight security and giving
users a clear understanding of how security features work.
Which of the following statements about browser security settings is false? Correct answer-You
must keep your accumulated web history as long as you use the browser.
What is a digital certificate? Correct answer-Technology used to verify a user's identity
false Correct answer-A Trojan is a malicious program that uses a computer network to replicate.
false Correct answer-Your Facebook profile is private so there is no need to worry about your boss
ever seeing your posts such as your Spring Break pictures.
