Microsoft Access Database: Choose Between Microsoft Access and Excel
A useful article on how to Choose between Microsoft Access and Excel which contain eleven pages stepping you through the main differences which include:
- Relational means data in multiple tables
- The advantages of relating
- Flat keeps it all together
- To relate, or not to relate?
- More questions, more clarity
- Solid reasons to use Access
- Solid reasons to use Excel
There is a quick ‘Test you lnowledge’ at the end and hopefully it will clear the myst between which to choose; Microsoft Access database or Excel?
VBA (or Visual Basic for Applications) is the main programming language used in Microsoft Access and it provides a rich set of functionality enhancing and adding the ‘bells & whistles‘ to your database application.
You will need to start protecting the VBA code (which is stored in a module) and the following quick video tutorial shows you how…
Protecting your VBA Code in Microsoft Access Database
As the author says, it adds an extra layer of protection and anyone with half a brain will be able to view and change code once they managed to gain access to the module – imagine if they had only a quarter or a brain!
Microsoft Access Database Tutorial – My Tip
When setting a password, ensure it’s not an obvious word (a pet name, favourite football team) that could be easily be guessed. Try and mix characters with digits to make a little tougher to guess and break open and remember passwords are case senstive here in your Microsoft Access database VBA module.
I found this short article on how Microsoft Access databases have some real (and great) advantages especially keeping it a low cost and low maintenance database application (when designed properly).
Here’s the article…
Remarkable Advantages of Microsoft Access Database System
Microsoft Access is very flexible and potent database management solution. As compared to other database systems, Microsoft Access Database is a less expensive alternative since it does not require large amount of set up and maintenance cost. It is developed by Microsoft and Continue reading “Microsoft Access Database: Remarkable Advantages of Microsoft Access Database System”
This quick and simple video tutorial clearly shows you how to hide a table in Microsoft Access and add just a little more protection or privacy to certain key and sensitive data files and is typically aimed at a table in Microsoft Access
Microsoft Access Database – My Comments
This tutorial demonstrated was using Microsoft Access version XP/2003 and this feature also applies to the later versions. All you need to do is right mouse click the ‘Navigation Pane’ and choose ‘Options’ where you can then hide and show objects too.
All objects which include queries, forms and reports can be controlled this way and is the first basic step and layer towards protecing your Microsoft Access Database application.
Microsoft Access Database – Latest EzineArticle Release
If you haven’t been keeping upto date with my articles from EzineArticles then checkout this one about Microsoft Access Database Locking files.
The Most Important Locking File (LDB or LACCDB) Within Microsoft Access
Have you noticed when you open an Access database that it generates another (same named) file but with a locking file extension of either an LDB (Microsoft Access 2003 or earlier) or LACCDB (Microsoft Access 2007 or later)?
This file should automatically generate and extinguish itself when opening and closing your Access database and the upshot is that Continue reading “Microsoft Access Database: Using The Locking File (LDB or LACCDB) Within Microsoft Access”
Using Microsoft Access 2010 with Microsoft Office 365, you can use your Windows 7 (mobile phone operating system) to read and update your Access database via the web.
Take a look at this quick demonstration which will require certain services to be in place including Microsoft Enterprise Services.
Microsoft Access Database Tutorial – My Comments
You will need to have several products and services in place to fully utilise this useful tool via your mobile phone. Therefore, it will need to include Microsoft Office 365 which is a monthly and affordable plan.
You will also need to know something about SharePoint 2010 and how to publish an Access database to the web using this or a similar Microsoft Access service.
As with all Microsoft Access database applications, using the conventional search tool (Find Command) is basic but does exactly what is says on the tin!
This quick video tutorial shows your how you find data values in Microsoft Access 2007 highlighting the basic options that can be used across one or all fields.
Use Search in Microsoft Access 2007
The problem here is that users are searching for values directly in either a table or a query and leaves your data unprotected from editing and other unwanted changes to your recordsets.
How you can one protect your data and still have the flexibility of searching for records (especailly if you are not comfortable or knowledgeable with Microsoft Access form designs)?
This is where I can help!
Take a look at my Search Tool Utility Offer and take the next step to having a rich search and customisable tool for your Microsoft Access database system.
Microsoft Access Database: Using the Access Built-in Switchboard Manager Utility
This video tutorial quickly demonstrates how to use the built in Microsoft Access Switchboard utility which as been around for a very long time now.
It applies up to Microsoft Access version 2007 though with the newer version for Access 2010 now uses the prefered Navigation Form object.
Microsoft Access 2007: Switchboard Manager Tricks
The trick demonstrated is simple just common sense by learning to copy and paste objects (forms or reports) you wish to call (open or edit) and avoiding mistyped characters.
It is only the narrative that is being changed and therefore can be anything you like.
Finally, you need to understand that this tool in Mircrosoft Access uses a bound table to the (menu) form being generated and can be edited directly in the Access table but do so with caution – learn the structure first!
Take a look at my eBook about How to Build Microsoft Access Forms which covers in detail all the essential tips and tricks.
Microsoft Access (all versions) is widely underused – This is due to two main reasons; a) users are just not aware this powerful software is available with the Microsoft Office suite and b) users just do not how to build and use Microsoft Access
The following article highlights to power and flexibility that Microsoft Access offers and should be seriously considered when implementing a database.
Microsoft Access – The Indispensable Tool For Databases
Nowadays there is no need for worrying about tracking the large quantities of data in a company. Instead of using a paper file system, it is easy to make use of a database for these purposes. The collection of data, that is, the database provides Continue reading “Microsoft Access Database: The Indispensable Tool For Databases”