You want all the users inputing the phone number field of Employee table in the format of (999)999-9999. Which of the following data validation will you use?Group of answer choicesInput MaskFace MaskFormattingDefault Value

In a table Employee with columns EmployeeID, Email, and PhoneNumber, which of the following could be considered a candidate key?Group of answer choicesEmailEmployeeIDAll of the abovePhoneNumber

Which data type enables users to choose from the list of options while entering data?Group of answer choicesLookup fieldParameterValidation textInput mask

It is best to have most data validation in Tables rather than forms because ___________________.Group of answer choicesAll the answers are correctdata validation is only required in tabledata validation rules in tables are automatically enforced in formsdata validation does not affect forms so no need to do data validation on forms

In a table Employee with columns EmployeeID, Email, and PhoneNumber, which of the following could be considered a candidate key?

write a function that accepts 10 users name and phone number and structure your data in such a way that when i input a users name it returns the phone number and if the name doesn't exist it should return 00000