Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > TechHelp > Directory > Access > Quick Queries > QQ20 < QQ19
Back to Quick Queries #20    Comments List
Quiz Pinned    Upload Images   Link   Email  
Richard Rost               
29 days ago
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.
Add a Reply Upload an Image

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 10/11/2024 5:21:18 PM. PLT: 1s