What happens if some records do not meet the data validation criteria - ProProfs Discuss
Topics
Products
Follow Us:

What happens if some records do not meet the data validation criteria during importing data?



A. Import process aborts when encounters the first invalid record.
B. Import process ignores the data validation rules.
C. Import process requires user authorization to import the invalid records.
D. Import process fails only for the records with invalid data.

This question is part of Practice Admin 201 Set 4
Asked by Wyatt Williams, Last updated: Aug 07, 2020

+ Answer
Request
1

2 Answers

M. Krasinski

M. Krasinski, Content Writer, Columbus

Answered Sep 11, 2018

Validation rules ensure accurate data entry. Validation rules also catch errors at the data entry level, and the mistakes never make it into your database. If the data doesn’t satisfy the conditions that have been set, access won’t accept the input value.

Validation rules are more efficient than clearing up after the fact. To protect the validity of your date, you start at the foundation. The field’s data type will restrict input value to specify types of data. The second line of action is the field table and validation rule, which restricts the input value conditionally.

1
 

John Smith

John Smith

Answered May 21, 2017

Import process fails only for the records with invalid data
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.