ITE 152 EXAM 3 ACTUAL EXAM 2024 | ALL QUESTIONS AND CORRECT ANSWERS | ALREADY GRADED A+ | LATEST EXAM

ITE 152 EXAM 3
Study online at https://quizlet.com/_felh7j
1. Contact information for all the people taking a class at a school are stored
in a ________ called Students.
A. Record
B. Worksheet
C. Field
D. Table: D. Table
2. 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?
A. GPA
B. Major
C. Graduated
D. Employer: C. Graduated
3. What is the purpose of Expression Builder in Access?
A. To add comments
B. To duplicate a field
C. To create formulas
D. To set a limit to the size of a field: C. To create formulas
4. Databases typically store their data in one big table.
A. True
B. False: B. False
5. 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. Inventory
B. Customers
C. Vendors
D. Employees: C. Vendors
6. What does SQL stand for?
A. Stated question language
B. Structured query language
C. Status query language
D. System query lingo: B. Structured query language
7. Which of the following is LEAST likely to be a field in a Customers table?
A. PhoneNumber
B. EmploymentDate
C. LastName
D. Address: B. EmploymentDate



, ITE 152 EXAM 3
Study online at https://quizlet.com/_felh7j
8. This key uniquely identifies each record.
A. unique key
B. key record
C. primary key
D. field name: C. primary key
9. What are the different views to display a table?
A. Datasheet View
B. Design View
C. All of the above: All of the above
10. 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. Smallest to largest
D. Z to A: C. Smallest to largest
11. A field's data type determines what kind of information can be stored
there.
A. True
B. False: A. True
12. All the pet names in a veterinarian's database are stored in a _______ called
PetName.
A. record
B. worksheet
C. table
D. field: D. field
13. 1. In a record, each separate piece of data, such as a last name, a first name,
or an address, is called a _____________.
A. File
B. Table
C. Record
D. Field: D. Field
14. Databases are useful only if they are ___________.
A. Accurate
B. Big
C. Detailed
D. Expensive: A. Accurate
15. In a database, a _____________ is a unit of information about one individ-
ual or item.
A. Field


, ITE 152 EXAM 3
Study online at https://quizlet.com/_felh7j
B. File
C. Record
D. Table: A. Field
16. Which data type would be best suited to a field that lists a product's
clearance price?
A. AutoNumber
B. Number
C. Currency
D. Date/Time: C. Currency
17. 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?
A. The table has been deleted.
B. The table is sorted.
C. The table is filtered.
D. The table is missing a primary key.: C. The table is filtered.
18. Which of the following is NOT a part of a database?
A. Records
B. Fields
C. Worksheets
D. Tables: C. Worksheets
19. A computerized database can store millions of telephone numbers.
A. True
B. False: A. True
20. 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: C. A question you ask a database
21. 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. ProductID
B. Title
C. Author
D. PageCount: A. ProductID
22. Which of the following is the easiest way add data to a table.
A. report
B. form
C. query: B. form