Miscellaneous Microsoft Access Tutorials

Mailing Lists in Microsoft Access
In this tutorial, we examine the process of creating mailing labels using Microsoft Access using the built-in Label Wizard. We begin with a database containing the address data and walk you step-by-step through the process of creating and printing your mailing labels.

Microsoft Access Tips and Tricks
The Microsoft Access software tools provide simple programming capability that does not require extensive knowledge or years of training. With any small business, effectively managing a database and controlling information within the company ensures the ability to operate efficiently.

Create and use speech recognition user profiles
Speech recognition user profiles store information about how to recognize your voice. You can create profiles for multiple users on the same computer. You can also create additional profiles for yourself when working in environments with different levels of noise or using different microphones.

Use speech recognition
You'll save time if you complete dictation first, review your file, and then format text or make corrections. As a result, you'll switch between using Dictation mode and Voice Command mode less often.

Install handwriting recognition
This feature is available in the Simplified Chinese, Traditional Chinese, English, Japanese, and Korean language versions of Microsoft Office.

Turn on or off the speech recognition microphone
Turn or or off microphone with voice command.

Add or delete a shortcut from the My Places bar
Learn how to add or delete a shortcut from the My Places bar.

Conditional Statements
One of the goals of computer programming is telling the computer what to do when something occurs, and how to do it. This is performed by setting conditions, examining them and stating what decisions the computer should make. To perform the necessary conditions, you have two main options: Microsoft Access or Microsoft Visual Basic. Microsoft Access is equipped with a series of operators and functions destined to perform various operations. To use a condition in Microsoft Access, if you know the structure of the conditional statement, you can write it after typing an assignment operator. Because most conditions in Microsoft Access are in the form of functions, we will study them later on. For now, we will learn how to write conditions in the Microsoft Visual Basic language. Topics: Topics: Logical Operators, The If...Then Statement, The If...Then...Else Statement, The If...Then...ElseIf Statement, The Select Case Statement, Looping and Counting.

Restrict the Data in a Field
In a Microsoft Access 2003 table or database, you can restrict the data in a field to certain values. Controlling the types of data that someone can enter into a field prevents bookkeeping errors and incorrect database entries. Take these steps to restrict data in a field to certain values in Access 2003.

Add a submenu to a menu
You can add a submenu to a built-in or custom menu.

Naming Database Objects
Just as using an object and variable naming convention can help you write cleaner code, a database object naming convention can help you manage the many objects you create in a database schema. I've developed and refined a standard that has worked exceptionally well for me in my database applications.

Change speech recognition engines
How to change speech recognition engines to dictate in another language or to use a third-party engine.

Customize driver settings
Customize text driver settings, Customize Microsoft Excel driver settings, Customize dBASE driver settings, Customize Paradox driver settings, Customize Lotus driver settings, Customize Microsoft Exchange driver settings, Customize ODBC driver settings, Customize HTML driver settings.

Table, Query, and Form Printing
Printing consists of writing or drawing, on a piece of paper, the values held by an object of a database. This means that you can print from a table, a query, or a form. Before doing this, of course the object must exist and it must have records. To print from a table, a query, or a form, in the appropriate section of the database window, right-click the object and click Print... When you do this, the document is sent directly to the printer. Topics: Table, Query, and Form Printing, Report Fundamentals, Designing a Report, Using a Report and Report Maintenance.

Access Shortcut Keys for Entering Data in a Datasheet/Form
Shortcuts or hot keys for entering data in a Datasheet/Form.

Show all buttons or commands
How to Show all the buttons on a toolbar and Show all the commands on menus.

Use handwriting recognition
Write as you naturally do on a paper surface, using cursive style, printing, or a combination of both. As you write, enter entire words without pausing after each letter, and leave space between words.

Assign a hyperlink to a toolbar button or menu command
When you assign a hyperlink to a toolbar button or menu command, the hyperlink replaces the command currently assigned to that button or menu command. You cannot assign a hyperlink to a button that displays a list or menu when clicked.

Add a button, menu, or command
Do one or more of the following: Add a button, menu, or command to a toolbar, Add a button, menu, or command to a toolbar (keyboard accessible), Add a command to a menu, Add a command to a menu (keyboard accessible).

MsgBox Arguments
The MsgBox function is one of the most commonly used functions within Access. It is a method of interacting with the user during a session. Therefore, you must accurately select the buttons for your MsgBox. Below is a table that lists all of your MsgBox options.