ITE 152 Exam 3 (Modules 9, 11, & 12)
2026 Exam complete exam questions
and answers 2026
Dana is creating a table that will show books for sale on a bookstore's website. Which field in the table
would best serve as its primary key?
A) Author
B) PageCount
C) Title
D) ProjectID - CORRECT ANSWERS D) ProjectID
(T/F) A field's data type determines what kind of information can be stored there. - CORRECT ANSWERS
True
Which of the statement(s) listed below is(are) true:
Queries in Access can be used...
A) All statements listed are true when query in Access.
B) None of the statement listed are true when query in Access
C) as a source of records for forms and reports
D) to view, change and analyze data in different ways - CORRECT ANSWERS A) All
statements listed are true when query in Access.
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?
A) A to Z
,B) Largest to smallest
C) Z to A
D) Smallest to largest - CORRECT ANSWERS D) Smallest to largest
(T/F) A database is an organized collection of information. - CORRECT ANSWERS True
What are the columns in a Microsoft Access table called?
A) Records
B) Rows
C) Columns
D) Fields - CORRECT ANSWERS D) Fields
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?
A) Vendors
B) Customers
C) Inventory
D) Employees - CORRECT ANSWERS A) Vendors
What is a query?
A) A question you ask a record
B) A question you ask a field
C) A question you ask a database
, D) A question you ask a table - CORRECT ANSWERS C) A question you ask a database
Contact information for all the people taking a class at a school are stored in a ________ called Students.
A) field
B) record
C) worksheet
D) table - CORRECT ANSWERS D) table
What are the different views to display a table?
A) All of the above
B) Design View
C) Datasheet View - CORRECT ANSWERS A) All of the above
In a database, each _________________ contains a collection of related data.
A) None of the above
B) Field
C) Record
D) Table - CORRECT ANSWERS D) Table
Which data type would be best suited to a field that lists a product's clearance price?
A) Number
2026 Exam complete exam questions
and answers 2026
Dana is creating a table that will show books for sale on a bookstore's website. Which field in the table
would best serve as its primary key?
A) Author
B) PageCount
C) Title
D) ProjectID - CORRECT ANSWERS D) ProjectID
(T/F) A field's data type determines what kind of information can be stored there. - CORRECT ANSWERS
True
Which of the statement(s) listed below is(are) true:
Queries in Access can be used...
A) All statements listed are true when query in Access.
B) None of the statement listed are true when query in Access
C) as a source of records for forms and reports
D) to view, change and analyze data in different ways - CORRECT ANSWERS A) All
statements listed are true when query in Access.
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?
A) A to Z
,B) Largest to smallest
C) Z to A
D) Smallest to largest - CORRECT ANSWERS D) Smallest to largest
(T/F) A database is an organized collection of information. - CORRECT ANSWERS True
What are the columns in a Microsoft Access table called?
A) Records
B) Rows
C) Columns
D) Fields - CORRECT ANSWERS D) Fields
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?
A) Vendors
B) Customers
C) Inventory
D) Employees - CORRECT ANSWERS A) Vendors
What is a query?
A) A question you ask a record
B) A question you ask a field
C) A question you ask a database
, D) A question you ask a table - CORRECT ANSWERS C) A question you ask a database
Contact information for all the people taking a class at a school are stored in a ________ called Students.
A) field
B) record
C) worksheet
D) table - CORRECT ANSWERS D) table
What are the different views to display a table?
A) All of the above
B) Design View
C) Datasheet View - CORRECT ANSWERS A) All of the above
In a database, each _________________ contains a collection of related data.
A) None of the above
B) Field
C) Record
D) Table - CORRECT ANSWERS D) Table
Which data type would be best suited to a field that lists a product's clearance price?
A) Number
