fbpx
Logo
Mail us
ben@accessdatabasetutorial.com

Category Archives: Forms

Microsoft Access Database 2013 Tutorial On Forms


ms access forms

MS Access forms are ways of making your data entry convenient, safe without exposing its profound work to most database users and provide a smooth workflow reflecting business practices. The benefit of taking the time to build good and workable forms will pay dividends later. Importing/Creating The Database In creating an access form, the first thing you need to do is to either import or create the database. As a pre-step, follow the simple steps below: When you open your Microsoft Access […]

Tags: , , , ,

Microsoft Access Database Tutorial: Creating a Menu Form


Microsoft Access Database

In this tutorial you will learn how to create a main menu form in your Microsoft Access Database. Take a quick look at the video tutorial below which will step you through the very basics as I’m often asked how easy is it to build your own MS Access menu forms. Ignore the general look and feel of the forms demonstrated but more importantly, notice how easy it really is to create command buttons using the built-in wizard generator tool. […]

Tags: , , , ,

Microsoft Access Database 2013: Building A Navigation Control Form


Microsoft Access Database

This quick three and half minute video tutorial will demonstrate how easy it is to build Microsoft Access database navigation control forms keeping the controls and property settings to a minimum whilst also utilising the ribbon bar too… There’s no voice over but some light melodic tones to easily follow the tips and techniques in building that navigation control form. Microsoft Access Database 2013: Building A Navigation Control Form Of course, one assumes you have also pre-prepared and built either […]

Tags: , , , ,

Microsoft Access Database Forms: Highlight Current Record For A Continuous Form


Microsoft Access Form

As you migrate from version to version, working with Microsoft Access database forms becomes more intuitive and easier to design and implement using the pre-built templates, wizards and improving richer set of formatting tools. Conditional formatting (once it was introduced) started life as a setting for up to three conditional formats which satisfied most requirements but now the with the later versions, it’s layered and can exceed this number for true flexibility and complex conditioning. The point here is what […]

Tags: , , , , ,

Sending Email Using Microsoft Access VBA


Microsoft Access VBA

If you use the later versions of Microsoft Access, you will have probably come across the tool to set and manage emails to normally Microsoft Outlook from a selected table or query and select individual valid records but this can be problematic with connection, server and services if not correctly configured. There is a custom built solution which talks about sending email using Microsoft Access though it is not a free utility, it does have a free locked demo to […]

Tags: , , , ,

Microsoft Access Database – Working With Two Digit Hour Time Formats


Microsoft Access

Here’s a quick Microsoft Access tutorial video I found about applying formatting to the date/time data type control concentrating on the two digit hour time format that doesn’t always show up in two digit form. Even if you create a custom date/time format within Microsoft Access, the two-digit hour which is supported using the convention of “hh” via the format property doesn’t always work. It will show a single digit hour even though you’ve specified the right code. Take a […]

Tags: , , , , ,