Access Tips

DATABASE / TABLE / FORM/SWITCHBOARD Tips

Creating a Database & Table - Basics

Table fields - required, adding, deleting

Importing data into a table from Excel - single primary key

Importing data into a table from Excel - multiple field primary key

Data Validation within a Table
validation rules (numbers/text), error messages, required fields, input mask

Creating Relationships between Tables

Creating/Editing a Form - Basics

 Creating a Lookup Field from a List   ~   Creating a Lookup Field from a Table

Switchboards

Info on installing the switchboard manager in Access 2010

QUERY Tips

Selecting Tables for Queries

Numeric Criteria
Greater Than, Less Than, etc.

Parameter Basics

Wildcard Basics (*)

Combining Wildcards & Parameters

Advanced Wildcards
* ? #

Calculated Fields

'How to Calculate Markup Percentage'

Using IIF

Using And / Or Operators

Using the NOT Operator

Using Between,  And / Or

Grouping

Using Top Value within a Query

Formatting Fields & Sorting
(including multiple sorts)

Formatting the Datasheet View

REPORT Tips

Creating / Editing with the Report Wizard - Basics

Report Formatting - More Advanced

Creating a Quick Report from a Query

EXPORTING Tips

Exporting to an Excel workbook

General Tips on Copying Files / Showing File Extensions

Note:  if you are working ahead & don't see the TIPS you need OR you are looking for Access 2003 Tips, check the Old Tips  for additional demos.