age 1 of 38
ITE 152 EXAM 3 STUDY GUIDE QUESTIONS AND
CORRECT ANSWERS | ALREADY GRADED A+ |
LATEST
Which field could serve as the primary key for a list of students
in your school? ......ANSWER........Student ID number
A field's data type determines what kind of information can be
stored there. ......ANSWER........True
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? ......ANSWER........ProductID
All the pet names in a veterinarian's database are stored in a
_______ called PetName. ......ANSWER........Field
Which of the following is a way to sort data?
......ANSWER........All of the above (Alphabetically, Numerically,
Chronologically)
,age 2 of 38
What does SQL stand for? ......ANSWER........Structured Query
Language
What is a query? ......ANSWER........A question you ask a
database
What are the columns in a Microsoft Access table called?
......ANSWER........Fields
In a record, each separate piece of data, such as a last name, a
first name, or an address, is called a _____________.
......ANSWER........Field
Which data type would be best suited to a field that lists a
product's clearance price? ......ANSWER........Currency
A query lets you speed up the browsing process by finding
information that matches specifically to your criteria.
......ANSWER........True
,age 3 of 38
What are the different views to display a table?
......ANSWER........All of the above (Pivot Table & Pivot Chart
View, Datasheet View, Design View)
Databases typically store their data in one big table.
......ANSWER........False
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? ......ANSWER........Smallest to largest
In a database, each _________________ contains a collection
of related data. ......ANSWER........Table (?)
A database is an organized collection of information.
......ANSWER........True
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? ......ANSWER........Vendors
, age 4 of 38
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? ......ANSWER........Graduated
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?
......ANSWER........The table is filtered.
One disadvantage of computerized databases is that they limit
your ability to arrange information. ......ANSWER........False
Queries in access can be used ......ANSWER........Both 'a' and 'b'
(as a source of records for forms and reports, to view, change
and analyze data in different ways)
A relationship is created between how many tables?
......ANSWER........Two
What does a filter do? ......ANSWER........Hide records from view
ITE 152 EXAM 3 STUDY GUIDE QUESTIONS AND
CORRECT ANSWERS | ALREADY GRADED A+ |
LATEST
Which field could serve as the primary key for a list of students
in your school? ......ANSWER........Student ID number
A field's data type determines what kind of information can be
stored there. ......ANSWER........True
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? ......ANSWER........ProductID
All the pet names in a veterinarian's database are stored in a
_______ called PetName. ......ANSWER........Field
Which of the following is a way to sort data?
......ANSWER........All of the above (Alphabetically, Numerically,
Chronologically)
,age 2 of 38
What does SQL stand for? ......ANSWER........Structured Query
Language
What is a query? ......ANSWER........A question you ask a
database
What are the columns in a Microsoft Access table called?
......ANSWER........Fields
In a record, each separate piece of data, such as a last name, a
first name, or an address, is called a _____________.
......ANSWER........Field
Which data type would be best suited to a field that lists a
product's clearance price? ......ANSWER........Currency
A query lets you speed up the browsing process by finding
information that matches specifically to your criteria.
......ANSWER........True
,age 3 of 38
What are the different views to display a table?
......ANSWER........All of the above (Pivot Table & Pivot Chart
View, Datasheet View, Design View)
Databases typically store their data in one big table.
......ANSWER........False
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? ......ANSWER........Smallest to largest
In a database, each _________________ contains a collection
of related data. ......ANSWER........Table (?)
A database is an organized collection of information.
......ANSWER........True
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? ......ANSWER........Vendors
, age 4 of 38
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? ......ANSWER........Graduated
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?
......ANSWER........The table is filtered.
One disadvantage of computerized databases is that they limit
your ability to arrange information. ......ANSWER........False
Queries in access can be used ......ANSWER........Both 'a' and 'b'
(as a source of records for forms and reports, to view, change
and analyze data in different ways)
A relationship is created between how many tables?
......ANSWER........Two
What does a filter do? ......ANSWER........Hide records from view
