Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > TechHelp > Directory > Access > Account Statements 2 < Account Statements | Account Statements 3 >
Back to Account Statements 2    Comments List
Quiz Pinned    Upload Images   Link   Email  
Richard Rost             
36 days ago
Q1. What was the primary goal addressed in the video regarding the account statements?
A. To create a new account from scratch
B. To add a new transaction line
C. To modify the report to show section totals rather than a grand total
D. To change the color scheme of the report

Q2. What did the presenter decide to remove from the report?
A. The transaction details
B. The debit and credit columns
C. A line he previously inserted
D. The entire footer

Q3. What key change did the presenter implement in the account statement report concerning transaction types?
A. Separate debit and credit totals for each section
B. Incorporated both debit and credit in a single column
C. Removed debit and credit, left only the amount column
D. Swapped positions of debit and credit columns

Q4. In the video, what mathematical operation did the presenter use to correct the total amount calculation?
A. Added sum of credits to sum of debits
B. Divided sum of credits by sum of debits
C. Subtracted sum of debits from sum of credits
D. Multiplied sum of credits by sum of debits

Q5. How did the presenter recommend handling criteria for report generation?
A. By entering it directly into the query in SQL view
B. By setting the criteria on a linked form
C. Through hard-coding the values in the VBA module
D. By asking users to type it each time in a pop-up window

Q6. What default value did the presenter set for the start date input on his criteria form?
A. Today's date
B. The last day of the current month
C. The first day of the last month
D. The first day of the next month

Q7. How did the presenter suggest feeding date criteria into the report?
A. By manual entry each time the report is run
B. Through dynamic updates as the database updates
C. By capturing it from a user-input form
D. By automatically reading the system clock of the computer

Q8. What did the presenter use to adjust the layout elements of the report to grid alignment?
A. Dragging manually to fit
B. A VBA script to align elements
C. The 'size to grid' right-click option
D. Automatic alignment settings in the design view

Q9. According to the presenter, what seminar covers extensive use and manipulation of date and time in Access?
A. The Advanced Date Time Seminar
B. The Date Serial Functionality Seminar
C. The TechHelp Date Seminar
D. The Date Time Seminar

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

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 Account Statements 2.


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: 6/13/2024 11:37:07 PM. PLT: 1s