By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,778 Members | 1,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,778 IT Pros & Developers. It's quick & easy.

How can I to create a receipt database using Access 2010 where I have one receipt num

P: 2
I work with a company who is needing to use Access 2010 to receipt in checks for paid invoices. Our issue came when our auditor found we had duplicate receipt numbers using serial numbered receipt books. Therefore, My boss is wanting a database where "we can use ONE receipt # per check even though they may be paying for more than one invoice at a time". I am wanting to be able to run reports to show which invoice has or has not been paid. Can someone give me an idea on how to build this?

If I am not mistaken I will need separate tables for the following:

*Agencies that we bill (Agency being primary key)
*Receipt table (receipt# being primary key)

What I am not sure on how to build:

*How I can enter multiple invoice numbers that are being paid with ONE check using ONE receipt #)

What completely confuses me:

*Would it be a good idea to have a uniform structure on our invoice numbers? At the current time, we use an alpha numeric invoice number with the numeric changing every month to the month it's being billed for. i.e AAAA-01-14.

*Would it be easier to keep the i.e. AAAA and have a separate field for the month and year being billed, or is that something completely different?
Jan 22 '14 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
Respectfully, Bytes is neither a code writing nor homework service. Also, site policy asks that each thread be limited to one question. Please read the FAQ and posting guidelines.

There are several examples of invoicing databases, infact, Office/Access has several examples that ship with it. You may very well find one that is suitable with only minor tweeks. Be aware, that we may not have access to these templates so asking how to modify them will have to be very specfic as more than likely we don't know the construct of the database.

If those templates don't help then I suggest you work thru the first tutorial listed below as it provides a basic concepts of how to do things you will need to do, there is a sublink within for database design:
---
MS Access 2010 Tutorials
Access Basics - By Crystal
Micrsoft: Office2010 tutorials
Microsoft: Getting started with Access 2010
> Database Normalization and Table Structures.
Nassi-Shneiderman Charts
---

BOL with your project.
Once you have your outline setup you can certainly stop by and ask if you've over looked something or if there's a better way/method.
Jan 22 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.