Making auto numbered receipts with info from more than one table

[ktm458]

Let me start by saying I have VERY limited knowledge of access. As in a had a basic class that covered it in college but that was years ago.



I have 3 spreadsheets currently that I use during an auction.

-The first spreadsheet has the name, address and bidder number of each bidder.

-The second spreadsheet has a list of each item to be auctioned along with some various identifiers for each one.

-Lastly, I have a file that I copy and paste the item details and buyer info into that prints me a triplicate receipt onto blank perforated paper and prints some of the info on a form I get elsewhere that saves me from having to hand write everything.


my question is this: Am I at least on the right track here in thinking that by putting all of this data into separate tables within access that I will be able to ditch the spreadsheets or should I be looking into something else? I want to have a form where I type in the bidder number, number of the item purchased, sale price and whether or not it was sold by cash or check and it auto populates the table containing all of the items with the buyer number and sale price. I also want it to also generate a unique receipt with selected info from both tables.

I know that's a lot to read all at once, but what do we think? Good job for Access or no?

Thanks!

[ranman256]

yes, access is the way. And it can do all you asked.

[ktm458]

yes, access is the way. And it can do all you asked.

Good news!

Can you point me in the direction of any good resources or tutorials that may outline a way of going about this? Or maybe give me some good search terms to use to find them on my own? I'm having a hard time finding anything...

Thanks!

[orange]

Here are some links to info relevant to an auction database.

Facts involved in this sample.

The free, generic data model supporting the Facts.

A general approach to database design.

Good luck.

[Xine]

I also took intro to Access in college and found myself years later needing a resource to refer to now and again. Back when it was new, I bought "Access 2010: the missing manual" and it was good for my skill-set. Now that I'm moving beyond it, I just google the problem and I can usually find a solution.

BTW: I've used Access for a company golf tournament (and auction) and I find it way more useful then the typical excel spreadsheets.

[orange]

xine,

Perhaps you could post a copy of one of your databases (auction) as a sample for ktm458.