Q1. Why does the instructor advise against using lookup fields in database tables?
A. They are too difficult to use.
B. They are known to cause data corruption.
C. They go against proper database normalization principles.
D. They make the database file size exceed the limit.

Q2. What is the recommended alternative to using dlookup in queries?
A. Use dsum and dmax functions instead.
B. Merge all tables into one.
C. Create lookup fields directly in the tables.
D. Use a join to connect the tables.

Q3. Which scenario was given as a common cause of Access database corruption?
A. Using too many lookup functions.
B. Renaming buttons frequently.
C. Fake data entry.
D. Improper shutdowns and network issues.

Q4. What advice is given concerning temp vars in a database?
A. They should always be removed at the end of a function.
B. They can be left in memory unless memory usage is a concern.
C. They must be removed to prevent database corruption.
D. They should not be used more than once in a database.

Q5. What can you do if you don't like the default Access theme and colors?
A. Switch to the dark mode.
B. Revert back to the 2013-2022 theme via Options.
C. Change each color manually via advanced settings.
D. Download a third-party theme editor.

Q6. What needs to be done to have a database automatically import files added to a folder?
A. Restart Access every time a file is added.
B. Set the database to run on a loop to check the folder continuously.
C. Use a form with a refresh button.
D. Manually drag and drop files into the database.

Q7. What key combinations are recommended for moving, shrinking, and stretching objects on a form without the mouse pointer getting in the way?
A. Arrow keys for moving and spacebar for shrinking/stretching.
B. Arrow keys for moving, control+arrow for precise movement, and shift+arrow for shrinking/stretching.
C. Shift+space for moving, control+space for shrinking.
D. Use only the mouse for all actions.

Q8. What common issue was highlighted when comparing two date fields in different formats on a form?
A. Differences in regional date settings.
B. Form-level settings can override table-level settings.
C. Usage of different date functions.
D. The database version being older.

Q9. Why does the instructor recommend naming buttons with meaningful names?
A. It automatically increases the database performance.
B. It makes it easier to identify button functions in code.
C. Access requires meaningful names to generate events.
D. It improves the aesthetics of the form.

Q10. When creating a new button and then changing its name, what must be done to preserve its functionality?
A. Delete the button and create a new one.
B. Copy the button's event code, rename the button, then reassign the event code.
C. Click "Refresh" in the properties window.
D. Change the button's color to indicate it's been renamed.

Q11. What is recommended when it comes to making fields required in a form to avoid bad data entries?
A. Always make all fields required.
B. Use table-level validation for complex checks.
C. Avoid making fields required to prevent bad data entries.
D. Make all text fields rich text.

Q12. How can you restore the ruler and grid lines if they are missing in Access form design?
A. Restart Access to reset the settings.
B. Use Arrange tab, Size & Space options to turn them back on.
C. Reinstall Access to fix the settings.
D. Reset the user profile in Access.

Answers: 1-C; 2-D; 3-D; 4-B; 5-B; 6-B; 7-B; 8-B; 9-B; 10-B; 11-C; 12-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.