Caveat On This Review
The caveat on this review of MS Access Ingenious Guru Tools is that we have as yet been unable to obtain a review copy of the program. Therefore the claims made are from the sales letter and have not yet been substantiated in an independent working environment.
We can say that there are no negative reviews of the product and that the two reviews we saw gave an overall 8.3/10. No further details were available, so the source and integrity of those reviews cannot be verified.
Should the authors decide to respond to our request and provide us with the means to test their claims we will review based on experience with the scripts.
MS Access is a serious program for creating relational databases. The level of design complexity able to be produced straight out of the box is impressive.
The average database builder will find it more than adequate for their needs, and any expenditure on enhancement would be a waste of resources.
However this is not the case when you start to become serious about programming in Access.
Here is where the flaws in Access become apparent. Flaws that make creating databases so full of mind numbing repetition and grunt work that there is no longer any joy in the process of creation.
MS Access Ingenious Guru Tools
Gives you eight smart wizards that enable you to reduce the time it takes to build your database by automating some of the “fiddly” but very important tasks, that underpin good structure and design.
Tasks such as:
- Creating customised templates that reflect what you want to say.
- Creating Forms and sub-forms with command buttons already in place and fully functional.
- The ability to point to specific fields on a form and generate a report using them.
- Ability to locate and decipher all your queries and map their relationship to one another
But that is just the beginning, the eight (8) wizards described below take a giant leap beyond the basic Access wizards. Why?
- Because they automate more things.
- Because they come with VBA code, giving you more control.
The eight tools are described in depth below. Then all that remains is for you to give them a try.
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.
Want To make that a one click process, with benefits?
The benefit is that you can add buttons of your choice, each with appropriate functional code and include that in the one click. That is table, form, functional buttons.
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 also comes with VBA code included, giving you full control, and so you can make this smart wizard even smarter.
Once you have planned your form, click Create Form and it’s done!
Well not quite, you then have a few more related options such as label position that can give your form a different look.
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, and once you do, 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.
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.
This tool turns the nightmare into a dream.
Report Creator Development Tool
Making reports in Microsoft Access traditionally has been a step-by-step process.
- You decide what fields you want on the report.
- You figure out from what tables those fields come.
- You make a query that grabs those fields.
- You make a report based on that query.
- You make sure the look and feel of this report reflects your other reports.
- You equally space the controls on the report.
- You add summary controls to the footer.
There are probably more steps that others would include but these will do for now.
This tool allows you to skip most of the above steps.
- You open the form that has the fields you want. Not the table or a query 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.
- Next, use the 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.
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.)
Report Designer Development Tool
When modifying an Access report, do you forget:
- Which group sections are visible or invisible?
- Which fields are left 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 have many sections or control that’s a lot of clicking.
This tool puts all the properties at your fingertips in one place and gives you the ability to change them from that place.
Report Criteria Development Tool
Does your Access application run reports?
Do your users like to run those reports using certain criteria (like date range)?
Setting that up on Access is time consuming asnd if there are more than a few criteria its very time consuming.
This tool enables that task to be completed very quickly.
It 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.
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.
Export Objects Development Tool
After using the above 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.
Autokeys Development Tool
Want more shortcuts?
Here is 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
All these development tools come with the VBA code behind them.
That means you not only get the tools themselves, and can modify them.
You can also use the sample code to learn from. 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
Get Your Copy 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 HERE.