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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.