Learn Microsoft Access By Example
Advanced Help After Tutorials

Automate tedious tasks in MS Access. Effortless results in record time!
Sample database forms, reports, templates. Free demo with examples.
User tutorial (intro manual or handbook) and training included in online help.

Advanced user information, tips, tricks, and guidelines for using these tools reside in comments in the source code. These samples provide key help with your education course or computer class.



To my fellow Microsoft Access database user ...
  • Don't you prefer more closely customized templates and examples that fit the fields in your very own database?
    Well, now you can name your fields and let these smart wizards generate functional templates, leaving little left for you to do, except some tweaking and cosmetic changes.

  • Don't you wish someone would invent a wizard to create a form with command buttons (New, Delete, Find, Close) already in place, and fully functional?
    Well, somebody has. (That wizard also creates fully functional subforms, all in one step, saving about an hour for each form.)

  • Don't you wish you could simply point to fields on a form and say, "Create a report using those fields."
    Well, now you can. (That wizard also creates report summary controls with working formulas, saving about 3 hours per report.)

  • Don't you wish you could easily decipher your maze of queries and see what queries use what other queries?
    Well, now you can navigate your hierarchy of queries. (That wizard also shows you the source table for each field, even though it may be buried deep in the query hierarchy, saving many hours of frustration.)
My fellow programmer, that's just a small taste, as the screen prints below will show. Are you salivating yet? The eight (8) wizards described below take a giant leap beyond the basic Access wizards. Why? Because they automate more things. Why else? Because they come with VBA code, giving you more control. Get ready to get spoiled. These tools speed up every-day tedious tasks—you know—forms, queries, reports, the things you work with all the time.

Amazingly Advanced Tools for the Average Programmer

I don't care if you're beginner or guru. These tools make programming more fun. Even exciting. Like programming should be. Written in Access 2000 (works in later versions also).

If I could save you 10 to 20 hours right away, how much is that worth to you? On top of that, if I could make programming more fun and less tedious, how much is that worth to you? Well, I absolutely guarantee that you'll not only be pleased, but also amazed, at the results. And you can get a free demo. To see descriptions and screen prints of all eight guru tools, read on.


You seem to have gone a giant step further in the brain department.
Jane Leighton, programmer



Tables and Forms Development Tool

Microsoft Access makes it easy to build tables, and once you build a table, Microsoft Access has wizards to build a form from that table. But how would you like to create table and form together with a click of the button? More than that, how would you like a smarter form wizard that goes beyond the basic form wizard, one that adds buttons of your choice, with functional code for each button, all in one step? Make it all: table, form, functional buttons. It's easy.

Of course, your final form will need some tweaking, but not as much tweaking as with the built-in MS Access wizard, because you can customize this wizard. It comes with VBA code included, giving you full control, and so you can make this smart wizard even smarter. (Get guru tools now)

Once you plan your forms with the above tool, click Create Forms, and now you have a few more options, such as label position. Here's how it works: a template form determines the look and feel of the final form. So what if you want a different look? Just change the template form. What if you want several looks? Just make several template forms. In other words, you design just once, and then you create, create, create, as often as you want with a click of a button.



Forms VBA Code Development Tool

Microsoft Access, when designing forms, allows you to edit the VBA code for form and control events. But to get to the code is quite cumbersome. You have to click in a couple different places to get to it, and once you get to it, it's in a different window. If all you're doing is verifying the code, rather than writing the code, that's a lot of extra work to click in different places and to switch windows back and forth. How would you like a simpler code wizard that puts it all right in front of you? Instantly see the code you want. Then if you see something that needs changing, just one click takes you the code module. (Get guru tools now)



Query Development Tool

If your Microsoft Access database has fewer than a dozen queries, then maybe you can understand your queries and what they do. But if you have a confusing maze of queries, and if you're like me, you quickly forget which queries depend on which queries, and making any changes becomes a nightmare. This tool turns the nightmare into a dream. (Get guru tools now)



