My latest EzineArticle talks about why you would use Microsoft Access Forms to search for data giving that extra layer of protection when controlling record searching and filtering.
As with all versions of Microsoft Access databases and general software, no application is worth their salt unless you can either find or search for data, records or values in a document whether it be a text file or a long data list.
In Microsoft Access, using the conventional search tool (or Find Command – CTRL + F) is basic but it does exactly what is says on the tin! This is used in a table, query, form or any other output that can display records.
There are some issues when using the Find command in Microsoft Access:
- You are searching for values across records or fields in the ‘back-end’ of the database causing a potential risk to the data being changed or worse still, deleted.
- The Find command is very basic by design and is limited to how you find values in a table, query or a form.
- Using a query requires a basic understanding of how to design one and how to set and use criteria.
- Using the basic criteria and filtering options in a table still runs the risk of records being abused.
How does one protect your data and still have the flexibility of searching for records within Microsoft Access?
Well, build your own custom Micirosoft Access form (normally with some VBA code) and provide a protected layer of functionality to allow users to look but not touch the data!
The benefits of having a Microsoft Access form instead is:
- You cannot gain direct access to your data thus protecting it.
- You can add any functionality you wish, as it’s your own design.
- It can be used to provide better security for general users who may have different roles and access rights.
- From a customised Microsoft Access form, you can navigate and drill-down to other related (or non-related) records.
- The custom form becomes user-friendly!
So how do you go about building such a form?
The simple answer is, you either learn how to build Microsoft Access forms or get someone to build it for you or perhaps maybe, just maybe someone has already built a utility ready for you use!
Another Tip for you! Learning to build Microsoft Access forms including VBA code will give the full control of how your data and reporting needs can be achieved.
I invite you to keep up to date with my articles and eBooks which covers a lot of details and can be found at http://AccessDatabaseTutorial.com.
BTW: Check out my special offer of “How to Use and Re-Design Your Very Own Microsoft Access Database Search Tool Utility” which has recently been reduced at http://AccessDatabaseTutorial.com/Offer/SearchToolUtilityOffer – It comes with a money back guarantee – what do you have to lose?
From Ben Beitler – “Your Access Database Expert”
Article Source: http://ezinearticles.com/expert/Ben_S_Beitler/840635
Microsoft Access Database Tutorial – Final Thoughts on Microsoft Access Forms
Many Access users struggle to build forms and other objects as there is a learning curve to anything which is new and not intuitive. Microsoft Access Forms is no different and to help you along, I have included a ready built Search Tool Utility which is supplied with a bonus eBook on How to build Microsoft Access Forms.
Microsoft Access Forms
Take a look at this video demonstration of the search tool in action:
It comes with a 100% money back guarantee – no questions asked!
How to Use and Re-Design Your Very Own Microsoft Access Database Search Tool Utility
Tags: access database form designs, building access forms, how to build an access form, microsoft access forms, searching an access database
Nice piece, Ben, and an excellent video!
I use the Ctrl*+F quite a lot. Now I will admit that Access is not my strength – but your new finder, using the Access Forms, are these macros?
*(is there any nicer way to write Ctrl??! It is Strg in German, “Steuerung” – but is quite as unpretty as an abbreviation! – I digress!)
I haven’t used macros but instead used VBA code which can be opened and modified as part of the utility that I offer.
As far as CTRL accelerator is concerned, I have no nicer way other than to say ‘CONTROL key’!!!!!