Computer Learning Zone CLZ Access Excel Word Windows

I remain the optimist: you just do your best and hope for the best. But it's an evolving state of mind.

-Neil Peart
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Visitor Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Create Jobs from Products
Graham Heron 

3 years ago
I own a printing business and I want to create a database where I can have a product list which contains many variances to the same product i.i. 100 Business Cards, 250 Business Cards, 500 Business Cards, 1000 Business Cards.  Then variances to be standard/laminated/square or round corners/printed one side or 2 sides/printed on differents types of stock etc.  I then need to create jobs, then to an order or order to the jobs, then to invoice and receipt.  I also would like to be able to generate a Quotation which can be converted to an Invoice then paid receipt and keep a copy of the quotation.  Many thanks in advance for your help.

Regards Graham
PS.  I love your videos, they are very detailed and entertaining Rich :-)
Scott Axton  @Reply  
        
3 years ago
Graham
The short answer is: Yes, this can be done.  No, there isn't a specific video to guide you toward.

The truth is you really need to have a good portion of the courses under your belt to do this properly. This isn't a "simple little project" (my words, not yours) that is covered in a 30 min video nor could it be.  There are a ton of subjects that build on each other that all depend on the learning knowledge you would gain from other previous videos.

The best suggestion I could offer you would be to start at the beginning and progress through the courses one by one.
Kevin Yip  @Reply  
     
3 years ago
This is definitely a big job with many components that have to work seamlessly together.  This may be a consultant-level job.  Even with the best Access skills, this could take a while if you were to create it yourself -- in addition to the time it would take to master Access if you haven't already.  In my old job, I developed certain things myself, but I also sought consultants for other things to save time.  

If you seek consultants, be sure they are familiar with the industry you work in so you don't have explain everything to them.  If you are in retail or wholesale, consumer products or industrial products, make sure the consultant is experienced with them.  Every industry has specific requirements and standards that need to be incorporated into business applications (the lingo, types of products, types of transactions, etc.).  

Richard's site has "templates" for various business applications, such as invoicing, customer entry, etc.  But they are just that, templates.  They are not full-blown, comprehensive applications that you can use right away in a real business.  And they certainly don't include any industry-specific elements.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Visitor Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

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 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/7/2026 11:40:20 AM. PLT: 1s