Report Creator Development Tool

Making reports in Microsoft Access traditionally has been a step-by-step process. First, you decide what fields you want on the report. Second, you figure out from what tables those fields come. Third, you make a query that grabs those fields. Fourth, you make a report based on that query. Fifth, you equally space the controls on the report. Sixth, you add summary controls to the footer. And there's probably more steps in between. I think I forgot changing the look and feel of the report to match your other reports.

Can you skip most of these steps? Oh yes! My preferable method to create a report is the point-and-click method. It works like this. First, open the form that has the fields you want. Did I say the form? Not the table or a query? Yes, the form. Then focus on the first field and press Ctrl-E. That grabs the field. Do likewise for the rest of the fields that you want in your report. Just focus on the field and press Ctrl-E. That's all. (Tip: ask your client to make a screen print of the form and to circle the desired fields on the form. Then you won't have to guess which fields your client wants on the report, and you'll know on which fields to press Ctrl-E.)

Next, use this development tool to create query and report with a click of a button. When done, you'll be pleased to see that your report has the look and feel of any template report you choose. Your fields will be equally spaced (if there's room). Your summary footer controls will be in place and positioned properly. Group headers and footers, as you choose, will be in place. And, if that's not enough, remember, this comes with the VBA source code so that you can automate and automate. (Get guru tools now)



Report Designer Development Tool

When modifying an Access report, do you forget which group sections are visible or invisible? Do you forget which fields are left aligned or right aligned? To figure out what's what, you have to click on each section or control and view it's properties. If you're trying to figure out a lot of things, that's a lot of clicking. How would you like to view all these properties in one place? And how would you like to have the power to change these properties all in one place? Here's a tool to put it all at your fingertips. (Get guru tools now)



Report Criteria Development Tool

This one I can try to describe to you, but when you see it in action it might take your breath away. Does your Access application run reports? And do your users like to run those reports using certain criteria (like date range)? How long did it take you to set that up? I'll bet that took more than a couple minutes, right? And the more complicated the criteria, the longer it took to set up. I know — I've done a lot of that myself.

Now there's really a way to have a functional report criteria form in just a couple minutes — I mean literally, a couple minutes. This amazing tool automatically finds the report and the fields in that report. Time spent? Zero seconds. What's left for you to do? Select the fields that you want to use as criteria fields by clicking a checkbox. It's that easy! Instantly you have your criteria fields all set up.

Do you have to make criteria controls to go on the report criteria form? No the tool does that automatically. Do you write code to handle the criteria for the report? No the tool does that automatically. Just check a checkbox for the fields you want.

Is that all you have to do is click a checkbox? Well, there's one other little thing. You can enter alias names for the fields. When you do this, then "Date Started" shows as the label on the form instead of the real field name "dteStarted." The alias determines the label caption. The Edit Fields button lets you do this.

These screen prints show how the criteria controls automatically appear according to which report you select. Flexible and fluid is this tool, almost alive. Here you see only two screen prints, but the possible layouts are endless. (Get guru tools now)




Main Menu Development Tool

The Microsoft Access switchboard menu is nice, but it has a couple drawbacks. First, when you go to a submenu, the parent menu becomes hidden. Second, it can be a little cumbersome to maintain. Now here's the slickest main menu that you've ever seen. Remember, this comes complete with code, so that you can modify it in any way. (Get guru tools now)





Export Objects Development Tool

After using these development tools to efficiently create and modify your client's database, what do you do with these development objects? Do you give your client this database with all the development tools intact? No, and that's why we have an easy-to-use exporting tool that remembers when each object was last exported. Use this to export all non-development objects to the final destination Access database. (Get guru tools now)



Autokeys Development Tool

