ITE Guaranteed A+
Which of the following is LEAST likely to be a field in a Customers table?
LastName
Address
EmploymentDate
PhoneNumber ✔️EmploymentDate
Which of the following is the easiest way add data to a table.
query
report
form ✔️Form
In a record, each separate piece of data, such as a last name, a first name, or an address, is called a
_____________.
Record
Field
File
Table ✔️Field
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?
Z to A
A to Z
, Largest to smallest
Smallest to largest ✔️smallest to largest
This key uniquely identifies each record.
primary key
unique key
field name
key record ✔️Primary Key
What are the different views to display a table?
All of the above
Design View
Datasheet View ✔️All of the Above
What does a filter do?
Slow down processing
Make more records available
Hide records from view
Add to the quantity of data ✔️Hide records from view
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?
Major
GPA
Graduated
Which of the following is LEAST likely to be a field in a Customers table?
LastName
Address
EmploymentDate
PhoneNumber ✔️EmploymentDate
Which of the following is the easiest way add data to a table.
query
report
form ✔️Form
In a record, each separate piece of data, such as a last name, a first name, or an address, is called a
_____________.
Record
Field
File
Table ✔️Field
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?
Z to A
A to Z
, Largest to smallest
Smallest to largest ✔️smallest to largest
This key uniquely identifies each record.
primary key
unique key
field name
key record ✔️Primary Key
What are the different views to display a table?
All of the above
Design View
Datasheet View ✔️All of the Above
What does a filter do?
Slow down processing
Make more records available
Hide records from view
Add to the quantity of data ✔️Hide records from view
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?
Major
GPA
Graduated
