Tips and Articles for Microsoft Access

Here are several informative, free Access Tips, Techniques, and Articles for Beginning, Intermediate, and Advanced Microsoft Access users, from 599cd.com, which is a fee-based training site. These will help you learn how to use many important features and functions of Access so you can manage and present your data more efficiently. Some of these include: Parameter Queries, Forms Control, Calculated Query Fields, Time/Date Differences, Update Queries, Working with Relational Tables, Aggregate Queries, Using Two Combo Boxes, the DLookup Function, the IIF Function, and Many-to-Many Relationships.


Beginner Access Tips:

Creating a Parameter Query
   Entering criteria at run-time
String Concatenation
   FirstName & LastName together
Different Form Controls for Gathering User Input
Calculated Query Fields
   LineTotal: Price * Quantity
Form Control Wizards Not Starting


Intermediate Access Tips:

Number of Months Alive
   DateDiff, DateAdd, IIF, Round
Form Footer Totals
   Sum up the values on a form
Time/Date Differences
   Calculate the difference between two times/dates
Building an Update Query
   Changing field values automatically
Using a Relational Combo Box
   Selecting a customer on a related form
Making Relational Tables
   Proper Normalization Techniques
Getting Query Criteria from a Form
  Forms!FormName!Field Notation
Creating an Aggregate Query
   Adding up customer sales in a query


Advanced Access Tips:

Using MsgBox and vbYes to Close a Form
   Form Properties
Breaking Up Text Strings
   InStr, Replace, Left, Right, Trim
Incrementing Your Own Counter
   DMax Function, BeforeInsert Event
AfterUpdate Event
   Running VBA code after a field value is changed
Two Combo Boxes
   Filter one combo box by value selected in the other
Using the DLOOKUP Function
   Changing fields after pick a customer
Using the IIF Function
   Add IF/Then functionality to queries
Prevent Duplicate Values on Multiple Fields
  BeforeUpdate event
Resize a Form using VBA Code


Access Learning Articles:

Access Tip: MsgBox with vbYes
Access: Removing THE From Title Sorts
Access: Next Business Day
Access: Reading Outlook Calendar Data
Access: Recordset, File I/O Example
Access: Many-To-Many Relationships
Access: Checking a Sequence of Numbers
Access: Daylight Savings Time
Access: Recordsets & Inventory
Access: Calculate 2nd Monday in January