Do you want more shortcuts? I've included an Autokeys macro that does the following:

  • Ctrl-M opens the main menu. Suppose you've designed and debugged, and now you want to test it. Ctrl-M opens the main menu without having to go hunt for it.
  • F10 opens the forms view in the database window. If you were last viewing tables or queries, you would have to click again to get to the forms. I hate extra clicks, don't you? F10 goes directly to forms view.
  • Ctrl-D switches the active form to design view. (Of course, you could click to do the same thing, but this is a keyboard shortcut.)
  • Ctrl-R runs the form you are designing.
  • Ctrl-K turns echo off (in case you need it for some reason).
  • Ctrl-L aligns a label to the left of the control (assuming the label-control has a parent-child connection).
  • Ctrl-U aligns a label up to the top of the control (saves you a lot of dragging, resizing, and repositioning).


VBA Code Examples

Did I mention? All these development tools come with the VBA code behind them. That means you not only get the tools themselves, but it also means that you have sample code from which to learn. By looking at the code, you will see some ways to handle:

  • Building SQL statements on the fly
  • Building combobox control sources on the fly
  • Using the MSysObjects table for faster access to database object names

Free Demo

If you just want to get your feet wet without diving in, then download the free demo (time limited).


Bonus Programs

When you order, you can get free download links to one or more of the following, depending on the package you choose:

  • VBA code to programmatically modify tables, fields, and indexes on your remote backend database, without even opening the database.
  • Rename Controls Wizard — Simpler way to standardize control names on forms and reports. Automatically change control names, control prefixes, captions, control sources, and references to control names in queries and VB code. See description and screen print.
  • Access-To-Excel Tool — Control Excel from Access with a click of a button. Automatically generate Visual Basic code to use in your own programs. See description and screen prints.
  • Alternate Security Tool — Intuitive interface makes it easier move users to and from groups. See description and screen print.
  • Aisle-by-Aisle Grocery List Software — Frugal shoppers rave about the aisle-by-aisle grocery list software that simplifies day-to-day shopping chores. See description and screen print.
  • Image File Utility — Browse image files using MS Access image control, search by title or by description, copy to other folders. See description and screen print.

Download Yours Right Now

The guru tools pay for themselves from day one. So today is the ideal time to get started. Boost your productivity by automating mundane programming chores. Make your complicated database easier to understand. Jump off the grueling treadmill. Absolutely guaranteed to make programming more fun and financially more profitable, and after all, both of those are the bottom lines, are they not? Order now, and download immediately. You'll be pleased to see a price package to fit your budget.




Help Getting Started - Step-by-Step Instructions

Webmasters: link to us and get free software in exchange


Guru tools include:

Download Options
Starting from free on up

Help Getting Started - Step-by-Step Instructions


Calendar Schedule Template

Get an eagle eye view of the key dates in your database. Get the big picture in order to make better evaluations and better decisions. The calendar tool gives you a handle on your dates, because you can view at a glance all your key dates in calendar format. View or print a report by month, by week, or by day. It's a most flexible fluid way of calendaring. View screen prints.


Access-To-Excel Tool

Control Excel from Access with a click of a button. Export/Import data, create charts, format cells. Automatically generate Visual Basic code to use in your own programs. View screen prints.


Manage Remote Database

This wizard makes it easy to modify tables, fields, and indexes on your remote backend database, without even opening the database. View screen prints.


Rename Controls Wizard

Simpler way to standardize control names on forms and reports. Automatically change control names, control prefixes, captions, control sources, and references to control names in queries and VB code. View screen prints.


Image File Utility

Browse image files using MS Access image control, search by title or by description, copy to other folders. View screen prints.


Alternative Security Tool

Intuitive security wizard makes it easier to move users to and from groups. View screen prints.


About the Author
Allen Beechick is a Microsoft Access consultant. Do you need a productive consultant for your project? Send your specs and receive a free bid.


A Faster Sorting Algorithm - twice as fast as Quicksort, guaranteed

Frugal shoppers rave about the aisle-by-aisle grocery list software that simplifies day-to-day shopping chores.


Webmasters: link to us and get free software in exchange



eXTReMe Tracker