Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Back to Access Developers    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Create a db for QA defect log
Casey Deplaa 
    
3 years ago
Hello, I will try to make this brief and easy to understand. I am trying to create a database for QA non-conformances in a manufacturing facility. I have already created numerous tables and forms for specific information such as customers, line #s, types of defects, operator numbers, etc.  
The problem is the main form where all this information is entered is very large and I cannot get a report generated that looks professional, clean and organized. I read on-line somewhere that perhaps I should break down this table into sub-tables - like steps that need to be followed in a specific manner.
Attached is a pdf of how I would imagine the steps to be but I do not know how to go about creating the final report for this in access. Of course I can create multiple forms to enter the data in steps (as this whole process does not happen very often happen on the same day) but how do I then create a report out of all these tables into 1 cohesive report.

If you can provide me with any insights on how to get this done it would be so very greatly appreciated. I am taking your courses and trying to learn from them but I require a bit more assistance.  Attached are screenshots of my proposed document broken down into steps and a listing of all the tables and forms I have created in access for this db.
Casey Deplaa OP  @Reply  
    
3 years ago

Casey Deplaa OP  @Reply  
    
3 years ago

Casey Deplaa OP  @Reply  
    
3 years ago

Casey Deplaa OP  @Reply  
    
3 years ago

Casey Deplaa OP  @Reply  
    
3 years ago

Casey Deplaa OP  @Reply  
    
3 years ago

Mark Pierce  @Reply  
     
3 years ago
Casey,
I also run an NCR database and trace list system. You can manage large forms like that with the creation of sub-forms from the direct sections, all forms would be linked to the main.

When I did this with mine, I was able to create one report for all subsections by simply adding the Form and subforums to the report. If you want a different format on the report, make copy's of the subforums and give them names like "formName_R". the R is for report version.

I may have not do it the best way but it did work for me.
Celeste Bird  @Reply  
    
3 years ago
I too have created various tables connected back to the main entity and would like to create a large detailed report with all the data pertaining to the entity, so far I have been building a lot of queries to provide that information on the report, and I didn't base my data collection forms on subforms, I created buttons and used the VBA codes taught here and record source formula to ensure the relationships... Your idea seems like fewer steps than what my brain created as the solution LOL thanks I am going to try it!!!
Casey Deplaa OP  @Reply  
    
3 years ago
Thanks Mark and Celeste for the responses. This is really my first kick at the can for making a database so I have alot to learn. I will look into subforms and how to create them and link them in a final report. If I have further questions is there a way to get in touch with you and get your input?
Celeste Bird  @Reply  
    
3 years ago
This is my first time building a data management system and am learning as well, I do not know how to share my info without putting it out there for the world to have access to me, but we could support each other's learning through a google classroom if allowed, but I do get my training from here and would come here to ask of my issues, and if there isn't a video: there is usually a video.  
I find this platform provides a continuous working structured knowledge base for real life, in real-time, so one's skills grow with the needs of data collection, once one knows the power they now hold, their needs grow because their imagination now can see what all they can do and record.
My first design needs work because I did not utilize a helper table I kept everything separate, I am currently looking at SQL and splitting details. You work looks great so far!!!
Casey Deplaa OP  @Reply  
    
3 years ago
I will attempt to create multiple subforms within a form after watching the video How to create Multiple Nested Continuous subforms. I do not believe that I will need continuous forms for all of my subforms but I will find out as I try to build it. Then I will have to attempt to create a report from all these nested forms. Hope it works.
Celeste Bird  @Reply  
    
3 years ago
That is what I am trying today, and I will be watching that video, then the splitting one again, then the SQL one... I am scared of splitting my data and uploading to SQL LOL but that was the whole purpose - so I didn't have to do the data entry but yet receive the statistical data I wanted. I am trying to perfect everything first, but one HUGE mistake I made, (besides the helper table, still debating if I should append and create it), was not utilizing the captions in Design view on all the tables, oh AND not having a proper entities requirements map- "I Declare! I will forever use the captions hence forth & map my data design hahahahaha! Captions are the hugest time saver for forms and reports! And a list of tables and their ID names has been a huge help in coding.  Good luck with everything! Challenges keep the blood flowing!! hugs!
Casey Deplaa OP  @Reply  
    
3 years ago
Mark, is there a way that you could post up a screenshot of what your report looks like. In this NCR database there will be only one NCR# and there will be various steps in there such as product identification, problem description, product disposition, root cause and corrective action, etc. How do these get linked together?
Mark Pierce  @Reply  
     
3 years ago
Casey,
you need to create a parent - child relationship between what is the record main and related documents. I believe there are several videos on this. The NCR is most likely your driving relationship for these forms, possibly also the part number.

try watching those tech help videos first, if you still need help let me know.

disclaimer, I am not an expert but I have been able to learn everything I needed to know form this site.

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

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: 8/7/2026 3:40:27 PM. PLT: 1s