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

Which of the following is a true statement about Forms?Group of answer choicesForms cannot be used for data entryForms are a database object used to add data into a tableForms are useless in AccessForms are not a database object

Which of the following are primarily used to help ensure data integrity (more than one answer)?Group of answer choicesConceptual designData typesDe-normalisationLookup tables

Which of the following may be the consequence if you fail to properly validate your data?Group of answer choicesData analysis will become easierYou will receive less criticism about your conclusionsYour reputation will be enhancedYou may not be able to demonstrate that you collected and analysed your data appropriately

Which of these are guidelines or best practices for form design? Select all that apply.1 pointUse many columns Keep forms simple and straightforward Sort your form fields from the simplest to the most difficult Make use of inline form field validationClearly label your form

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