I’m working on an Access Database (although I know nothing about Access) and need some help with it. I’m working on a database to use for my E-bay auctions and when finished I plan to offer it for free to anyone who wants it. I need to know how to add a screen for item entry where I enter the following information
Item Number, Amount I bought, The source, and how much I paid.
Then I need another screen that I enter the auction Date, Amount on auction, auction # and at the end the date the auction closed and the amount.
I checked out your database. Since it’s just one table it seems like if you just used the Forms Wizard to automatically generate a columnar form using the fields you specified that that would be enough.
Since your data is in a flat table rather than relational I don’t believe you should use two separate forms. Just the one I mentioned making above.
Now, if you want to add buttons that generate reports, open other forms or whatnot, well, be prepared to hit the F1 (Help) button a lot or buy a book. Actually, there are wizard for these things too but it can suck up a lot of your time tweaking them to get it ‘just right’.
Make a table with all your desired fields and field types. Then use the Form Wizard to create the input form based on that table. Select all the fields. Choose columnar with a Standard style, if you want a nice user interface form, one record at a time, or choose Datasheet if you want more of an Excel-like interface for editing multiple records (rows) at once.