Thanks. Your video has been very helpful. Will be using the knowledge acquired to create a database for my local church. God bless you all at Software Matters
it was fantastic ,i need to manage RFQ ,quote ,LPO,invoice on maintenance business ,which means incoming outgoing documents to manage the documents ,please help on some advice highly apprecite your lesson .......... cheers
Thanks a lot for this video. This was very helpful. I'm trying to create a Patient Record DB and one of the tables is Prescription, in that I would to add a filed called medicine, dose and qty. Currently I setup the prescription tables with only three fields. however the requirement is the users should be able to add more than one record for medicine, dosage and qty. Do i have to create more fields for medicine, dosage and qty if the user wants to write more than one medicine. I want the user to decide on how mnay records he/she can enter. how do I address this.
Good morning. How do you do. I hope you are ok with your family. I like your tutorial video for Microsoft Access. I highly requested you make tutorial video for stock control. Example stock table, Customer table and Suppliers table from this three table how control minimum stock level when issue material for Customer automatic reduce from stock and when receive material from Suppliers automatic add stock. Please make tutorial video for this.
The free download appears to be inactive, even after attempting to contact the company. Please advise readers that the sample is NOT available or correct the link and download. Great video, clear with good concepts and presentation.
Hello. The free download is still available and working. It is emailed to you automatically but your spam filter may send it to your junk folder. Please check there. We are currently in the process of changing the download method to try and avoid this issue and will post and update once it is live. With best wishes The Software-Matters team.
Hello. We have just tried the download using Firefox and a Gmail account. The email and file was received but it was in the Spam folder. Have you checked your Spam folder? With best wishes The Software-Matters team.
Sorry for the inconvenience. I did find the hidden SPAM folder and the downloaded file (4 copies). I appreciate your assistance and understanding in resolving this.
Suppose I want sales quantity to reflect directly on the system. Is it complicated? Some says that making inventory management requires POS and this is when complexity starts.
Hello, thanks for the question. Both the stock level and the minimum stock level are stored in the product information. The stock level is amount of stock you currently have, and the minimum stock level is the minimum amount of stock that you want to hold for this product (which could be zero). The query shown in the video displays parts (and their suppliers) that you currently have less stock for than the minimum stock level for that part. In other words, it shows parts that you need to order more stock for.
Thanks. In short these are in product /material master list. Min stock level shud be in the criteria of stock level. Is this correct. My query wasn't executing. Shows some error. Any clue. Thanks for your time.
I am working on a project on MS access: I have three different departments. Extruder, Printing, Cutting then final stock in hand. So as the any order come. The job order form is prepared for production. There r 8 Extruders and each Extruder has its different maximum and minimum production capacity in 24 hrs span. Now I want to know that what extruder is available and what extruder is engaged. And we have the enough material for specific job completion. Different jobs can be put in production according to job type; like Job is Urgent or normal and also estimated completion period. As is job is completed it transfer to another department and so on. Finally, Wastage calculation for specific job and its cost. Please guide
I was actually looking for the "next step". That is how things bought (into the Company) and then sold (going out of the Company gain) was reflected in an stock table or maybe stock Query? Sorry to say that you did not show me that. So it was a Little Waste of time.
I too came here to look for how, if I add a sale, can be automatically be deducted from the stock table and if I add a purchase will be added to my stock. But unfortunately it wasn't covered. Can someone help us here pls. Otherwise I've learnt a thing or two from here and thanks
Hello Mr. Thanks for all. Really I want to know how I can Scanning with MS Access and show that image on PictureBox And save it in MS Access Database. Another Question? I have a program in MS Access that manage Employee and Customers, and table of Users, I want to know if user 1 or 2 or 3 , Print or delete or edit a file that be in report with User Name or User ID..... Help Me .Please
hi! i am looking how to set validation rule for customer order quantity where it cannot enter number greater than the available stock. I have a query table showing the available stock level generated from summing up the purchased quantity and deducting the customer order. Can you give me an advise?
My dear I have a database to make a monthly invoice for construction project we have many projects , each project have a Bill of Quantity "BOQ" this BOQ have some items each item have Quantity "Qty "and unit price and total Price = Qty *Unit price BOQ table ( Project ID , Item ID, Item Description , Unit , Qty , Unit Price , Total Price ) the problem is how to make a form for the monthly invoice that invoice have the following fields " Current Executed Quantity , Previous Executed Quantity , (Total Executed Quantity = Current + Previous ) " last column is Total Price = Total Executed Quantity * Unit Price Invoice table (Project ID , Item ID , Item Description , Current Qty , Previous Qty , Total Qty ,Unit price , Total Price = Unit price * total Qty) how can make a form to bring all Items in the new invoice one time it means if we make a new invoice the program have to get all items automatically . secondly how to make the Previous Quantity column in next invoices = the total Executed Quantity in the previous invoice it means the Previous Executed Quantity in invoice no 2 as example is equal to the the Total Executed Quantity in Invoice no 1 if total Qty in Invoice 2 is 2500 so the Previous Qty in invoice no 3 is the same 2500 I hope its clear & I hope to find solution for this problem thank you in advance for your help and consideration
Tom John To do that, you need to create an "Order Items" table where each order item record is a line on the order. It will have a one-many relationship to Orders and to Parts. I hope that helps, but if not feel free to drop us a line via our website. With best wishes from Software-Matters
+Amogh Bhosekar To do this, you would need to add another table into the database called something like “SupplierParts”. Initially this would include three fields: SupplierPartsID (Primary Key, autonumber), PartNo (looks up and related to PartNo in Parts) and SupplierRef (looks up and related to SupplierRef in Suppliers). This effectively allows you to create a many-to-many relationship between suppliers and products. In the new table you create a record for each part from each supplier, so if one part had two different suppliers, you would create two records in that table.
no. it is just a production order on the flow. To make system remember the BOM, you need to integrate the SKU# that would be associated with component combinations and specific instructions
Hello! Actually, the download does contain one query and one form. Please bear in mind that this is a beginner-level tutorial designed to help people create something basic. With best wishes The Software-Matters team.
Hi, Thank you for sharing the tutorial. It is so helpful for understand the purpose of the application. I have a doubt to ask you. I am planing to make a new database of the 2 Stocks of stocks which is 1, Warehouse Consumables 2, Office Consumables I have tables as mentioned below 1, Customer 2, Orders 3, Stock Details 4, Purchase Order Each are connected with unique ID which is ITEM CODE except the customer. Now the Question is. I need to share the form to different customers in the intranet where i am working with. For example i am sharing a request form for some stocks which the form contains the fields like Name of the customer, Employee ID, Email ID, Phone, Item Description, Quantity, Request Type. If it is possible to share the form to around 10 people in my organisation, i can process their orders in my system and to confirm their order followed by accepting their request through the system. Is this possible? Please advise. Thanks in advance :)
Sorry to hear you've been having trouble! If you were unable to access the webpage to download, follow this link: www.software-matters.co.uk/free-access-stock-control-database.asp Once there, enter in the details required and you will receive an email with a verification link to receive the download. This email can sometimes take some time to come through, or go into your Spam or Junk folder, so make sure you check those.
We have checked this facility and it is working. Please check your spam or junk folder to see if it has gone in there. If you still can't find it, please email us at jdenq@software-matters.co.uk and we will send you another copy.
Hello Geof. This video is designed to start at the beginning and to get you started. There's a second installment coming soon, so do subscribe to find out when that is published. With best wishes
You're not the first person to say this, so we created a version without music, which you can view here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-049IlFNcrl0.html With best wishes the Software-Matters team
I hope you also found the version without music! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-049IlFNcrl0.html. With best wishes, the Software-Matters team.
Hello! Sorry you were irritated. We created a no-music version of this video for that very reason, here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-049IlFNcrl0.html. With best wishes from The Software-Matters Team
Hello! We know some people find this the case, so there is a version with no music here: studio.ru-vid.com049IlFNcrl0/edit?Fcomments With best wishes from the Software-Matters team
Hello Christopher. Are you still lost at that point? If so, would you like to ask a question as that seems to be a point where we suggest you put in some sample data to help with the next stage.... With best wishes, the Software-Matters team
Hello Jo - We know some people feel this way, so we created a version without music here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-049IlFNcrl0.html With best wishes from the Software-Matters team
Sorry to hear that you find the music infuriating. We're working on it. Meanwhile, if you're someone who has had your attention drawn to the music and your brain won't let go of it, I recommend trying to focus instead on the voice teaching you. With best wishes....