ite exam 3 152
1. In a record, each separate piece Field
of data, such as a last name,
a first name, or an address, is
called a .
2. What does SQL stand for? Structured query language
3. A database is an organized col- True
lection of information.
4. Kian needs to sort a list of pa- Smallest to largest
tients by birthdate to show the
oldest patients first. What sort
order on the birthdate field will
give him this result?
5. In a database, each Table
contains a col-
lection of related data.
6. A field's data type determines True
what kind of information can be
stored there.
7. Sawyer is looking at a table of The table is filtered.
students in his class, but it seems
like the list is way too short. What
is the most likely problem?
8. What are the columns in a Mi- Fields
crosoft Access table called?
9. Graduated
, ite exam 3 152
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?
10. Databases typically store their False
data in one big table.
11. Which field could serve as the Student ID number
primary key for a list of students
in your school?
12. Which of the following is the eas- form
iest way add data to a table.
13. Dana is creating a table that will ProductID
show books for sale on a book-
store's website. Which field in
the table would best serve as its
primary key?
14. Contact information for all the table
people taking a class at a school
are stored in a called Stu-
dents.
15. Which of the following is LEAST EmploymentDate
likely to be a field in a Customers
table?
, ite exam 3 152
16. A computerized database can True
store millions of telephone num-
bers.
17. Which of the following is a way to All of the above
sort data?
18. Ibraheem works for a music Vendors
store. Which of the following ta-
bles will give him the company
contact information he needs to
place a custom order for a gui-
tar?
19. Databases are useful only if they Accurate
are .
20. This key uniquely identifies each primary key
record.
21. Which data type would be best Currency
suited to a field that lists a prod-
uct's clearance price?
22. What are the different views to All of the above
display a table?
23. What is a query? A question you ask a database
24. Which of the statement(s) listed All statements listed are true when query in Access.
below is(are) true:
Queries in Access can be used ...
25. What does a filter do? Hide records from view
1. In a record, each separate piece Field
of data, such as a last name,
a first name, or an address, is
called a .
2. What does SQL stand for? Structured query language
3. A database is an organized col- True
lection of information.
4. Kian needs to sort a list of pa- Smallest to largest
tients by birthdate to show the
oldest patients first. What sort
order on the birthdate field will
give him this result?
5. In a database, each Table
contains a col-
lection of related data.
6. A field's data type determines True
what kind of information can be
stored there.
7. Sawyer is looking at a table of The table is filtered.
students in his class, but it seems
like the list is way too short. What
is the most likely problem?
8. What are the columns in a Mi- Fields
crosoft Access table called?
9. Graduated
, ite exam 3 152
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?
10. Databases typically store their False
data in one big table.
11. Which field could serve as the Student ID number
primary key for a list of students
in your school?
12. Which of the following is the eas- form
iest way add data to a table.
13. Dana is creating a table that will ProductID
show books for sale on a book-
store's website. Which field in
the table would best serve as its
primary key?
14. Contact information for all the table
people taking a class at a school
are stored in a called Stu-
dents.
15. Which of the following is LEAST EmploymentDate
likely to be a field in a Customers
table?
, ite exam 3 152
16. A computerized database can True
store millions of telephone num-
bers.
17. Which of the following is a way to All of the above
sort data?
18. Ibraheem works for a music Vendors
store. Which of the following ta-
bles will give him the company
contact information he needs to
place a custom order for a gui-
tar?
19. Databases are useful only if they Accurate
are .
20. This key uniquely identifies each primary key
record.
21. Which data type would be best Currency
suited to a field that lists a prod-
uct's clearance price?
22. What are the different views to All of the above
display a table?
23. What is a query? A question you ask a database
24. Which of the statement(s) listed All statements listed are true when query in Access.
below is(are) true:
Queries in Access can be used ...
25. What does a filter do? Hide records from view
