Bullschmidt.com


     Home
     Web Database Concept
     How We Work Together
     Bio
     Web Database Sample
     Classic ASP Design Tips
     Bar Chart Tool
     Web Design Resources
     Access Database Sample

Here is a sample Access invoices database which you may download and use for free with no warranties.

Sample Access Invoices Database
Sample Access Invoices Database
(invoice.mdb zipped to approx. 0.25 MB)


One interesting feature is that the invoices dialog has a dependent combo box which only shows invoices based on what was chosen in the rep and customer combo boxes just above it.

Also the database uses the query by form concept so that on the invoices dialog one can optionally choose a rep, a customer, and perhaps a date range, click on a button that says "Input," and then have the invoice form open up showing all the invoices that match the criteria.

A warning box appears if the user tries to open the form when no records match the criteria on the invoices dialog.

Within the invoice detail section, one can choose the product number from a combo box and then the product description and price are automatically placed onto the invoice detail line and the totals are recalculated.

Of course a more customized version for you might be split into a frontend and backend, and possibly have more features such as product categories, several shipping addresses for each customer, additional reports such as showing production by each rep, and/or a help file.

And by the way often I can put together some of your ideas with no obligation and e-mail you an .mde file which is the same as an .mdb file except that design mode is removed from everything but tables, queries, and macros.

And if you like it you can pay me at $35/hour via PayPal or check and then I can send you the .mdb file.

So feel free to e-mail me some instructions.  And if you also optionally want to send over anything such as the start of an Access database, an Excel file, and/or a logo file that would be fine too but not necessarily needed.  And of course I will keep whatever you send me in confidence.

And if you do, perhaps you could let me know a little about yourself and your company too.

And for details about putting a database on the Web, click here!

Paul

J. Paul Schmidt, MBA
Web Developer




To Use Paul's Services:
Paul@Bullschmidt.com

Let's put some data on the Web!
Copyright © 2000-2014
J. Paul Schmidt, MBA
Freelance Web and Database Developer
All Rights Reserved

Privacy Policy