ITE 152 FINAL - EXAMINATION COMPLETE
QUESTIONS AND DETAILED SOLUTIONS
LATEST UPDATE THIS YEAR JUST RELEASED
Question 1: A computerized database can store millions of
telephone numbers.
A. True
B. False
Answer:
True
Question 2: A field that lists customer email addresses?
A. Hyperlink
B. AutoNumber
C. Date/Time
D. Number
Answer:
Hyperlink
Question 3: Databases typically store their data in one big table.
A. True
B. False
Answer:
False
Question 4: All the pet names in a veterinarian's database are
stored in a called PetName.
A. record
, B. table
C. worksheet
D. field
Answer:
Field
Question 5: Field 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?
A. Forms
B. Queries
C. Reports
D. Tables
Answer:
Forms
Question 6: Forms Queries in access can be used
A. Both 'a' and 'b'
B. Only 'a'
C. as a source of records for forms and reports
D. to view, change and analyze data in different ways
Answer:
Both 'a' and 'b'
Question 7: What does a filter do?
A. Make more records available
B. Hide records from view
, C. Slow down processing
D. Add to the quantity of data
Answer:
Hide records from view
Question 8: A field's data type determines what kind of information
can be stored there.
A. True
B. False
Answer:
Which field could serve as the primary key for a list
Question 9: Which field could serve as the primary key for a list of
students in your school?
A. Birth date
B. Phone number
C. Full name
D. Student ID number
Answer:
Dana is creating a table that will s
Question 10: How books for sale on a bookstore's website. Which
field in the table would best serve as its primary key?
A. PageCount
B. Title
C. ProductID
D. Author
Answer:
QUESTIONS AND DETAILED SOLUTIONS
LATEST UPDATE THIS YEAR JUST RELEASED
Question 1: A computerized database can store millions of
telephone numbers.
A. True
B. False
Answer:
True
Question 2: A field that lists customer email addresses?
A. Hyperlink
B. AutoNumber
C. Date/Time
D. Number
Answer:
Hyperlink
Question 3: Databases typically store their data in one big table.
A. True
B. False
Answer:
False
Question 4: All the pet names in a veterinarian's database are
stored in a called PetName.
A. record
, B. table
C. worksheet
D. field
Answer:
Field
Question 5: Field 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?
A. Forms
B. Queries
C. Reports
D. Tables
Answer:
Forms
Question 6: Forms Queries in access can be used
A. Both 'a' and 'b'
B. Only 'a'
C. as a source of records for forms and reports
D. to view, change and analyze data in different ways
Answer:
Both 'a' and 'b'
Question 7: What does a filter do?
A. Make more records available
B. Hide records from view
, C. Slow down processing
D. Add to the quantity of data
Answer:
Hide records from view
Question 8: A field's data type determines what kind of information
can be stored there.
A. True
B. False
Answer:
Which field could serve as the primary key for a list
Question 9: Which field could serve as the primary key for a list of
students in your school?
A. Birth date
B. Phone number
C. Full name
D. Student ID number
Answer:
Dana is creating a table that will s
Question 10: How books for sale on a bookstore's website. Which
field in the table would best serve as its primary key?
A. PageCount
B. Title
C. ProductID
D. Author
Answer:
