Access Database Forms: Should We Use Unbound Forms?
I’ve always been a big fan of Microsoft Access databases, why? Because I like the way a rich application like this can be customised and designed from the floor up with little IT programming and development knowledge. Plus, I like building things 🙂
As a recap, knowing the difference between what an unbound versus a bound Access form is will help divide the distinction and allow you to determine which approach will suit best.
MS Access like any other development IDE will provide an endless set of properties across the ‘one-stop shop’ set of objects and forms are no different. One property we are talking about of course is Continue reading “Access Database Forms: Should We Use Unbound Forms?”
Access Form Designs – How To Create A Report Interface For Your Access Database
For the more polished and professional database, using Access form designs doesn’t necessarily mean viewing records from tables and queries. It can also serve as a general way to manage your MS Access database objects namely Access reports.
For example, running reports from a nicely designed form showing a list of available reports that calls another form (perhaps for its criteria) before it actually displays the preview or hard copy report can improve the usability of your custom built application.
By having an Access form design to list all the reports in a List Box control with a series of command buttons to choose the output (how they run), drives the Continue reading “Access Form Designs – How To Create A Report Interface For Your Access Database”
Microsoft Access Security: How To Login Into Your Access Database
With the release of Microsoft Access 2007 introducing a new file format (ACCDB), the Microsoft Access security completely changed. In fact, it dropped the MDW workgroup security utility altogether in favour of trusted locations and/or using SharePoint.
However, I wanted to have the ability to control my own collection of objects within my Access database and not rely on either a third party tool or online service but instead keeping it all in one place having full control of my database.
You can still apply a basic and global database file password to your ACCDB files but everyone will need to use the same password and gain access to all areas of your database – not really recommended!
So, how can you login into your own custom built database with the later versions (2007, 2010 & 2013) and take full control or your own access rights?
Well, the simple answer is to build it yourself and mimic the Workgroup and Access Rights utility of old.
Check out: Building Your Very Own Access Database Security Offer
The advantage here of course is you have full control of what level of security you really need and eliminate all the unwanted other elements that Continue reading “Microsoft Access Security: How To Login Into Your Access Database”
Microsoft Access Forms: What Are The Pros And Cons Of Using Unbound Access Database Forms
As you may have gathered, one of my roles within this niche covers IT software training. When teaching Microsoft Access forms (usually during day 2), delegates would normally be shown the quickest method of creating such forms and that means using either the Access form templates or the built-in wizard tool.
This of course means most forms (if not all) are ‘bound‘ forms or in other words, have a data source file attached whether it be a table or query.
In fact, when I train this area of MS Access, I normally categorise into four types of use for such an object; these are:
1. Data Entry Form – Forms which
Continue reading “Microsoft Access Forms: What Are The Pros And Cons Of Using Unbound Access Database Forms”