Search results

Hmmrr. If you'd like to struggle together to get it done, why not? :D I'm an accounting student who just got done with intermediate accounting finals and likes accounting info systems.

YOU GUYS ARE SO FRIGGIN HELPFUL. Thanks again!

Ah! Sounds like periodic accounting to me. : ] Does that mean I should periodically update the inventory levels when there's a purchase event and let the select query deal with showing current inventory levels after a couple sales?

I would just ignore the fact. I just want to know why the inventory table shouldn't/can't be automatically updated instead of using a query.

The issue I see is that when my friend checks his inventory through the inventory form, that number will be different from the query. Also, if the inventory count is just Have = Bought - Sold, does that mean we don't need a qty attribute in the inventory table and should keep the qty in the...

So I'm creating a database for a friend of mine who has just re-opened his cigar shop. Here are the tables: Sale Purchase Inventory Vendor Customer Association Tables: Sale Detail Purchase Detail As I was messing with this on Access, I wanted to have the db automatically update inventory...

Thank you for replying! It's 7:18 AM where I am. Nothing like database design and breakfast at the same time. :D That said, I shall grace you with a thorough reply after I get done with my midterm today.

I can totally relate to this. My micromanaging manager always tries to have meetings with me to get me to do more work for free. : |

The significance of the prime and the sub table is so that the prime and sub id appear as a foreign key in the contractor table. From what you've just said, it now seems unnecessary. What do you mean by (y/n) field? Will I have to just manually assign y/n to each field or is there also a...

Linking through a Duality This is just a rehash of the "Three-Way Association Table" in a clearer way but I'm curious about why linking through a duality is so abhorred? My professor claims weird stuff can happen and that IT'S STINKING EVIL, but nonetheless, he recommended it to me for my...

Is the three way association table necessary? Hi guys. Attached is the basic database for reference. Here is an interesting problem that I've run into at my internship. Currently, I'm working on a database for a compliance audit on a bunch of construction companies. Since they're going to do...

I've been using Access 2007 for about two months. I haven't had the time to get around to using Access 2010, but I'm sure it's great software with all the new content. Learning on Access 2007 for now seems just fine since my work uses it or would this be an example of the dangerous short term...

Thanks again!

Thank you! Was this using Visual Basic code? And, since I don't know any, could you recommend a guide? I've used mail merge before, but I don't know where to insert the function in word. If it is indeed VB, then I'll study up a bit and look through the code. It's kind of scary to just take...

I'm an accounting major who has fallen in love with relational databasing and how it can help people make better decisions. I'm here because I'm close to clueless about access and would like to learn more. Hopefully, I can segway into oracle software and other relational databasing programs.

To begin: I don't know what I'm doing. I'm currently volunteering at a nonprofit and am using MS Access to track customers to pledges, cash receipts, and seats and tables. The gala (the database was designed for) has passed and I need to print and send out invoices for our sponsors who...