Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > TechHelp > Directory > Access > Quick Queries > QQ15 < QQ14 | QQ16 >
Back to Quick Queries #15    Comments List
Quiz Pinned    Upload Images   Link   Email  
Richard Rost             
2 months ago
Q1. What are the two methods recommended for updating a distributed backend database with new tables or fields?
A. Provide a tool to import data and programmatically edit tables
B. Change database passwords and enforce new data validation rules
C. Provide a complete new version of the backend and frontend
D. Request users to manually recreate tables and fields

Q2. What are the consequences of trying to lock down an Access database according to the video?
A. It's not possible to lock down an Access database
B. It can keep out 99.9% of users but not someone who knows their way around Access
C. It will completely secure the database from unauthorized printing
D. It doesn't affect database performance at all

Q3. How can you manage filling in a PDF with drop-down boxes using Access?
A. You cannot interact with PDF drop-down boxes from Access
B. Utilize send keys functionality to simulate keyboard inputs to the PDF
C. Convert the PDF to a Word document and use Access to fill it in
D. Only use the paid version of Adobe Acrobat for any PDF manipulation

Q4. According to the video, what functionality is NOT remembered by Access in design mode?
A. The size and location of forms and reports
B. The size and location of tables and queries
C. The size and location of the navigation pane
D. The property settings of form controls

Q5. How can you ensure that Access cleans up memory when using forms and reports heavily?
A. Access automatically cleans up all memory, so no action is needed
B. Reboot Access at least once a day
C. Increase the RAM on your computer
D. Manually delete the forms and reports

Q6. What kind of table structure would you need to track individual items with expiration dates as mentioned in the video?
A. A single table for products with expiration dates
B. Duplicate tables for each individual item
C. One product table and a separate inventory table with item tracking
D. Inventory table with only expiration dates but no item tracking

Q7. What is necessary to create an unsubscribe button in Access for sending multiple email?
A. Only Access is required to implement the complete unsubscribe feature
B. A service or external website to receive and process the unsubscribe requests
C. A complex SQL query within Access
D. A built-in Access feature that requires no additional setup

Q8. What is the reason Access databases should be regularly rebooted according to the video?
A. To allow for scheduled maintenance and updates
B. To prevent corruption of database files
C. Access may not free up memory after closing forms and reports
D. Rebooting accelerates the speed of database queries

Q9. For linking records based on time where there's a delay of a few seconds, what was suggested?
A. It is not recommended to rely on times to link two records together
B. Use =Now() to sync both tables
C. Manually adjust the times on each table as needed
D. Increase the server time-out settings

Q10. What is the requirement for referential integrity to work in a split Access database?
A. It requires a paid upgrade from Microsoft
B. It only works in the frontend database
C. All related tables must be in the same physical ACCDB file
D. You can have referential integrity across different backend files simultaneously

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

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.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Quick Queries #15.


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

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

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/22/2024 10:23:35 AM. PLT: 1s