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 > Company or Person 2 < Company or Person | Date Not Working >
Back to Company or Person 2    Comments List
Quiz Pinned    Upload Images   Link   Email  
Richard Rost              
28 days ago
Q1. What is the primary goal of the video tutorial?
A. To create a database from scratch.
B. To define different types of businesses.
C. To display the company or person name more professionally.
D. To learn how to use complex mathematical functions.

Q2. Which function is used to check for null values in the tutorial?
A. Len
B. IsNull
C. Concat
D. Nz

Q3. Which mathematical concept is suggested as a useful tool to handle blank spaces in the video?
A. Null math
B. Binary math
C. Complex math
D. Algebra

Q4. What operator is used in calculated fields for string concatenation in the video?
A. +
B. &&
C. &
D. ||

Q5. When creating the "prepared for" field, what does the tutorial recommend displaying if the company name is null?
A. The address
B. The customer's email
C. First name and last name
D. The date of birth

Q6. What should you do first according to the video before changing any fields in the report?
A. Create a backup of the database
B. Close the customer table
C. Create a query with the necessary fields
D. Install new software

Q7. Which function is used to remove leading and trailing spaces in strings?
A. RemoveSpaces
B. Clean
C. StrTrim
D. Trim

Q8. What alternative method to 'Trim' is suggested for handling spaces in null values?
A. Using Nz function
B. Adding null to spaces using the '+' operator
C. Using Format function
D. Removing spaces using Replace function

Q9. How does the video suggest making fields visible in the report?
A. Using Format Painter
B. By adding borders to the fields
C. By using the Transparent option in Shape Outline
D. Printing the report with a high-quality printer

Q10. According to the tutorial, what is essential to understand when using calculated fields?
A. Date and time formats
B. Basic HTML structure
C. Syntax of functions and operators
D. Network security protocols

Q11. If a field is not appearing correctly because it contains a space but no text, what does the video recommend adjusting?
A. The printing settings
B. The CanShrink property
C. The data type of the field
D. The page setup

Q12. What does the presenter emphasize about learning advanced features without programming?
A. Buying additional software
B. Signing up for intensive coding classes
C. Utilizing his expert lessons and resources
D. Reading multiple textbooks

Answers: 1-C; 2-B; 3-A; 4-C; 5-C; 6-C; 7-D; 8-B; 9-C; 10-C; 11-B; 12-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.
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/13/2024 7:58:24 PM. PLT: 1s