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