EXPLORED ITE EXAM REVISION ok ok ok
QUESTIONSAND ANSWERS ok ok
A computerized database can store millions of telephone numbers. t
ok ok ok ok ok ok ok ok ok
rue or false - CORRECT ANSWER -true
ok ok ok ok ok ok
A database is an organized collection of information. tr
ok ok ok ok ok ok ok ok
ue or false - CORRECT ANSWER -true
ok ok ok ok ok ok
Sawyer is looking at a table of students in his class, but it seems like the list is way too short. What is th
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
e most likely problem?
ok ok ok
The table is missing a primary key. Th
ok ok ok ok ok ok ok
e table is sorted.
ok ok ok
The table is filtered.
ok ok ok
The table has been deleted. - CORRECT ANSWER -The table is filtered.
ok ok ok ok ok ok ok ok ok ok ok
Which of the following is LEAST likely to be a field in a Customers table? Addre
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
ss
LastName Employ ok
mentDate
PhoneNumber - CORRECT ANSWER -EmploymentDate ok ok ok ok
Queries in access can be used ok ok ok ok ok
as a source of records for forms and reports
ok ok ok ok ok ok ok ok
to view, change and analyze data in different ways
ok ok ok ok ok ok ok ok
, Both 'a' and 'b' ok ok ok
Only 'a' - CORRECT ANSWER -Both 'a' and 'b'
ok ok ok ok ok ok ok ok
Kian needs to sort a list of patients by birthdate to show the oldest patients first. What sort order on th
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
e birthdate field will give him this result?
ok ok ok ok ok ok ok
Z to A
ok ok
Smallest to largest ok ok o
A to Z
k ok ok
Largest to smallest - CORRECT ANSWER -Smallest to largest
ok ok ok ok ok ok ok ok
Which data type would be best suited to a field that lists customer email addresses?
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
Number
Date/Time Hyperli ok
nk
AutoNumber - CORRECT ANSWER -Hyperlink ok ok ok ok
A field's data type determines what kind of information can be stored there. tr
ok ok ok ok ok ok ok ok ok ok ok ok ok
ue or false - CORRECT ANSWER -true
ok ok ok ok ok ok
What are the different views to display a table? Piv
ok ok ok ok ok ok ok ok ok
ot Table & Pivot Chart View
ok ok ok ok ok
All of the above Da
ok ok ok ok
tasheet View ok
Design View - CORRECT ANSWER -All of the above
ok ok ok ok ok ok ok ok
What does SQL stand for? ok ok ok ok
QUESTIONSAND ANSWERS ok ok
A computerized database can store millions of telephone numbers. t
ok ok ok ok ok ok ok ok ok
rue or false - CORRECT ANSWER -true
ok ok ok ok ok ok
A database is an organized collection of information. tr
ok ok ok ok ok ok ok ok
ue or false - CORRECT ANSWER -true
ok ok ok ok ok ok
Sawyer is looking at a table of students in his class, but it seems like the list is way too short. What is th
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
e most likely problem?
ok ok ok
The table is missing a primary key. Th
ok ok ok ok ok ok ok
e table is sorted.
ok ok ok
The table is filtered.
ok ok ok
The table has been deleted. - CORRECT ANSWER -The table is filtered.
ok ok ok ok ok ok ok ok ok ok ok
Which of the following is LEAST likely to be a field in a Customers table? Addre
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
ss
LastName Employ ok
mentDate
PhoneNumber - CORRECT ANSWER -EmploymentDate ok ok ok ok
Queries in access can be used ok ok ok ok ok
as a source of records for forms and reports
ok ok ok ok ok ok ok ok
to view, change and analyze data in different ways
ok ok ok ok ok ok ok ok
, Both 'a' and 'b' ok ok ok
Only 'a' - CORRECT ANSWER -Both 'a' and 'b'
ok ok ok ok ok ok ok ok
Kian needs to sort a list of patients by birthdate to show the oldest patients first. What sort order on th
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
e birthdate field will give him this result?
ok ok ok ok ok ok ok
Z to A
ok ok
Smallest to largest ok ok o
A to Z
k ok ok
Largest to smallest - CORRECT ANSWER -Smallest to largest
ok ok ok ok ok ok ok ok
Which data type would be best suited to a field that lists customer email addresses?
ok ok ok ok ok ok ok ok ok ok ok ok ok ok ok
Number
Date/Time Hyperli ok
nk
AutoNumber - CORRECT ANSWER -Hyperlink ok ok ok ok
A field's data type determines what kind of information can be stored there. tr
ok ok ok ok ok ok ok ok ok ok ok ok ok
ue or false - CORRECT ANSWER -true
ok ok ok ok ok ok
What are the different views to display a table? Piv
ok ok ok ok ok ok ok ok ok
ot Table & Pivot Chart View
ok ok ok ok ok
All of the above Da
ok ok ok ok
tasheet View ok
Design View - CORRECT ANSWER -All of the above
ok ok ok ok ok ok ok ok
What does SQL stand for? ok ok ok ok
