Access Database Forms: Should We Use Unbound Forms?

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.

access-database-forms-should-we-use-unbound-forms

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

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.

access form designs - reports

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 Forms: What Are The Pros And Cons Of Using Unbound Access Database Forms

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.

microsoft access forms

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”