Q1. What is the ISO date format recommended in the video?
A. Year-Month-Day
B. Month-Day-Year
C. Day-Month-Year
D. Month-Year-Day

Q2. Why should you avoid using the format function when handling dates in Access databases?
A. It causes dates to be interpreted as numbers
B. It converts dates into string format, which can lead to errors in queries and calculations
C. It slows down the database
D. It changes the date format permanently in the system

Q3. Which function should you use to extract the year from a date field in Access?
A. Year function
B. Format function
C. Right function
D. Left function

Q4. What problem might occur if you use the right function to extract the year from a text-formatted date?
A. It extracts the wrong characters of the date
B. It converts the date into a completely different year
C. It treats the year as a text string, leading to issues with numerical comparisons
D. It misplaces the year in the date field

Q5. What indicates that a date value might be stored as text in Access?
A. The date values line up on the right side of the column
B. The date values line up on the left side of the column
C. The date values show an error message
D. The date field shows the wrong year

Q6. In Access, what does the parameter query allow a user to do?
A. Automatically format all dates to system preference
B. Input their own criteria for date calculations
C. Change the regional settings of date formats
D. Merge multiple date fields into one

Q7. What is the main advantage of using the ISO date format according to the video?
A. It is the easiest for users to understand
B. It sorts dates more efficiently for computational purposes
C. It is the shortest way to write a date
D. It is the most widely used format in the United States

Q8. How does Access handle a situation when a text string is added to a number in a calculation?
A. It throws an error message immediately
B. It deletes the text string and uses the number only
C. It converts the string to a number if possible and performs the calculation
D. It prompts the user for correction

Q9. Why is it important to ensure regional date settings match the data input style?
A. To reduce storage space in the database
B. To avoid ambiguity such as confusing day/month ordering and incorrect data entry
C. To prevent the database from closing unexpectedly
D. To ensure that data is backed up automatically

Answers: 1-A; 2-B; 3-A; 4-C; 5-B; 6-B; 7-B; 8-C; 9-B

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.