ITE 152 Modules 9-12 Exam Questions And
Answers 100% Pass
Queries in access can be used - ANS to view, change and analyze data in different ways and
as a source of records for forms and reports
What does a filter do? - ANS Hide records from view
Databases are useful only if they are - ANS 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? - ANS ProductID
What is a query? - ANS A question you ask a database
true - ANS 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? - ANS 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 _____________. - ANS field
, ©EVERLY 2025 ALL RIGHTS RESERVED
Which of the following is NOT a part of a database? - ANS 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? - ANS graduated
true - ANS A database is an organized collection of information.
Which of the following is the easiest way add data to a table. - ANS form
In a database, a _____________ is a unit of information about one individual or item. -
ANS field
Which data type would be best suited to a field that lists a product's clearance price? -
ANS currency
What is the purpose of Expression Builder in Access? - ANS to create formulas
Which of the following is LEAST likely to be a field in a Customers table? -
ANS employmentdate
true - ANS A computerized database can store millions of telephone numbers.
In a database, each _________________ contains a collection of related data. - ANS table
What does SQL stand for? - ANS structured query language